pgsql-sql since 2002-04-13 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 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30

April 13, 2002

Thread Author Time
Re: Problem With A Rule (clear version) cnliou 01:16
Re: Proposal: New Mailing List Rajesh Kumar Mallah 06:15
deletions on master table takes for ever... Rajesh Kumar Mallah 10:07
Re: deletions on master table takes for ever... Stephan Szabo 14:57
to_char problem postgresql 16:57
Re: to_char problem Tom Lane 17:00

April 15, 2002

Thread Author Time
data order problem jack 03:19
Re: data order problem Josh Berkus 04:53
Re: data order problem Tom Lane 04:55
Re: data order problem jack 06:40
case statement in group by clause Dorian Taylor 10:44
Re: case statement in group by clause Tom Lane 14:35
Re: How slow is DISTINCT? Tom Lane 14:49
Re: Thank you ! Re: Is there any Faster workaround ?? Roberto Mello 15:23
Re: data order problem Josh Berkus 15:46
Large or Small tables? Edipo Elder Fernandes de Melo 17:38
Re: data order problem Stephan Szabo 17:45
MAX(column1),MAX(column2),... Bjarte Aagnes 18:38
Re: oid and oidvector Bruce Momjian 19:13
Re: MAX(column1),MAX(column2),... Josh Berkus 19:34
Re: MAX(column1),MAX(column2),... Travis Hoyt 20:17
Re: oid and oidvector Tom Lane 20:36
Re: oid and oidvector Bruce Momjian 20:39
Re: oid and oidvector Tom Lane 20:47

April 16, 2002

Thread Author Time
please advise on column data type jack 01:25
Re: How slow is DISTINCT? Christopher Kings-Lynne 01:53
Re: please advise on column data type Josh Berkus 02:51
Re: [SQL] 16 parameter limit 📎 Bruce Momjian 02:58
Re: [PATCHES] [SQL] 16 parameter limit Rod Taylor 03:19
Re: [SQL] 16 parameter limit Josh Berkus 03:25
Re: [PATCHES] [SQL] 16 parameter limit Alvaro Herrera 03:34
Re: [SQL] 16 parameter limit Peter Eisentraut 03:34
Re: [SQL] 16 parameter limit Christopher Kings-Lynne 03:35
Re: [PATCHES] [SQL] 16 parameter limit Neil Conway 03:42
Re: [PATCHES] [SQL] 16 parameter limit Bruce Momjian 03:44
Re: [PATCHES] [SQL] 16 parameter limit Christopher Kings-Lynne 03:49
Re: [SQL] 16 parameter limit Neil Conway 03:52
Re: [SQL] 16 parameter limit Christopher Kings-Lynne 03:57
Re: [SQL] 16 parameter limit Bruce Momjian 03:57
Re: [SQL] 16 parameter limit Josh Berkus 04:06
Re: [SQL] 16 parameter limit Tom Lane 04:13
Re: [PATCHES] [SQL] 16 parameter limit Peter Eisentraut 04:36
Re: please advise on column data type Tom Lane 04:47
Re: [SQL] 16 parameter limit John Proctor 04:49
Re: [SQL] 16 parameter limit Josh Berkus 04:50
Re: [PATCHES] [SQL] 16 parameter limit Tom Lane 05:01
Re: [PATCHES] [SQL] 16 parameter limit Bruce Momjian 05:06
help - JOIN problem KeithR 14:10
Re: [SQL] 16 parameter limit Neil Conway 16:04
Re: [PATCHES] [SQL] 16 parameter limit Hannu Krosing 19:12

April 17, 2002

Thread Author Time
Re: help - JOIN problem Josh Berkus 04:32
Re: [SQL] 16 parameter limit John Proctor 06:22
My is degraded after two weeks Fernando Carvalho 11:10
Need some help in dates Stéphane DEWITTE 11:58
Need some help with dates Stéphane DEWITTE 12:33
How to reset sequences on pre-7.1 Matteo Beccati 12:44
Re: Need some help with dates Gautham S. Rao 13:00
Re: Need some help with dates Stéphane DEWITTE 13:01
Re: Need some help with dates Stéphane DEWITTE 13:33
Re: Need some help with dates Gautham S. Rao 13:49
Re: [SQL] 16 parameter limit Christopher Kings-Lynne 14:29
Re: [SQL] 16 parameter limit Larry Rosenman 14:41
Re: Need some help with dates Miguel Carvalho 14:53
Re: How to reset sequences on pre-7.1 Tom Lane 15:25
Re: [SQL] 16 parameter limit Josh Berkus 16:08
Re: Need some help with dates Josh Berkus 16:16
Help with conversions (suite) Stéphane DEWITTE 16:18
Re: My is degraded after two weeks Stephan Szabo 16:27
Re: [SQL] A bug in gistPageAddItem()/gist_tuple_replacekey() ??? Bruce Momjian 21:58
Re: call the same pl/pgsql procedure twice in the same connection Bruce Momjian 22:07

