pgsql-sql since 2002-07-11 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 31

July 11, 2002

Thread Author Time
Returning rows from functions David Durst 00:37
Re: How to get total number of rows when using LIMIT/OFFSET? Bruce Momjian 01:50
Re: pg_restore cannot restore index Bruce Momjian 02:05
Re: BETWEEN bug? Josh Berkus 03:22
Re: Returning rows from functions Joe Conway 04:59
Re: Insert Function Ian Barwick 06:38
Re: SQL problem with aggregate functions. Christoph Haller 10:37
list of tables ? Steve Brett 14:00
Re: list of tables ? -update to question ... Steve Brett 14:07
Re: list of tables ? Ian Barwick 14:09
Re: list of tables ? Achilleus Mantzios 14:09
Re: list of tables ? Steve Brett 14:13
Re: XML to Postgres conversion George.T.Essig 14:23
how to inherits the references... frederik nietzsche 14:43
Re: [SQL] XML to Postgres conversion Rudi Starcevic 15:18
please help on query Luis Alberto Amigo Navarro 15:22
Re: pg_restore cannot restore index Jie Liang 15:41
Re: how to inherits the references... Stephan Szabo 16:00
Re: [HACKERS] please help on query Manfred Koizar 16:47
Re: [HACKERS] please help on query Luis Alberto Amigo Navarro 17:40
Re: please help on query J. R. Nield 18:06
Re: please help on query Andy Kopciuch 18:09
Re: list of tables ? -update to question ... Jan Wieck 18:38
Re: [HACKERS] please help on query Manfred Koizar 18:44
Re: pg_restore cannot restore index Jie Liang 19:48
Re: please help on query Hannu Krosing 20:48
Re: please help on query Hannu Krosing 20:51
Re: please help on query Hannu Krosing 21:08
Re: SQL problem with aggregate functions. Loyd Goodbar 22:08
Please, HELP! Why is the query plan so wrong??? Dmitry Tkach 22:50
Re: [SQL] Please, HELP! Why is the query plan so wrong??? Jie Liang 23:26
PostgreSQL - contrib/xml Rudi Starcevic 23:27

July 12, 2002

Thread Author Time
Re: PostgreSQL - contrib/xml Christopher Kings-Lynne 01:39
Query kill Rudi Starcevic 05:00
Re: Query kill Bruce Momjian 05:01
rules / triggers on insert. why after? Ahti Legonkov 09:24
Re: how to inherits the references... frederik nietzsche 10:29
Re: [HACKERS] please help on query Luis Alberto Amigo Navarro 11:37
Re: [HACKERS] please help on query Jakub Ouhrabka 11:50
Re: [HACKERS] please help on query Jakub Ouhrabka 11:52
Re: rules / triggers on insert. why after? Jan Wieck 13:41
Re: how to inherits the references... Stephan Szabo 14:03
Re: list of tables ? Christoph Haller 14:16
Re: SQL problem with aggregate functions. Jean-Luc Lachance 14:28
Re: [SQL] Please, HELP! Why is the query plan so wrong??? Dmitry Tkach 14:34
Re: rules / triggers on insert. why after? Tom Lane 15:07
Re: [SQL] Please, HELP! Why is the query plan so wrong??? Jie Liang 15:29
config postgresql.conf?? Jie Liang 15:32
Re: [HACKERS] please help on query Luis Alberto Amigo Navarro 15:32
Re: config postgresql.conf?? Josh Berkus 15:56
It is a bug in pred_test()! (Was: [SQL] Please, HELP! Why is the query plan so wrong???) Dmitry Tkach 16:17
Re: Query kill eric soroos 17:22
Re: Query kill Jan Wieck 17:53

July 13, 2002

Thread Author Time
Re: XML to Postgres conversion Marc Spitzer 02:00
Re: Query kill Bruce Momjian 02:13
Re: Query kill Jan Wieck 03:55
Re: Query kill Bruce Momjian 04:27
Indexes with LIKE Julian Scarfe 09:53
Re: pg_restore cannot restore index 📎 Bruce Momjian 14:50
Re: Indexes with LIKE Stephan Szabo 15:28
Re: Indexes with LIKE Julian Scarfe 18:18
Re: It is a bug in pred_test()! (Was: [SQL] Please, HELP! Why is the query plan so wrong???) Tom Lane 19:27
sql question: Chris Aiello 22:24

July 14, 2002

Thread Author Time
Re: sql question: Ahti Legonkov 02:38
line datatype Tim Hart 05:09
Re: [HACKERS] please help on query Masaru Sugawara 12:23
Re: Indexes with LIKE Stephan Szabo 19:46

July 15, 2002

