pgsql-sql since 2005-08-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

Aug. 20, 2005

Thread Author Time
Re: SQL CASE Statements Halley Pacheco de Oliveira 11:25
Problem with self-made plpgsql-function / casting Moritz Bayer 14:54
Re: Problem with self-made plpgsql-function / casting Mark Dingee 15:45
Re: Problem with self-made plpgsql-function / casting Tom Lane 15:51
Re: Problem with self-made plpgsql-function / casting Moritz Bayer 16:00
Re: Problem with self-made plpgsql-function / casting Moritz Bayer 16:04
Data insert 📎 Postgres Admin 17:17
Re: Data insert Michael Fuhr 17:47
Unwanted nested dollar-quoted constants Bernard Henry Voynet 19:27

Aug. 21, 2005

Thread Author Time
nullif('','') on insert Matt L. 01:40
booleans and nulls Matt L. 02:25
returning inserted id Matt A. 19:56

Aug. 22, 2005

Thread Author Time
Numerical variables in pqsql statements Michael Schmidt 00:43
Re: A Table's Primary Key Listing Roger Tannous 10:23
Problem calling stored procedure neil.saunders 13:17
Re: SQL CASE Statements Lane Van Ingen 13:42
Re: Problem calling stored procedure Stephan Szabo 14:12
Re: Problem calling stored procedure Michael Fuhr 14:28
Re: A Table's Primary Key Listing Alvaro Herrera 15:12
PL/SQL Function: self-contained transaction? Marc G. Fournier 17:16
Re: PL/SQL Function: self-contained transaction? A. Kretschmer 18:15
Re: PL/SQL Function: self-contained transaction? Greg Stark 18:20
Why Doesn't SQL This Expression Work? Lane Van Ingen 19:50
Re: PL/SQL Function: self-contained transaction? Richard_D_Levine 19:52
Re: Why Doesn't SQL This Expression Work? Stephan Szabo 20:29
Re: Why Doesn't SQL This Expression Work? Dmitri Bichko 20:42
Re: Why Doesn't SQL This Expression Work? Lane Van Ingen 20:51
Re: SQL CASE Statements Halley Pacheco de Oliveira 21:47

Aug. 23, 2005

Thread Author Time
Re: [PHP] Data insert Jim C. Nasby 00:57
diary constraints Gary Stainburn 08:33
Re: diary constraints neil.saunders 08:57
Re: diary constraints Michael Glaesemann 08:58
Re: diary constraints Gnanavel S 09:00
Re: diary constraints PFC 09:06
Re: diary constraints A. Kretschmer 09:12
Re: Problem calling stored procedure neil.saunders 09:33
Re: Problem calling stored procedure Tom Lane 14:06
Tuple insert missing query in ongoing transaction Szűcs Gábor 15:09
Re: Problem calling stored procedure neil.saunders 15:25
Re: Problem calling stored procedure neil.saunders 16:16
Re: Problem calling stored procedure neil.saunders 19:59

Aug. 24, 2005

Thread Author Time
question Matt A. 05:05
Number of rows in a cursor ? Bo Lorentsen 09:22
Re: Number of rows in a cursor ? Thomas Borg Salling 09:55
Re: Number of rows in a cursor ? neil.saunders 10:00
Re: Tuple insert missing query in ongoing transaction Szűcs Gábor 10:03
Re: Number of rows in a cursor ? Bo Lorentsen 10:27
Re: Number of rows in a cursor ? Bo Lorentsen 10:31
SQLException - SET AUTOCOMMIT TO OFF is no longer supported Dinesh Pandey 11:15
Re: SQLException - SET AUTOCOMMIT TO OFF is no longer supported Dinesh Pandey 11:22
Re: Number of rows in a cursor ? Russell Simpkins 11:36
Re: SQLException - SET AUTOCOMMIT TO OFF is no longer supported Russell Simpkins 11:37
Re: SQLException - SET AUTOCOMMIT TO OFF is no longer supported Russell Simpkins 11:38
Re: Number of rows in a cursor ? John DeSoi 12:08
Re: SQLException - SET AUTOCOMMIT TO OFF is no longer supported Joel Fradkin 12:42
Re: Number of rows in a cursor ? Bo Lorentsen 12:50
Re: Number of rows in a cursor ? Michael Fuhr 13:19
How to join several selects Josep Sanmartí 13:46
Re: How to join several selects Rod Taylor 13:52
Re: How to join several selects Sean Davis 14:03
Re: How to join several selects Michael Glaesemann 14:14
Re: Number of rows in a cursor ? Bo Lorentsen 14:29
Re: How to join several selects Zac 15:26
Re: Number of rows in a cursor ? Michael Fuhr 17:46
Re: how to do a select * and decrypt a column at the same Scott Marlowe 20:46
Can EXCEPT Be Used for To Solve This Problem? Lane Van Ingen 20:47
Re: Can EXCEPT Be Used for To Solve This Problem? Tom Lane 23:21
Re: Can EXCEPT Be Used for To Solve This Problem? Michael Fuhr 23:34
Re: Can EXCEPT Be Used for To Solve This Problem? Michael Fuhr 23:52

