pgsql-sql since 2005-09-05 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
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. 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
Re: Need help with 'unique parents' constraint Daryl Richter 13:00
Re: What should this query match? Peter Eisentraut 14:39
CREATE TEMPORARY TABLE ON COMMIT DROP Luis Sousa 16:22
Re: CREATE TEMPORARY TABLE ON COMMIT DROP Tom Lane 17:08

Sept. 15, 2005

Thread Author Time
showing multiple REFERENCE details of id fields in single query that share the same table Ferindo Middleton Jr 01:11
Re: showing multiple REFERENCE details of id fields in single query that share the same table Thomas O'Connell 05:16
Triggers & Conditional Assignment Neil Saunders 09:25
Re: Triggers & Conditional Assignment Gnanavel S 09:58
Re: showing multiple REFERENCE details of id fields in single Daryl Richter 13:43
Re: Triggers & Conditional Assignment Tom Lane 13:56
passing values into .sql scripts Geoffrey Knauth 21:27
How to install Postgresql 8 on different drive letter? The One 21:36
Re: passing values into .sql scripts Michael Fuhr 22:43
Re: passing values into .sql scripts Geoffrey Knauth 22:49

Sept. 16, 2005

Thread Author Time
Re: showing multiple REFERENCE details of id fields in single Daryl Richter 16:16
alter sequence + subqueries jeff sacksteder 22:36
plpgsql function not accepting NULL value Kenneth Dombrowski 23:04
Re: plpgsql function not accepting NULL value Stephan Szabo 23:17
Re: plpgsql function not accepting NULL value Michael Fuhr 23:18
Re: alter sequence + subqueries Alvaro Herrera 23:19
Re: plpgsql function not accepting NULL value Kenneth Dombrowski 23:27
Re: alter sequence + subqueries Michael Fuhr 23:27

Sept. 17, 2005

Thread Author Time
Re: How to install Postgresql 8 on different drive letter? Magnus Hagander 13:55

Sept. 18, 2005

Thread Author Time
unsuscribe Nicolas Cornu 19:48

Sept. 19, 2005

Thread Author Time
Difficulties with a master-detail query Milen A. Radev 17:29

Sept. 20, 2005

Thread Author Time
Inheritance (general hints wanted) Achilleus Mantzios 06:55
Re: Inheritance (general hints wanted) thomas.silvi 10:07
Re: Inheritance (general hints wanted) Achilleus Mantzios 12:09

Sept. 21, 2005

Thread Author Time
Re: Inheritance (general hints wanted) Achilleus Mantzios 06:23
How to add column from old_table to new_table? Joost Kraaijeveld 12:36
Re: How to add column from old_table to new_table? Joost Kraaijeveld 12:50
Re: How to add column from old_table to new_table? A. Kretschmer 12:56
Re: How to add column from old_table to new_table? Thomas Pundt 12:58
Re: How to add column from old_table to new_table? Gnanavel S 12:59
Re: How to add column from old_table to new_table? Gnanavel S 13:01
Re: How to add column from old_table to new_table? Leif B. Kristensen 13:06
Re: How to add column from old_table to new_table? Joost Kraaijeveld 13:09
Re: How to add column from old_table to new_table? A. Kretschmer 13:42

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