April 18, 2002

Thread Author Time
Re: LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1? Bruce Momjian 03:43
Migrating Oracle to PostgreSQL Makarov Gera x8521 05:24
SQL Query Optimization Dav Coleman 05:30
[No subject] fredrik.samuelsson 07:12
Re: now() does not change within a transaction Karel Zak 12:41
Re: [GENERAL] Migrating Oracle to PostgreSQL Leif Jensen 13:21
Re: Migrating Oracle to PostgreSQL Karel Zak 13:26
now() does not change within a transaction Christoph Haller 14:04
DISTINCT ON ... without distinct null values ? Albrecht Berger 14:43
Re: SQL Query Optimization Josh Berkus 15:43
Re: now() does not change within a transaction Bruce Momjian 15:50
Re: SQL Query Optimization Tom Lane 16:15
Re: SQL Query Optimization Dav Coleman 16:35
Re: call the same pl/pgsql procedure twice in the same connection Jan Wieck 16:43
Re: SQL Holiday Calculations Josh Berkus 17:19
Re: call the same pl/pgsql procedure twice in the same connection Bruce Momjian 17:22
Re: call the same pl/pgsql procedure twice in the same connection Richard Huxton 17:22
Re: SQL Query Optimization Josh Berkus 17:38
Re: SQL Query Optimization Richard Huxton 17:38
Re: call the same pl/pgsql procedure twice in the same connection Jan Wieck 18:49
Re: DISTINCT ON ... without distinct null values ? Fduch the Pravking 23:30

April 19, 2002

Thread Author Time
Re: [DOCS] [GENERAL] Migrating Oracle to PostgreSQL Roberto Mello 01:41
count different values in column? Thorsten Wenzlaff 09:27
count different values in column Albrecht Berger 09:30
Re: count different values in column Tod McQuillin 09:40
Re: count different values in column Fduch the Pravking 09:55
Re: count different values in column Gautham S. Rao 10:00
how to get index scan at work? Rajesh Kumar Mallah 11:10
Re: how to get index scan at work? 📎 Thomas Swan 11:23
Re: count different values in column Christoph Haller 11:46
Re: [SQL] MAX(column1),MAX(column2),... Bjarte Aagnes 13:00
How to log outputs from pl/pgsql into a file ? Stéphane DEWITTE 14:39
Re: how to get index scan at work? Rajesh Kumar Mallah 16:33
Re: how to get index scan at work? Stephan Szabo 17:12
Re: How to log outputs from pl/pgsql into a file ? Jie Liang 18:32
Query Praise! Matthew Hagerty 19:24
Trying to get query to work Brian Kosick 20:07
Trying to get query to work. Brian Kosick 20:10

April 20, 2002

Thread Author Time
accept AD35- 6FA9 -9515 tulasi 07:01
Re: count different values in column? Rajesh Kumar Mallah 17:23
OpenFTS/tsearch and Postgresql 7.2.1 Rajesh Kumar Mallah 19:00
postgresql query to XML result Rishabh Gupta 21:01

April 21, 2002

Thread Author Time
Re: accept AD35- 6FA9 -9515 Peter Eisentraut 04:45
Re: [OpenFTS-general] OpenFTS/tsearch and Postgresql 7.2.1 Oleg Bartunov 05:02
Re: Trying to get query to work Stephan Szabo 06:04
Is this a BUG? Is there anyone has the same problem? jack 13:39
Re: accept AD35- 6FA9 -9515 postgresql 14:10
Re: Is this a BUG? Is there anyone has the same problem? Tom Lane 15:13

April 22, 2002

Thread Author Time
Identity not disvoered by planner? Daniel Lundin 11:34
Is this a BUG? Is there anyone has the same problem? jack 11:36
Re: Is this a BUG? Is there anyone has the same problem? Tom Lane 16:35
Re: Is this a BUG? Is there anyone has the same problem? David Stanaway 17:36
Re: Is this a BUG? Is there anyone has the same problem? Tom Lane 17:47
efficient query help Laurette Cisneros 18:10
calling a pl/pgsql function with array in argument Ruben Vivas 20:05
Re: efficient query help Clinton Adams 21:23

April 23, 2002