Aug. 25, 2005

Thread Author Time
Re: Number of rows in a cursor ? Bo Lorentsen 06:51
table listing queries Daniel Silverstone 11:13
Re: table listing queries Sean Davis 11:27
How this query! Richard Susanto 11:44
Re: table listing queries Hélder M. Vieira 12:16
Re: How this query! Lars Haugseth 12:21
Re: Number of rows in a cursor ? Bruno Wolff III 13:10
Re: How this query! Bruno Wolff III 13:19
Re: Can EXCEPT Be Used for To Solve This Problem? Vivek Khera 14:47
Re: Can EXCEPT Be Used for To Solve This Problem? Mark R. Dingee 15:06

Aug. 26, 2005

Thread Author Time
Tidying values on variable instantiation Bath, David 03:04
Re: Tidying values on variable instantiation Michael Glaesemann 03:39
Re: Tidying values on variable instantiation Russell Simpkins 12:55
Re: Tidying values on variable instantiation Greg Patnude 15:06
Re: Tidying values on variable instantiation Bruno Wolff III 15:20
Re: Tidying values on variable instantiation Chris Browne 16:31
Re: Tidying values on variable instantiation Chris Browne 16:34

Aug. 27, 2005

Thread Author Time
Common patterns for 'store' functions Chris Mungall 00:08
Re: returning inserted id Bruno Wolff III 06:14
Re: booleans and nulls Chris Travers 06:38
Re: nullif('','') on insert Chris Travers 06:45
Re: returning inserted id Havasvölgyi Ottó 12:53
Re: nullif('','') on insert Bruno Wolff III 13:56
Re: Unwanted nested dollar-quoted constants Tom Lane 14:56

Aug. 29, 2005

Thread Author Time
PostgreSQL help Shavonne Marietta Wijesinghe 10:27
Re: PostgreSQL help PFC 11:06
Negative lookbehind assertions in regexs Julian Scarfe 13:11
Re: Negative lookbehind assertions in regexs Bruno Wolff III 16:21
sqlstate 02000 while declaring cursor/freeing prepared statements andy rost 19:28
Re: Numerical variables in pqsql statements Thomas F. O'Connell 19:58
Re: sqlstate 02000 while declaring cursor/freeing prepared statements Michael Fuhr 20:09
Re: question Thomas F. O'Connell 20:10
Re: sqlstate 02000 while declaring cursor/freeing prepared andy rost 20:52
Re: sqlstate 02000 while declaring cursor/freeing prepared andy rost 21:39
Re: sqlstate 02000 while declaring cursor/freeing prepared Michael Fuhr 23:10
ALTER TABLE ( smallinto -> boolean ) ... Marc G. Fournier 23:15
Re: ALTER TABLE ( smallinto -> boolean ) ... David Fetter 23:24
Re: ALTER TABLE ( smallinto -> boolean ) ... Rod Taylor 23:33
Re: ALTER TABLE ( smallinto -> boolean ) ... Tom Lane 23:49

Aug. 30, 2005

Thread Author Time
Re: [SQL] question Matt A. 03:38
Performance issue Ricky Sutanto 08:38
Performance issue Ricky Sutanto 08:42
Time differences between rows, not columns? Amit_Wadhwa 09:44
Re: Time differences between rows, not columns? Anthony Molinaro 11:28
Re: REINDEX DATABASE Achilleus Mantzios 11:53
Re: Time differences between rows, not columns? Amit_Wadhwa 12:08
Re: Time differences between rows, not columns? Anthony Molinaro 12:33
Re: Performance issue Michael Fuhr 12:34
Re: Performance issue Bruno Wolff III 12:42
Re: sql function: using set as argument Akshay Mathur 13:11
Re: ALTER TABLE ( smallinto -> boolean ) ... Greg Stark 13:17
Re: question Halley Pacheco de Oliveira 13:43
Re: question Vivek Khera 14:59
Re: Numerical variables in pqsql statements Thomas F. O'Connell 15:13
plpgsql question Postgres Admin 16:15
Re: plpgsql question Michael Fuhr 16:50
Re: [SQL] plpgsql question Postgres Admin 17:59
Re: booleans and nulls Scott Marlowe 19:47
Re: sqlstate 02000 while declaring cursor/freeing prepared andy rost 20:10

Aug. 31, 2005