Thread Author Time
Quick Question Christopher Kings-Lynne 03:15
Sorry.. Christopher Kings-Lynne 03:17
Re: Sorry.. Tom Lane 03:27
Fwd: line datatype Tim Hart 03:32
Re: [HACKERS] please help on query Luis Alberto Amigo Navarro 07:45
Re: line datatype Bruce Momjian 14:43
Re: pg_restore cannot restore index Jie Liang 14:46
Re: [HACKERS] please help on query Masaru Sugawara 16:15
[No subject] Wallingford, Ted 17:45
Re: [SQL] Bruce Momjian 17:51
Seeding Chad Thompson 18:45
Indexing UNIONs Josh Berkus 19:00
Re: Indexing UNIONs Stephan Szabo 20:12
Re: Sorry.. Josh Berkus 21:01
Re: pg_restore cannot restore index Bruce Momjian 22:23
Re: [SQL] Seeding Peter Eisentraut 22:54
Re: pg_restore cannot restore index Jie Liang 23:22
Re: pg_restore cannot restore index Bruce Momjian 23:24
how pg_restore long form works? Jie Liang 23:24
pg_restore --flag Jie Liang 23:39

July 16, 2002

Thread Author Time
Re: Indexing UNIONs Josh Berkus 00:31
Re: Indexing UNIONs Stephan Szabo 00:42
Re: line datatype Bruce Momjian 03:33
Re: [SQL] line datatype Thomas Lockhart 06:10
How do I concatenate row-wise instead of column-wise? Marcus Claesson 08:09
Re: [HACKERS] please help on query Luis Alberto Amigo Navarro 08:51
Re: How do I concatenate row-wise instead of column-wise? Richard Huxton 09:15
Cascading deletions does not seem to work inside PL/PGSQL functions. 📎 Rajesh Kumar Mallah. 11:25
Re: How do I concatenate row-wise instead of column-wise? Rajesh Kumar Mallah. 11:34
Re: Indexing UNIONs Bruno Wolff III 11:45
Re: [SQL] line datatype Tom Lane 13:44
Re: [SQL] line datatype Bruce Momjian 15:21
Re: [SQL] line datatype Thomas Lockhart 15:29
Re: [SQL] line datatype Bruce Momjian 15:38
Re: [SQL] line datatype Thomas Lockhart 16:07
Re: [SQL] line datatype Lamar Owen 16:10
Re: Cascading deletions does not seem to work inside PL/PGSQL Stephan Szabo 16:11
Re: [SQL] line datatype Bruce Momjian 16:26
Re: [SQL] line datatype Tom Lane 16:30
Re: [SQL] line datatype Bruce Momjian 16:31
Re: Indexing UNIONs Josh Berkus 16:36
A SQL Training Devrim GUNDUZ 17:18
Need help on a troublesome query plan Alain Lavigne 17:24
Re: Seeding Chad Thompson 17:31
datatype matrix (was: Re: Sorry..) Kevin Brannen 17:37
Re: A SQL Training Josh Berkus 18:07
Re: Seeding Ron Johnson 18:38
Re: Need help on a troublesome query plan Stephan Szabo 18:52
Re: Need help on a troublesome query plan Alain Lavigne 19:02
Re: Indexing UNIONs Bruno Wolff III 19:20
Re: Seeding Chad Thompson 19:38
Re: Need help on a troublesome query plan Stephan Szabo 20:31
Re: [SQL] line datatype Thomas Lockhart 20:42
Re: [SQL] line datatype Lamar Owen 20:46
Re: datatype matrix (was: Re: Sorry..) Josh Berkus 22:34
Re: Indexing UNIONs Josh Berkus 22:42

July 17, 2002

Thread Author Time
Newbie: Creative use of LIMIT?? Shmuel A. Kahn 02:20
Sequence name length Rudi Starcevic 02:38
Re: Sequence name length Christopher Kings-Lynne 02:49
Re: Sequence name length Tom Lane 03:40
Re: Sequence name length Christopher Kings-Lynne 03:45
Re: Sequence name length Rudi Starcevic 03:51
Re: A SQL Training Achilleus Mantzios 07:00
Re: Cascading deletions does not seem to work inside PL/PGSQL functions. Rajesh Kumar Mallah. 07:12
Large objects and Meta Data Dror Matalon 07:20
Re: datatype matrix (was: Re: Sorry..) Karel Zak 08:27
Re: Indexing UNIONs Richard Huxton 09:29
How to find out if an index is unique? Dirk Lutzebaeck 10:06
Re: How to find out if an index is unique? Achilleus Mantzios 10:15
why is postgres estimating so badly? Luis Alberto Amigo Navarro 10:17
Re: Indexing UNIONs Bruno Wolff III 12:06
Re: [HACKERS] please help on query Masaru Sugawara 13:28
Re: How to find out if an index is unique? Rajesh Kumar Mallah. 15:10
Re: [HACKERS] why is postgres estimating so badly? Nathan C. Burnett 17:04
Re: Cascading deletions does not seem to work inside PL/PGSQL Stephan Szabo 17:09
Re: [HACKERS] why is postgres estimating so badly? Tom Lane 17:43
Re: How to find out if an index is unique? Ligia Pimentel 22:27
Re: Seeding Peter Eisentraut 22:33

