pgsql-sql since 2006-09-13 00:00

Discussion for users on SQL related matters.

Search the Archives

(enter a message-id to go directly to that message)
Advanced Search

Browse Archives

Prev | Next

Sept. 13, 2006

Thread Author Time
Re: How to get all users under a group Emi Lu 13:51
Aggregates with internal state type? Markus Schaber 20:34
Re: Aggregates with internal state type? Tom Lane 21:13
Re: Aggregates with internal state type? Markus Schaber 21:19
Re: Aggregates with internal state type? Tom Lane 21:25
Re: Aggregates with internal state type? Markus Schaber 21:44

Sept. 14, 2006

Thread Author Time
How to delete multiple records Javanesevn 06:07
Re: How to delete multiple records Reinoud van Leeuwen 07:09
Re: How to delete multiple records Markus Schaber 07:13
nested select within a DISTINCT block zqzuk 12:02
nested select within a DISCTINCT block zqzuk 17:13
Re: nested select within a DISCTINCT block Daryl Richter 21:58
Re: nested select within a DISCTINCT block zqzuk 22:11

Sept. 15, 2006

Thread Author Time
Re: nested select within a DISCTINCT block Niklas Johansson 01:24
lower() not working correctly...? Andreas Joseph Krogh 07:52
lower() not working correctly...? Andreas Joseph Krogh 08:06
Re: lower() not working correctly...? Mario Weilguni 08:21
Re: lower() not working correctly...? Guillaume Lelarge 08:44
Re: lower() not working correctly...? A. Kretschmer 08:44
Re: lower() not working correctly...? Amit_Wadhwa 08:50
Re: Sorting items in aggregate function (thanks) Steven Murdoch 09:15
Omission of 'FROM' ? diff between pgsql 7.4.1 and pgsql 8.1.4 gould 09:16
Re: Omission of 'FROM' ? diff between pgsql 7.4.1 and pgsql 8.1.4 Milen A. Radev 09:29
Re: Omission of 'FROM' ? diff between pgsql 7.4.1 and pgsql 8.1.4 A. Kretschmer 09:36
Re: [HACKERS] lower() not working correctly...? Ragnar 10:07
Re: Aggregates with internal state type? Markus Schaber 14:41
Dividing results from two tables with different time frames Becky Hoff 15:34

Sept. 17, 2006

Thread Author Time
Re: Dividing results from two tables with different time Ragnar 10:05
Transactional behaviour with trigger Joost Kraaijeveld 12:32
Re: Transactional behaviour with trigger Michael Fuhr 14:36
Re: Transactional behaviour with trigger Joost Kraaijeveld 14:56
Re: Dividing results from two tables with different time frames Aaron Bono 16:16

Sept. 19, 2006

Thread Author Time
inner join is much faster! is that right? James Im 09:21
Borland Database Engine assumes Varchar(255) as Memo Ezequias Rodrigues da Rocha 12:11
Re: inner join is much faster! is that right? Chris Mair 12:29
Re: inner join is much faster! is that right? James Im 13:44
Nested loops are killing throughput CG 14:46
Re: Nested loops are killing throughput Tom Lane 15:03
Count and list only where count is bigger than 1 Ezequias Rodrigues da Rocha 15:04
Re: Count and list only where count is bigger than 1 📎 Mezei Zoltán 15:09
Re: Count and list only where count is bigger than 1 bnichols 15:09
Re: Count and list only where count is bigger than 1 A. Kretschmer 15:15
Re: Nested loops are killing throughput CG 18:05
Re: Nested loops are killing throughput Tom Lane 18:17
Re: Nested loops are killing throughput CG 18:59
Make Trigger run after completion of ENTIRE transaction Henry Ortega 19:00
Re: Nested loops are killing throughput Tom Lane 19:15
Re: Nested loops are killing throughput CG 20:36

Sept. 20, 2006

Thread Author Time
Need a SQL to create sets of hobbies CN 05:18
Re: Make Trigger run after completion of ENTIRE transaction Markus Schaber 09:24
Re: Need a SQL to create sets of hobbies Harald Fuchs 11:33
Re: Dividing results from two tables with different time frames Aaron Bono 17:24
Re: Nested loops are killing throughput CG 18:10
Re: Need a SQL to create sets of hobbies Aaron Bono 18:38
ERROR: could not write block 196261 of temporary file: No space left TJ O'Donnell 22:00
Re: ERROR: could not write block 196261 of temporary file: No space left Tom Lane 22:31

Sept. 21, 2006

Thread Author Time
UnSubscribe vijay balan 04:47
unique rows TJ O'Donnell 05:18
UnSubscribe dmz 06:13
Unsubscribe David Klugmann 06:36
Re: unique rows Kaloyan Iliev 07:33
Re: unique rows Markus Schaber 07:46
Re: Help with optional parameters Curtis Scheer 22:18
Re: Help with optional parameters MaXX 22:48

Sept. 22, 2006

