pgsql-sql - September 2005

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
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30

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
Re: how to replace Anthony Molinaro 21:40
Re: Statistics from Sequences Michael Fuhr 22:04
Re: queries problems Joÿffffffffffe3o Carvalho 22:33
Re: queries problems Michael Fuhr 23:54

Sept. 9, 2005

Thread Author Time
Re: queries problems Tom Lane 00:16
Numeric Columns miwalsh 00:43
Re: Numeric Columns Tom Lane 01:09
Re: how to replace A. Kretschmer 05:08
Re: a "catch all" type ... such a thing? Eugene E. 06:09
Re: a "catch all" type ... such a thing? Michael Glaesemann 06:55
SELECT: retrieve only 2 rows next to known row Nikolay Samokhvalov 12:23
Re: SELECT: retrieve only 2 rows next to known row Bruno Wolff III 12:38
Re: SELECT: retrieve only 2 rows next to known row Tom Lane 14:37
Age in days Mark A. Strivens 16:04
Re: Indexing an array? Ron Mayer 23:35

Sept. 10, 2005

Thread Author Time
how to have 2 select creteria on one column? Michael Hoeller 15:45
Re: how to have 2 select creteria on one column? Richard Huxton 16:31
Fwd: how to have 2 select creteria on one column? SOLVED Michael Hoeller 16:41
how to update with a join? Michael Hoeller 16:47
Re: how to update with a join? MichaelHoeller 16:56
Re: how to have 2 select creteria on one column? Bruno Wolff III 17:57
Re: how to update with a join? Bruno Wolff III 18:03
Re: a "catch all" type ... such a thing? Peter Eisentraut 18:43

Sept. 11, 2005

Thread Author Time
Re: a "catch all" type ... such a thing? Trent Shipley 03:54
Need help with 'unique parents' constraint Leif B. Kristensen 12:24
Re: Need help with 'unique parents' constraint Leif B. Kristensen 12:59
Re: Need help with 'unique parents' constraint Greg Sabino Mullane 14:04
Panic: Page Add Item: Corrupted page pointers The One 17:09
Re: Need help with 'unique parents' constraint John Hasler 17:28
Re: Panic: PageAddItem: Corrupted page pointers The One 21:20
showing multiple reference details from single query Ferindo Middleton Jr 22:37
Re: showing multiple reference details from single query Michael Fuhr 23:33
Re: Panic: PageAddItem: Corrupted page pointers Alvaro Herrera 23:42

Sept. 12, 2005

Thread Author Time
Re: Panic: Page Add Item: Corrupted page pointers Tom Lane 00:01
howto insert dynamic value liofr 02:19
Re: howto insert dynamic value Michael Fuhr 03:00
Re: howto insert dynamic value wendell 03:07
Please help, can't figure out what's wrong with this function... Moritz Bayer 12:14
Re: Please help, can't figure out what's wrong with this function... John DeSoi 12:46
Re: Please help, can't figure out what's wrong with this function... Tom Lane 14:18
refer a column as a varible name? gherzig 15:21
How do I convert an integet to a timestamp? Wei 18:01
Re: Need help with 'unique parents' constraint Leif B. Kristensen 18:02
Re: refer a column as a varible name? Michael Fuhr 23:03

Sept. 13, 2005

Thread Author Time
Re: Need help with `unique parents` constraint Greg Sabino Mullane 00:38
Re: How do I convert an integet to a timestamp? Michael Fuhr 04:53
Re: user defined type, plpgsql function and NULL Tom Lane 04:58
Re: Age in days Gnanavel S 05:01
Re: Age in days Michael Glaesemann 05:12
Re: How do I convert an integet to a timestamp? Eugene E. 08:45
Re: SELECT: retrieve only 2 rows next to known row Marcin Piotr Grondecki 14:04
Re: refer a column as a varible name? gherzig 18:09

Sept. 14, 2005

Thread Author Time
What should this query match? Joost Kraaijeveld 09:54
Re: What should this query match? Peter Eisentraut 10:48
Re: What should this query match? Joost Kraaijeveld 11:09

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30