Thread Author Time
How to discover foreign keys (without pulling hair out) Ian Morgan 06:54
Cannot get to use index scan on a big table! Rajesh Kumar Mallah 07:48
Date indexing Ian Cass 09:35
Re: Date indexing Dima Tkach 12:56
Re: Date indexing Tom Lane 13:56
Re: Date indexing Ian Cass 14:03
Re: Date indexing Ian Cass 14:07
Re: Cannot get to use index scan on a big table! Stephan Szabo 15:01
Re: call the same pl/pgsql procedure twice in the same connection Bruce Momjian 16:15
Re: call the same pl/pgsql procedure twice in the same connection Jan Wieck 16:31

April 24, 2002

Thread Author Time
Re: call the same pl/pgsql procedure twice in the same connection Bruce Momjian 00:36
Re: Upgrading PostgreSQL to 7.1.3 Rajesh Kumar Mallah 05:30
Re: Cannot get to use index scan on a big table! Rajesh Kumar Mallah 05:57
Proper quoting of \e Helge Kreutzmann 13:12
BLOB Feature Limits Bullock, Dempsey 14:04
Re: efficient query help Joel Burton 14:06
Re: efficient query help Joel Burton 14:47
Re: BLOB Feature Limits Ian Morgan 18:10
Connection authentication Oleg Lebedev 19:32

April 25, 2002

Thread Author Time
Pl/pgSQL Question. Bruno Ricardo Sacco 04:34
Pl/pgSQL Question. Bruno Ricardo Sacco 04:44
SELECT in a function != SELECT ? Ian Morgan 05:44
Re: SELECT in a function != SELECT ? Joe Conway 06:13
Database Server in Recovery mode! Rajesh Kumar Mallah 06:52
followups : Database Server in Recovery mode! Rajesh Kumar Mallah 07:06
Re: Database Server in Recovery mode! Rajesh Kumar Mallah 07:10
HAVING - clause Morten Sickel 09:32
Proper quoting of \e ? Helge Kreutzmann 10:22
Re: How to discover foreign keys (without pulling hair out) bob lapique 12:27
Re: HAVING - clause Christoph Haller 12:44
Again: Identity not discovered by planner? Daniel Lundin 13:08
Re: SELECT in a function != SELECT ? Jan Wieck 13:53
Re: Database Server in Recovery mode! Stephan Szabo 14:37
Re: Connection authentication Bruce Momjian 14:43
copy command Duncan Adams (DNS) 14:53
Re: Proper quoting of \e ? Bruce Momjian 15:47
Re: Proper quoting of \e ? Helge Kreutzmann 15:57
Re: Proper quoting of \e ? Joe Conway 16:23
Re: SELECT in a function != SELECT ? David Stanaway 16:46
Re: Again: Identity not discovered by planner? Tom Lane 16:57
Re: How to discover foreign keys (without pulling hair out) Ian Morgan 17:04
Collection of PostgreSQL Performance Tips Brubaker, Shane 17:25
Re: copy command ARP 18:34
Re: HAVING - clause Bill Cunningham 18:51

April 26, 2002

Thread Author Time
Re: copy command svilen 00:39
Re: Database Server in Recovery mode! Rajesh Kumar Mallah 05:43
Use of indexes Andre Schubert 07:09
Re: Use of indexes Christopher Kings-Lynne 07:30
abnormal size of the on-disk file. Rajesh Kumar Mallah 14:52
Wierd error for COPY command Josh Berkus 15:42
How do I create unique IDs for an existing set of records Nick Fankhauser 15:58
union query format Robert Wynter 16:04
Re: view on system tables upgrade? Tom Lane 16:04
Re: Wierd error for COPY command Tom Lane 16:11
Re: How do I create unique IDs for an existing set of records Tom Lane 16:14
Re: How do I create unique IDs for an existing set of records Nick Fankhauser 16:17
Re: Wierd error for COPY command Josh Berkus 16:51
view on system tables upgrade? Christoph Haller 17:05
Re: Wierd error for COPY command Josh Berkus 17:15
Re: Wierd error for COPY command PG Explorer 17:25
Wierd query behaviour Josh Berkus 19:38
Re: Connection authentication Oleg Lebedev 20:01
Re: union query format Josh Berkus 20:42
Trying to purchase an annual subscription to the CD distribution Wayne Seward 20:45
Re: Connection authentication Ron Peterson 20:49
Trying to purchase an annual subscription to the CD distribution Wayne Seward 20:51
Re: union query format Joel Burton 21:32
Function won't complete Josh Berkus 21:57
Re: Wierd query behaviour Tom Lane 22:43
Re: Function won't complete Tom Lane 22:54

April 27, 2002

Thread Author Time
pg_shadow password Eduardo Gargiulo 04:28
Re: pg_shadow password Bruce Momjian 05:33
Re: Function won't complete Josh Berkus 18:15
Re: Function won't complete Tom Lane 21:36

Browse Archives

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