pgsql-sql since 2005-09-08 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. 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
R-tree and start/end queries Sean Davis 17:52
Re: R-tree and start/end queries Bruno Wolff III 18:38
Re: R-tree and start/end queries Chris Mungall 19:13
Re: R-tree and start/end queries Dmitri Bichko 19:29
Re: R-tree and start/end queries Tom Lane 19:43

Sept. 22, 2005

Thread Author Time
delete item[5] from varchar[] array??? Matthew Peter 01:56
Re: delete item[5] from varchar[] array??? Michael Fuhr 03:15
Re: delete item[5] from varchar[] array??? Tom Lane 03:17
Re: delete item[5] from varchar[] array??? Matthew Peter 04:13
Copy Views From Database? [email protected] 08:37
Re: Copy Views From Database? Hannes Dorbath 09:06
cancel <[email protected]> light 09:07
Re: Copy Views From Database? Hannes Dorbath 09:08
Updating cidr column with network operator Axel Rau 10:52
Re: Copy Views From Database? Hannes Dorbath 12:12
postgres on the comman line Michael Höller 13:55
Re: postgres on the comman line Thomas Pundt 14:13
Re: postgres on the comman line A. Kretschmer 14:15
Re: postgres on the comman line Achilleus Mantzios 14:19
Re: Updating cidr column with network operator Daryl Richter 14:45
Using descriptor areas to insert andy rost 15:49
Issue with UPDATE statement on v8 Kenneth Hutchinson 16:22
Help with a view Leif B. Kristensen 17:29
Re: Updating cidr column with network operator Axel Rau 17:58
Re: Help with a view Dmitri Bichko 18:03
Re: Help with a view Leif B. Kristensen 18:12
Re: Help with a view Dmitri Bichko 19:10
Re: Updating cidr column with network operator Daryl Richter 20:26
Issue with UPDATE statement on v8 Kenneth Hutchinson 20:33
Re: Help with a view Rajesh Kumar Mallah 20:39
Re: Issue with UPDATE statement on v8 Tom Lane 20:48
Re: Issue with UPDATE statement on v8 Rajesh Kumar Mallah 20:48
Re: Using descriptor areas to insert Josh Berkus 22:10

Sept. 23, 2005

Thread Author Time
Primary and Foreign Key? Announce 01:13
Re: Primary and Foreign Key? Russell Simpkins 01:34
Functions, transactions and RETURN Stewart Ben (RBAU/EQS4) * 01:50
Re: Functions, transactions and RETURN Stewart Ben (RBAU/EQS4) * 05:55
COPY TO / COPY FROM Cédric Buschini 11:48
Re: COPY TO / COPY FROM Aldor 12:02
Re: Issue with UPDATE statement on v8 Michael Fuhr 13:30
Re: COPY TO / COPY FROM Michael Fuhr 13:47
Where are user defined functions stored? Hilary Forbes 14:09
Re: Difficulties with a master-detail query Bruno Wolff III 14:13
Re: Where are user defined functions stored? Tom Lane 14:40
Re: [ADMIN] COPY TO / COPY FROM Aldor 15:52
Re: Where are user defined functions stored? Hilary Forbes 16:18
Re: Where are user defined functions stored? Tom Lane 16:22
Re: Updating cidr column with network operator Axel Rau 16:31
Re: delete item[5] from varchar[] array??? Matthew Peter 17:02
Re: Updating cidr column with network operator Michael Fuhr 17:32
Re: Updating cidr column with network operator Daryl Richter 18:43
Re: delete item[5] from varchar[] array??? Michael Fuhr 19:10
Re: Updating cidr column with network operator Axel Rau 19:19
Re: Updating cidr column with network operator Axel Rau 19:24

Sept. 24, 2005

Thread Author Time
Re: delete item[5] from varchar[] array??? Matthew Peter 02:51
VACUUM FULL vs dump & restore Ilya A. Kovalenko 04:56
Re: VACUUM FULL vs dump & restore Aldor 11:19
Re: VACUUM FULL vs dump & restore Aldor 11:28
stored procs in postgresql ceremona 19:30
Re: stored procs in postgresql Chris Browne 21:27

Sept. 25, 2005

Thread Author Time
redundancy in CHECK CONSTRAINTs Ferindo Middleton Jr 03:34
Re: redundancy in CHECK CONSTRAINTs Tom Lane 03:58
Re: stored procs in postgresql Cere Davis 04:10
Re: redundancy in CHECK CONSTRAINTs Ferindo Middleton Jr 04:46
Re: stored procs in postgresql A. Kretschmer 07:47

Sept. 26, 2005

Thread Author Time
Re: Updating cidr column with network operator Michael Fuhr 00:05
Re: Updating cidr column with network operator Axel Rau 10:34
Re: Possible to delete record from all tables at the same time? Chris Browne 18:21
add column if doesn't exist Brandon Metcalf 20:38
Re: Updating cidr column with network operator Michael Fuhr 21:33

Sept. 27, 2005

Thread Author Time
Re: add column if doesn't exist Peter Eisentraut 00:16
how to do 'deep queries'? jeff sacksteder 00:34
Re: how to do 'deep queries'? Stewart Ben (RBAU/EQS4) * 00:45
Why doesn't the SERIAL data type automatically have a UNIQUE CONSTRAINT Ferindo Middleton Jr 00:45
Re: how to do 'deep queries'? Anthony Molinaro 00:58
Re: Why doesn't the SERIAL data type automatically have a UNIQUE CONSTRAINT Tom Lane 01:03
Re: Why doesn't the SERIAL data type automatically have a UNIQUE Ferindo Middleton Jr 02:53
Re: how to do 'deep queries'? jeff sacksteder 03:35
Re: add column if doesn't exist Brandon Metcalf 12:45
Re: how to do 'deep queries'? Daryl Richter 13:24
Re: add column if doesn't exist Chris Browne 13:34
Re: Updating cidr column with network operator Daryl Richter 14:02
Re: how to do 'deep queries'? Anthony Molinaro 14:23
Re: Updating cidr column with network operator Axel Rau 14:44
Re: Updating cidr column with network operator Daryl Richter 15:02
Re: Updating cidr column with network operator Axel Rau 15:11
Re: Why doesn't the SERIAL data type automatically have a Scott Marlowe 15:33
Re: how to do 'deep queries'? Daryl Richter 15:35

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