July 18, 2002

Thread Author Time
Re: Indexing UNIONs Josh Berkus 00:19
Re: Indexing UNIONs Bruno Wolff III 02:29
Re: Cascading deletions does not seem to work inside PL/PGSQL functions. Rajesh Kumar Mallah. 05:42
Re: Cascading deletions does not seem to work inside PL/PGSQL functions. Rajesh Kumar Mallah. 06:39
Re: [HACKERS] why is postgres estimating so badly? Luis Alberto Amigo Navarro 08:18
Re: how do i import my sql query result to a file Steve Brett 09:41
Re: Newbie: Creative use of LIMIT?? Richard Huxton 09:59
about Inheritance... frederik nietzsche 10:32
hints or suggestion for optimizer adrian 10:34
Re: how do i import my sql query result to a file Robert Treat 14:13
Re: How to find out if an index is unique? Christoph Haller 16:22
Re: Indexing UNIONs Josh Berkus 17:30
how do i import my sql query result to a file Joseph Syjuco 21:47

July 19, 2002

Thread Author Time
Re: how do i import my sql query result to a file Ludwig Lim 00:34
Regarding replication Charitha 06:31
Re: [SQL] id and ID in CREATE TABLE Christopher Kings-Lynne 06:55
Re: id and ID in CREATE TABLE Martijn van Oosterhout 07:20
Re: [SQL] id and ID in CREATE TABLE Josh Jore 09:09
Re: [SQL] id and ID in CREATE TABLE Tom Lane 13:31
Re: Regarding replication Josh Berkus 15:18
Adventures in PostgreSQL Josh Berkus 15:26
Re: [SQL] id and ID in CREATE TABLE Bruce Momjian 15:36
Re: [GENERAL] id and ID in CREATE TABLE 📎 Thomas Swan 15:39
Two Index Questions Josh Berkus 16:33
Re: Two Index Questions Tom Lane 16:44
Re: [SQL] id and ID in CREATE TABLE scott.marlowe 16:53
Re: Two Index Questions Bruno Wolff III 17:00
Re: how do i import my sql query result to a file Joseph Syjuco 17:15
Re: Two Index Questions Josh Berkus 17:28
Re: [SQL] id and ID in CREATE TABLE Bruce Momjian 17:29
Re: [SQL] id and ID in CREATE TABLE Tom Lane 17:33
Re: Two Index Questions Tom Lane 17:53
Re: Two Index Questions Bruno Wolff III 17:56
Re: Two Index Questions Josh Berkus 18:12
Re: Two Index Questions Bruce Momjian 18:27
Re: Two Index Questions Tom Lane 18:35
Is it possible to use a field from another table as part of a query? Patrick Hatcher 18:37
Re: Is it possible to use a field from another table as part of a query? Josh Berkus 18:54
Re: Two Index Questions Josh Berkus 18:58
Re: [SQL] id and ID in CREATE TABLE scott.marlowe 19:15
Re: Is it possible to use a field from another table as part of a Patrick Hatcher 19:26
Re: [SQL] id and ID in CREATE TABLE scott.marlowe 19:27
Re: [SQL] id and ID in CREATE TABLE Stephan Szabo 19:47
Re: [SQL] id and ID in CREATE TABLE Tom Lane 20:16

July 20, 2002

Thread Author Time
id and ID in CREATE TABLE stefan 07:15
Re: id and ID in CREATE TABLE stefan 07:39
Re: id and ID in CREATE TABLE stefan 11:33
Re: [SQL] id and ID in CREATE TABLE stefan 20:01

July 21, 2002

Thread Author Time
7.3 features and enhancements mark carew 00:11

July 22, 2002

Thread Author Time
Float / Numeric ? Rudi Starcevic 00:06
"no wait" in locks Daniel Stüwe 00:50
"no wait" in locks Daniel Stüwe 00:54
"no wait" option for locks Daniel Stüwe 01:10
Re: 'no wait' option for locks mallah 03:26
Re: SQL problem with aggregate functions. Hubert depesz Lubaczewski 08:26

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 31