pgsql-sql since 2006-09-20 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. 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
Re: optimal insert Markus Schaber 12:31
Re: deleting rows in specific order Markus Schaber 12:48
Re: deleting rows in specific order Daniel Drotos 19:31

Oct. 12, 2006

Thread Author Time
slow view Stuart 01:18
Re: slow view Stuart McGraw 04:15
Is this a bug? Deleting a column deletes the constraint. Bryce Nesbitt 05:11
Re: Is this a bug? Deleting a column deletes the constraint. Tom Lane 05:25
Re: Is this a bug? Deleting a column deletes the constraint. Joe 09:39
Re: Is this a bug? Deleting a column deletes the constraint. Tom Lane 14:39
Re: Is this a bug? Deleting a column deletes the constraint. Chris Browne 14:56
Re: Is this a bug? Deleting a column deletes the constraint. Florian Weimer 16:19
spliting a row to make several rows Gerardo Herzig 22:18
Re: spliting a row to make several rows Bricklen Anderson 22:42
Re: spliting a row to make several rows Gerardo Herzig 23:00

Oct. 13, 2006

Thread Author Time
could not connect to server ivan marchesini 06:52
Re: could not connect to server A. Kretschmer 07:27
Re: could not connect to server ivan marchesini 09:01
Re: could not connect to server A. Kretschmer 09:18
Re: deleting rows in specific order Markus Schaber 11:48
Re: could not connect to server Tom Lane 14:07
Re: storing access rights in a postgres database Aaron Bono 21:16

Oct. 14, 2006

Thread Author Time
Foreign key reference counting strategy? Joost Kraaijeveld 12:25
Re: Foreign key reference counting strategy? Markus Schaber 13:52
Re: Assigning a timestamp without timezone to a timestamp chrisj 21:42
Re: Assigning a timestamp without timezone to a timestamp Tom Lane 23:26
Re: Foreign key reference counting strategy? Michael Fuhr 23:48
Re: Foreign key reference counting strategy? Tom Lane 23:58

Oct. 15, 2006

Thread Author Time
Re: Foreign key reference counting strategy? Michael Fuhr 00:11
Re: Foreign key reference counting strategy? Tom Lane 00:20
Re: Foreign key reference counting strategy? Michael Fuhr 01:07
Re: Foreign key reference counting strategy? Tom Lane 02:10
conversion of numeric field from MSSQL to postgres Kenneth Gonsalves 12:31
migrating numeric to serial from MSSQL to postgres Kenneth Gonsalves 13:05
Re: migrating numeric to serial from MSSQL to postgres Daniel CAUNE 13:49
Re: migrating numeric to serial from MSSQL to postgres Terry Fielder 13:54
Re: migrating numeric to serial from MSSQL to postgres Daniel CAUNE 15:23
Temp tables, reports in Postgresql (and other RDBMS) ow 16:08
Re: Temp tables, reports in Postgresql (and other RDBMS) Tom Lane 16:54
Re: Temp tables, reports in Postgresql (and other RDBMS) ow 18:10

Oct. 16, 2006

Thread Author Time
Re: Assigning a timestamp without timezone to a timestamp chrisj 02:32
Recursive pl/pgsql function ... Marc G. Fournier 02:39
Re: Recursive pl/pgsql function ... Tom Lane 03:27
Re: Assigning a timestamp without timezone to a timestamp Tom Lane 03:31
Re: Recursive pl/pgsql function ... Marc G. Fournier 06:16
Re: Recursive pl/pgsql function ... Markus Schaber 09:20
hi i want help on levels Penchalaiah P. 14:47
Re: get_next_billing_date() ... Marc G. Fournier 17:25
Re: deleting rows in specific order Bruno Wolff III 17:51

Browse Archives

Prev | Next