Thread Author Time
Group by minute Ezequias Rodrigues da Rocha 13:52
Re: Group by minute Niklas Johansson 14:10
Re: Group by minute 📎 Mezei Zoltán 14:14
Re: Group by minute Scott Marlowe 14:56
Re: nested select within a DISTINCT block Bruno Wolff III 17:28
How to autoincrement a primary key... Doug Hyde 19:13
Re: How to autoincrement a primary key... Richard Broersma Jr 19:25
Re: How to autoincrement a primary key... Andrew Chilton 22:00
Re: How to autoincrement a primary key... Thomas Kellerer 22:12

Sept. 23, 2006

Thread Author Time
Re: How to autoincrement a primary key... Aarni Ruuhimäki 06:27
Re: unique rows TJ O'Donnell 14:43

Sept. 26, 2006

Thread Author Time
Populating using Select Ezequias Rodrigues da Rocha 12:35
Re: Populating using Select Andrew Sullivan 12:52
Finding context for error log Kyle Bateman 14:19
Re: Finding context for error log Tom Lane 14:56
Re: Populating using Select Ezequias Rodrigues da Rocha 18:38
Re: Finding context for error log Vivek Khera 19:37

Sept. 27, 2006

Thread Author Time
Query regarding Writing a report using the file sysstem data processing extensions Dinesh Tiwari 13:14
Re: Query regarding Writing a report using the file sysstem Markus Schaber 14:33
Re: unique rows Bruno Wolff III 20:27

Sept. 28, 2006

Thread Author Time
files or DataBase tomcask o_o 22:37

Sept. 29, 2006

Thread Author Time
Re: files or DataBase Jim C. Nasby 01:06
Re: files or DataBase Gregory S. Williamson 02:12
regexp_replace usage chester c young 21:31
tree-structured query chester c young 22:00

Sept. 30, 2006

Thread Author Time
How to FindNearest Alexander Ilyin 08:43
Re: tree-structured query Ragnar 22:29

Oct. 2, 2006

Thread Author Time
Re: regexp_replace usage Michael Fuhr 03:56
Re: regexp_replace usage chester c young 15:15
Doubt with Joins Ezequias Rodrigues da Rocha 15:41
SEQUENCES Rodrigo Sakai 16:39
Re: SEQUENCES Andrew Sullivan 16:49
Re: SEQUENCES Thomas Kellerer 16:51
Time interval sums A. R. Van Hook 20:58
Re: Time interval sums Tom Lane 21:29

Oct. 3, 2006

Thread Author Time
Re: How to FindNearest Bruno Wolff III 00:20
Assigning a timestamp without timezone to a timestamp with timezone chrisj 03:15
LOG: logger shutting down Bryce Nesbitt 04:06
Re: LOG: logger shutting down Tom Lane 04:32
i have table Penchalaiah P. 10:47
Re: i have table A. Kretschmer 10:59
Re: i have table Achilleas Mantzios 11:00
Re: How to FindNearest Alexander Ilyin 11:43
Re: i have table Daryl Richter 11:49
Re: Assigning a timestamp without timezone to a timestamp with timezone Andrew Sullivan 13:56
Re: Assigning a timestamp without timezone to a timestamp chrisj 14:26
Re: Assigning a timestamp without timezone to a timestamp Andrew Sullivan 14:51
Update 3 columns w/ 1 function calc 3 values? paallen 14:55
Re: SEQUENCES Bruno Wolff III 14:59
Re: Update 3 columns w/ 1 function calc 3 values? William Leite Araújo 15:19
Re: Assigning a timestamp without timezone to a timestamp chrisj 15:45
Re: How to FindNearest Bruno Wolff III 17:11
Re: Update 3 columns w/ 1 function calc 3 values? Bruno Wolff III 17:19
Updating from table with multiple possibilities Worky Workerson 17:32
Fw: How to FindNearest paallen 17:35
timestamps over the web - suggestions chester c young 21:44
formatting intervals with to_char Graham Davis 23:03

Oct. 4, 2006

Thread Author Time
Re: timestamps over the web - suggestions Aaron Bono 01:15
Re: timestamps over the web - suggestions ljb 01:35
Re: Fw: How to FindNearest Bruno Wolff III 04:11
Re: Assigning a timestamp without timezone to a timestamp Markus Schaber 09:07
Re: i have table Markus Schaber 09:22
How to overwrite a table [only data]? Ezequias Rodrigues da Rocha 11:40
Re: How to overwrite a table [only data]? Harald Armin Massa 11:50
Re: Assigning a timestamp without timezone to a timestamp christopher wood 13:35
Re: i have table Erik Jones 14:23
Re: i have table Aaron Bono 14:54
Re: [SQL] How to overwrite a table [only data]? Aaron Bono 14:55
Re: i have table Erik Jones 15:37
Re: Assigning a timestamp without timezone to a timestamp Markus Schaber 15:44
Re: i have table Aaron Bono 16:20
Re: Assigning a timestamp without timezone to a timestamp christopher wood 16:35
Re: Update 3 columns w/ 1 function calc 3 values? Markus Schaber 16:36
Re: i have table Daryl Richter 16:37
Re: [SQL] How to overwrite a table [only data]? Markus Schaber 16:49
Re: Assigning a timestamp without timezone to a timestamp Markus Schaber 16:52
Re: i have table Aaron Bono 18:02
Re: formatting intervals with to_char Graham Davis 18:03
Re: Assigning a timestamp without timezone to a timestamp Hector Villarreal 18:04
Re: i have table Scott Marlowe 20:11

