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

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
Re: how to do 'deep queries'? Anthony Molinaro 15:44
changing a column's position in table, how do you do that Ferindo Middleton Jr 22:52

Sept. 28, 2005

Thread Author Time
Re: changing a column's position in table, how do you do that Stewart Ben (RBAU/EQS4) * 00:25
Re: changing a column's position in table, how do you do that Chris Browne 03:24
Re: add column if doesn't exist Brandon Metcalf 14:23
Re: Why doesn't the SERIAL data type automatically have a UNIQUE CONSTRAINT codeWarrior 16:24
Sending function parametars within EXECUTE ''SELECT... Mario Splivalo 16:51
Re: Sending function parametars within EXECUTE ''SELECT... codeWarrior 17:01
Problem with function and trigger... Ian Meyer 17:35
Re: Problem with function and trigger... Tom Lane 17:52
Selecting count of details along with details columns Axel Rau 19:19
Re: changing a column's position in table, how do you do that Daryl Richter 19:38
Re: Problem with function and trigger... Ian Meyer 19:46
Re: changing a column's position in table, how do you do that Michael Glaesemann 21:28

Sept. 29, 2005

Thread Author Time
unsubscribe Ricky Sutanto 04:45
unsubscribe noor 06:17
Re: unsubscribe Kenneth Gonsalves 06:27
Re: Sending function parametars within EXECUTE ''SELECT... Mario Splivalo 06:30
Re: Sending function parametars within EXECUTE ''SELECT... Stewart Ben (RBAU/EQS4) * 06:36
Re: Sending function parametars within EXECUTE ''SELECT... Mario Splivalo 07:20
Re: Selecting count of details along with details columns Richard Huxton 08:30
Re: Selecting count of details along with details columns Axel Rau 09:19
Re: Selecting count of details along with details columns Richard Huxton 10:03
EXECUTE with SELECT INTO variable, or alternatives Mario Splivalo 18:16
Re: Selecting count of details along with details columns Axel Rau 19:08
Re: Selecting count of details along with details columns Scott Marlowe 19:29

Sept. 30, 2005

Thread Author Time
unsubscribe Ricky Sutanto 02:16
EXECUTE SELECT INTO... last one! Mario Splivalo 08:00
Re: EXECUTE SELECT INTO... last one! Michael Fuhr 08:34
Re: EXECUTE SELECT INTO... last one! Mario Splivalo 09:21
creating postgres tables by passing a string to function Scott cox 15:38
combination of function to simple query makes query slow jan aerts (RI) 16:01
Re: combination of function to simple query makes query slow Jaime Casanova 18:40
Re: EXECUTE with SELECT INTO variable, or alternatives Thomas F. O'Connell 20:59
query tables based on a query solarsail 22:47
Re: EXECUTE with SELECT INTO variable, or alternatives Michael Fuhr 23:34

Oct. 1, 2005

Thread Author Time
BirthDay SQL Issue brett 22:32

Oct. 2, 2005

Thread Author Time
Getting user created tables from SQL Cenk KIZILDAG 13:30

Oct. 3, 2005

Thread Author Time
Re: combination of function to simple query makes query slow jan aerts (RI) 10:21
Re: combination of function to simple query makes query slow Jaime Casanova 19:21
MOVE in SQL vs PLPGSQL andrew 20:57
regular expression gurkan 22:08

Oct. 4, 2005

Thread Author Time
Re: combination of function to simple query makes query slow jan aerts (RI) 08:27
Re: combination of function to simple query makes query slow Tom Lane 14:50
using pg_tables and tablename in queries solarsail 16:30
Re: using pg_tables and tablename in queries Tom Lane 17:01
Re: using pg_tables and tablename in queries solarsail 18:40
Re: using pg_tables and tablename in queries Yasir Malik 19:23
Re: using pg_tables and tablename in queries Jim Buttafuoco 19:45
Re: using pg_tables and tablename in queries solarsail 19:50
Re: using pg_tables and tablename in queries Gregory S. Williamson 22:33
Re: Help with multistage query Jim C. Nasby 22:34
Re: Why doesn't the SERIAL data type automatically have a Jim C. Nasby 22:52
Re: Why doesn't the SERIAL data type automatically have a Richard Huxton 23:23
Re: Why doesn't the SERIAL data type automatically have a Ferindo Middleton Jr 23:50
Re: Why doesn't the SERIAL data type automatically have a Ferindo Middleton Jr 23:54

Oct. 5, 2005

Thread Author Time
Re: Why doesn't the SERIAL data type automatically have a Jim C. Nasby 00:06
Re: using pg_tables and tablename in queries Jim Buttafuoco 01:01
Re: regular expression Gnanavel S 04:56
Re: regular expression Michael Fuhr 05:56
Re: MOVE in SQL vs PLPGSQL Richard Huxton 08:18
Re: creating postgres tables by passing a string to function Richard Huxton 08:20
Re: BirthDay SQL Issue Richard Huxton 08:30
Re: Getting user created tables from SQL Richard Huxton 08:32
Help with simple SQL query? Joost Kraaijeveld 11:35
Re: Help with simple SQL query? Gregory S. Williamson 11:47
Re: Help with simple SQL query? Frank van Vugt 12:21
Re: Help with simple SQL query? Joost Kraaijeveld 13:19
Re: MOVE in SQL vs PLPGSQL Richard Huxton 15:01
Re: BirthDay SQL Issue Andreas Kretschmer 15:12
Use of partial index Leif B. Kristensen 15:17
Re: using pg_tables and tablename in queries codeWarrior 15:24
Re: BirthDay SQL Issue Kenneth Gonsalves 15:30
Re: MOVE in SQL vs PLPGSQL Tom Lane 15:43
Re: Use of partial index Dmitri Bichko 16:44
Re: Use of partial index Stephan Szabo 16:48
Re: Use of partial index Tom Lane 16:49
Re: Use of partial index Leif B. Kristensen 17:20
Re: Use of partial index Leif B. Kristensen 17:21

Oct. 6, 2005

Thread Author Time
Scripting GRANT on functions Stewart Ben (RBAU/EQS4) * 05:27
catching errors in function padmanabha konkodi 06:55
Re: catching errors in function Eugene E. 07:11
Noob question about types and lists xchris 10:40
Re: Noob question about types and lists Richard Huxton 11:20
Re: Noob question about types and lists xchris 11:52
Re: Noob question about types and lists Richard Huxton 12:19
DATESTYLE and 0000-00-00 Joshua Kramer 13:01
Re: Scripting GRANT on functions Russell Simpkins 13:06
Re: Scripting GRANT on functions Tom Lane 13:33
Re: catching errors in function John DeSoi 13:51
UNION index use help Dmitri Bichko 15:59
Re: UNION index use help Tom Lane 16:32
Re: UNION index use help Dmitri Bichko 17:25
Re: DATESTYLE and 0000-00-00 Andrew Sullivan 18:15
Re: DATESTYLE and 0000-00-00 D'Arcy J.M. Cain 18:16
Re: DATESTYLE and 0000-00-00 Michael Fuhr 18:37
Selecting records not present in related tables Hector Rosas 19:43

Browse Archives

Prev | Next