pgsql-sql since 2005-08-30 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. 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
Re: Help with UNION query Andreas Joseph Krogh 18:54

Sept. 5, 2005

Thread Author Time
Weird Trigger Behaviour using IF ... THEN ... ESLEIF... THEN... ELSEIF... THEN ... ELSE ... END IF; Antony Sohal 10:20
POSIX Regular Expression question Aldor 13:57
Re: POSIX Regular Expression question A. Kretschmer 14:13
Re: POSIX Regular Expression question Michael Fuhr 14:15
Re: POSIX Regular Expression question Peter Eisentraut 14:19
Re: POSIX Regular Expression question A. Kretschmer 15:10
Re: POSIX Regular Expression question Alvaro Herrera 15:13
Re: POSIX Regular Expression question Harald Fuchs 15:40
Re: POSIX Regular Expression question Peter Eisentraut 15:46
Re: POSIX Regular Expression question Peter Eisentraut 16:07
Re: POSIX Regular Expression question Peter Eisentraut 16:15
Re: POSIX Regular Expression question Tom Lane 17:31

Sept. 6, 2005

Thread Author Time
Equivalent of Oracle SQL%NOTFOUND in plpgsql Bath, David 02:14
Re: Equivalent of Oracle SQL%NOTFOUND in plpgsql Tom Lane 02:21
Re: Table Constraint CHECK(SELECT()) alternative? Dinesh Pandey 04:18
Re: Table Constraint CHECK(SELECT()) alternative? Stephan Szabo 04:25
Re: Weird Trigger Behaviour using IF ... THEN ... ESLEIF... Stephan Szabo 04:30
Re: ERROR: syntax error at or near "select" at character 9 Stephan Szabo 04:35
Re: Searching for results with an unknown amount of data Thomas F. O'Connell 04:38
Re: ERROR: syntax error at or near "select" at character 9 Harald Fuchs 08:57
uuid type for postgres nathan wagner 13:50
Re: ERROR: syntax error at or near "select" at character 9 Stephan Szabo 14:00
Re: Searching for results with an unknown amount of data Bruno Wolff III 14:45
Re: uuid type for postgres mark 14:49
Re: Help with UNION query Bruno Wolff III 15:03
Re: POSIX Regular Expression question Bruno Wolff III 15:33
Re: uuid type for postgres Tom Lane 15:38
Re: uuid type for postgres Josh Berkus 17:02
Re: uuid type for postgres nathan wagner 17:15
Re: Performance issue Tim Goodaire 18:32
Re: uuid type for postgres Jonah H. Harris 19:57
Re: Recommendation on bytea or blob for binary data like images Leon Torres 20:21
Re: uuid type for postgres Bob Ippolito 20:24
Re: uuid type for postgres Jonah H. Harris 20:32
Re: uuid type for postgres mark 20:38
Re: uuid type for postgres David Fetter 20:49
Re: uuid type for postgres Bob Ippolito 21:11
Re: uuid type for postgres nathan wagner 21:16
Re: uuid type for postgres mark 21:16
Re: uuid type for postgres Greg Stark 21:31
Re: uuid type for postgres mark 21:50
Re: uuid type for postgres Tom Lane 21:54
Re: uuid type for postgres mark 22:06
Re: uuid type for postgres nathan wagner 22:40
Re: uuid type for postgres Bob Ippolito 23:08
Re: uuid type for postgres Jonah H. Harris 23:27
Re: uuid type for postgres Greg Stark 23:34

Sept. 7, 2005

Thread Author Time
Re: uuid type for postgres Josh Berkus 01:02
Re: uuid type for postgres mark 01:11
Re: uuid type for postgres Bob Ippolito 01:15
Re: uuid type for postgres Josh Berkus 01:40
Re: uuid type for postgres nathan wagner 02:36
Statistics from Sequences Joÿffffffffffe3o Carvalho 02:43
Re: Statistics from Sequences Michael Fuhr 03:26
Re: Statistics from Sequences Bruno Wolff III 03:38
Re: uuid type for postgres Paul Ramsey 03:40
Re: uuid type for postgres Tom Lane 04:24
AGE function Louise Catherine 05:05
Re: uuid type for postgres nathan wagner 05:15
Re: AGE function Michael Fuhr 06:26
Re: AGE function Louise Catherine 07:22
Re: AGE function A. Kretschmer 07:46
Re: AGE function Michael Fuhr 14:24
Re: AGE function Michael Fuhr 15:11
Re: AGE function Tom Lane 15:13
Re: uuid type for postgres Roman Neuhauser 15:39
Re: uuid type for postgres Josh Berkus 16:45
Re: uuid type for postgres Josh Berkus 16:48
Re: uuid type for postgres nathan wagner 17:04
Re: uuid type for postgres nathan wagner 17:19
Re: uuid type for postgres Patrick Welche 17:48
Re: uuid type for postgres Tom Lane 17:52
Help with multistage query Rick Schumeyer 17:57
Re: uuid type for postgres Tom Lane 18:01
Re: uuid type for postgres Josh Berkus 18:31
Re: uuid type for postgres Bob Ippolito 18:47
Re: uuid type for postgres Alvaro Herrera 19:00
Re: uuid type for postgres Tom Lane 19:45
Re: Help with multistage query Russell Simpkins 20:05
Re: uuid type for postgres mark 20:10
Re: uuid type (moved from HACKERS) Josh Berkus 20:35
Re: uuid type for postgres Andrew Dunstan 21:07
Re: uuid type for postgres Tom Lane 21:24
column names, types, properties for a table Roger Tannous 21:25
Re: Help with multistage query Matt Emmerton 21:37
Re: column names, types, properties for a table Philip Hallstrom 21:38
Re: Searching for results with an unknown amount of data DownLoad X 21:54
Re: column names, types, properties for a table Roger Tannous 23:08

Sept. 8, 2005

Thread Author Time
Re: uuid type (moved from HACKERS) Greg Stark 01:13
user defined type, plpgsql function and NULL Bjoern A. Zeeb 08:09
Re: uuid type for postgres Greg Sabino Mullane 13:45
Re: uuid type for postgres Jonah H. Harris 14:03
Re: uuid type for postgres mark 15:30
Re: uuid type for postgres Jonah H. Harris 16:02
Indexing an array? Silke Trissl 16:13
Re: Indexing an array? Josh Berkus 16:26
Re: uuid type for postgres mark 16:28
Re: Indexing an array? Tom Lane 16:33
Re: Indexing an array? Dmitri Bichko 16:34
Re: uuid type for postgres Jonah H. Harris 17:03
Re: uuid type for postgres Bob Ippolito 17:24
Re: Statistics from Sequences Michael Fuhr 20:08
Re: column names, types, properties for a table thomas.silvi 20:37
Re: Statistics from Sequences Joÿffffffffffe3o Carvalho 20:53
a "catch all" type ... such a thing? Marc G. Fournier 21:20
how to replace Michael Höller 21:25
Re: how to replace Owen Jacobson 21:33

Browse Archives

Prev | Next