Thread Author Time
Re: [SQL] plpgsql question Michael Fuhr 02:32
How do I copy part of table from db1 to db2 (and rename the columns)? Joost Kraaijeveld 10:00
Re: How do I copy part of table from db1 to db2 (and rename the columns)? Kenneth Gonsalves 10:15
Re: How do I copy part of table from db1 to db2 (and rename the columns)? Roman Neuhauser 10:40
Re: How do I copy part of table from db1 to db2 (and Joost Kraaijeveld 12:00
Re: [SQL] How do I copy part of table from db1 to db2 (and Thomas Pundt 12:09
psql commandline digit-x 12:14
Re: [SQL] How do I copy part of table from db1 to db2 (and Thomas Pundt 12:14
psql commandline dIGITx 12:18
psql commandline dIGITx 12:30
Re: psql commandline Kenneth Gonsalves 12:43
Re: How do I copy part of table from db1 to db2 (and Tino Wildenhain 12:47
Re: psql commandline digit-x 12:54
Re: psql commandline Kenneth Gonsalves 13:03
Re: psql commandline digit-x 13:13
Re: How do I copy part of table from db1 to db2 (and rename the columns)? Greg Sabino Mullane 13:19
Re: psql commandline Zac 13:19
Re: psql commandline Kenneth Gonsalves 13:25
Re: psql commandline Kenneth Gonsalves 13:29
Re: psql commandline Charley L. Tiggs 14:27
Re: [SQL] How do I copy part of table from db1 to db2 (and Tom Lane 14:29
Re: [SQL] How do I copy part of table from db1 to db2 Joost Kraaijeveld 15:02
insert only if conditions are met? Henry Ortega 15:09
Re: [SQL] How do I copy part of table from db1 to db2 Joost Kraaijeveld 15:14
Re: insert only if conditions are met? Tom Lane 15:22
Re: insert only if conditions are met? Michael Fuhr 15:25
Re: insert only if conditions are met? Henry Ortega 15:49
Re: insert only if conditions are met? 📎 Chris Travers 16:40
Re: insert only if conditions are met? Ragnar Hafstað 16:44
Re: insert only if conditions are met? Henry Ortega 16:49
Re: insert only if conditions are met? Jim C. Nasby 19:54
Re: insert only if conditions are met? Ragnar Hafstað 20:27
Re: insert only if conditions are met? Scott Marlowe 20:50
Re: insert only if conditions are met? Philip Hallstrom 21:09
Re: insert only if conditions are met? Daryl Richter 21:27

Sept. 1, 2005

Thread Author Time
SQL queries Joÿffffffffffe3o Carvalho 14:00
Re: ALTER TABLE ( smallinto -> boolean ) ... Marc G. Fournier 20:49
Re: ALTER TABLE ( smallinto -> boolean ) ... Tom Lane 20:56
Re: [HACKERS] ALTER TABLE ( smallinto -> boolean ) ... Marc G. Fournier 21:15
Re: ALTER TABLE ( smallinto -> boolean ) ... Andrew Dunstan 21:23
Re: [HACKERS] ALTER TABLE ( smallinto -> boolean ) ... Owen Jacobson 21:24
Re: [HACKERS] ALTER TABLE ( smallinto -> boolean ) ... Tom Lane 21:25
Re: ALTER TABLE ( smallinto -> boolean ) ... Tom Lane 21:30
Re: ALTER TABLE ( smallinto -> boolean ) ... Marc G. Fournier 22:16

Sept. 2, 2005

Thread Author Time
queries problems Joÿffffffffffe3o Carvalho 00:33
Re: queries problems Michael Fuhr 00:50
Re: queries problems Michael Fuhr 02:03
Last access date for databases/users Marc McIntyre 02:58
ERROR: syntax error at or near "select" at character 9 Graf László 07:26
Returning with the inserted id Graf László 09:09
Re: Returning with the inserted id Richard Huxton 09:33
cursor "<unnamed portal 1>" already in use Stathis Stergou 11:17
Re: cursor "<unnamed portal 1>" already in use Michael Fuhr 13:12
not sure about constraints Jerome Alet 13:23
Re: not sure about constraints Achilleus Mantzios 13:43
Re: not sure about constraints Jerome Alet 14:26
Turn off auto-commit Joÿffffffffffe3o Carvalho 17:21
Re: Turn off auto-commit Owen Jacobson 17:27
Recommendation on bytea or blob for binary data like images leon 19:15
Searching for results with an unknown amount of data DownLoad X 19:40
Re: Recommendation on bytea or blob for binary data like images Tom Lane 20:33
Re: insert only if conditions are met? Henry Ortega 20:44
Re: insert only if conditions are met? Philip Hallstrom 21:00
Searching for results with an unknown amount of data Oz 21:27

Sept. 3, 2005

Thread Author Time
Re: Negative lookbehind assertions in regexs Julian Scarfe 14:59
Re: Negative lookbehind assertions in regexs Alvaro Herrera 15:28
Re: Negative lookbehind assertions in regexs Dawid Kuroczko 17:18
Table Constraint CHECK(SELECT()) alternative? Robert D. Kennedy 18:50

Sept. 4, 2005

Thread Author Time
joining two simular (but not identical tables) Neil Dugan 12:19
Re: joining two simular (but not identical tables) Michael Fuhr 13:00
Help with UNION query Andreas Joseph Krogh 17:14
Re: Help with UNION query Andreas Joseph Krogh 18:08

Browse Archives

Prev | Next