Oct. 5, 2006

Thread Author Time
Re: i have table operationsengineer1 01:23
psql hangs during load of pg_dumpall file James Baxendale 04:33
Re: formatting intervals with to_char Aaron Bono 04:39
Re: i have table Achilleas Mantzios 07:32
Re: i have table Tom Lane 13:31
Re: i have table Achilleas Mantzios 15:15
Re: i have table Andrew Sullivan 15:29
timestamp subtraction (was Re: formatting intervals with to_char) Tom Lane 16:50
age() vs. timestamp substraction Martin Marques 18:27
Re: Assigning a timestamp without timezone to a timestamp Andrew Sullivan 18:31
Re: age() vs. timestamp substraction Tom Lane 18:37
Re: age() vs. timestamp substraction Martin Marques 18:43
On Rollback my sequency does not back the initial value Ezequias Rodrigues da Rocha 18:50
Postgresql quey planner William Leite Araújo 19:02
Re: On Rollback my sequency does not back the initial value A. Kretschmer 19:16
Re: Postgresql quey planner Tom Lane 19:20
Re: Assigning a timestamp without timezone to a timestamp chrisj 20:01
Re: Assigning a timestamp without timezone to a timestamp chrisj 20:06
Re: Assigning a timestamp without timezone to a timestamp Andrew Sullivan 20:31
Re: Assigning a timestamp without timezone to a timestamp chrisj 20:45
Re: Assigning a timestamp without timezone to a timestamp Hector Villarreal 20:53

Oct. 6, 2006

Thread Author Time
Re: [HACKERS] timestamp subtraction (was Re: formatting intervals with to_char) Michael Glaesemann 01:32
Re: [HACKERS] timestamp subtraction (was Re: formatting intervals with to_char) Tom Lane 01:36
Re: [HACKERS] timestamp subtraction (was Re: formatting intervals with to_char) Jim Nasby 02:40
Re: age() vs. timestamp substraction Jean-Paul Argudo 09:35
Re: age() vs. timestamp substraction Stephan Szabo 13:56
Re: [HACKERS] timestamp subtraction (was Re: formatting intervals Graham Davis 15:05
SELECT FOR UPDATE/SHARE cannot be applied to the nullable side of an outer join James Robinson 15:31
Re: SELECT FOR UPDATE/SHARE cannot be applied to the nullable side of an outer join Tom Lane 16:25
Re: SELECT FOR UPDATE/SHARE cannot be applied to the nullable side of an outer join James Robinson 16:30
Too much time to delete 19000 rows Ezequias Rodrigues da Rocha 18:10
Re: Too much time to delete 19000 rows Andrew Sullivan 18:26
Re: Too much time to delete 19000 rows Tom Lane 18:27
Re: timestamps over the web - suggestions Bruno Wolff III 18:27

Oct. 8, 2006

Thread Author Time
PG 8.2beta reordering working for this case? 📎 Kyle Bateman 01:00
Re: PG 8.2beta reordering working for this case? Tom Lane 17:49
optimal insert Dirk Jagdmann 21:04

Oct. 9, 2006

Thread Author Time
Re: optimal insert Bruno Wolff III 04:09
Re: PG 8.2beta reordering working for this case? 📎 Kyle Bateman 05:27
Re: PG 8.2beta reordering working for this case? Tom Lane 14:15
Re: i have table Aaron Bono 16:01
Re: [HACKERS] timestamp subtraction (was Re: formatting intervals with to_char) Aaron Bono 19:57
deleting rows in specific order Daniel Drotos 20:14
Re: [HACKERS] timestamp subtraction (was Re: formatting intervals with to_char) Jim C. Nasby 21:54
Re: deleting rows in specific order Frank Bax 22:00
Re: [HACKERS] timestamp subtraction (was Re: formatting intervals with to_char) Josh Berkus 22:09

Oct. 10, 2006

Thread Author Time
storing access rights in a postgres database tv 13:38
Re: i have table Andrew Sullivan 18:30
Temp tables and functions mark.dingee 19:21
Re: optimal insert Aaron Bono 20:45
Re: optimal insert George Pavlov 21:04
Re: optimal insert Dirk Jagdmann 21:12
Re: optimal insert Dirk Jagdmann 21:15
Re: storing access rights in a postgres database Dirk Jagdmann 21:57

Oct. 11, 2006

Thread Author Time
Re: Temp tables and functions Jim C. Nasby 02:11
Re: Temp tables and functions Mark R. Dingee 11:02

Browse Archives

Prev | Next