pgsql-sql since 2002-04-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

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

April 28, 2002

Thread Author Time
Re: Upgrading PostgreSQL to 7.1.3 Gordon Clarke 05:24
Re: Function won't complete Josh Berkus 19:39

April 29, 2002

Thread Author Time
Casting dates Joseph Barillari 00:56
IN, EXISTS or ANY? Josh Berkus 04:44
Re: IN, EXISTS or ANY? Tom Lane 04:54
Re: IN, EXISTS or ANY? Josh Berkus 05:24
Temporary table weirdness Joseph Barillari 06:20
view on system tables upgrade II Christoph Haller 10:24
Re: view on system tables upgrade II Tom Lane 14:02
Re: Temporary table weirdness Bruce Momjian 14:04
Re: Temporary table weirdness Tom Lane 14:12
Re: Casting dates Josh Berkus 16:02
Re: Temporary table weirdness Joseph Barillari 16:07
Re: Casting dates Joseph Barillari 16:19
Re: abnormal size of the on-disk file. Stephan Szabo 16:46
convert from sybase to postgresql Frank Morton 23:08

April 30, 2002

Thread Author Time
join-performance problem Wolfgang.Fuertbauer 15:27
Re: join-performance problem Stephan Szabo 15:58
Re: join-performance problem Tom Lane 16:44
Bug #652: NAMEDATALEN limitations pgsql-bugs 18:15
Re: Bug #652: NAMEDATALEN limitations Tom Lane 18:32
Re: Bug #652: NAMEDATALEN limitations Tom Lane 18:45
Re: Bug #652: NAMEDATALEN limitations Tom Lane 20:04
performance on update table from a join Jean-Luc Lachance 20:34
Re: performance on update table from a join Tom Lane 20:49
Re: performance on update table from a join Jean-Luc Lachance 21:34
Re: performance on update table from a join Tom Lane 21:51
Re: performance on update table from a join Jean-Luc Lachance 22:07
Re: Out of free buffers... HELP! Tom Lane 22:50

May 1, 2002

Thread Author Time
Re: convert from sybase to postgresql Nick Fankhauser 16:37
Problems returning multiple columns Travis Hoyt 16:51
Re: problem with update from subselect Stephan Szabo 16:55
Re: problem with update from subselect Joe Conway 17:09
problem with update from subselect Gary Stainburn 17:29
CREATE VIEW question... j.konzack 19:53
Re: CREATE VIEW question... Oliver Elphick 20:51

May 2, 2002

Thread Author Time
Re: CREATE VIEW question... Joel Burton 03:17
Re: join-performance problem Wolfgang.Fuertbauer 08:00
Weird select output... Rajesh Kumar Mallah. 09:16
Re: Weird select output... Rajesh Kumar Mallah. 09:36
Re: join-performance problem Tom Lane 13:58
get transaction no. wit 15:06
Subselect performance question Josh Berkus 16:37
Re: Subselect performance question Manfred Koizar 20:47
Re: Subselect performance question Tom Lane 20:56
Re: Subselect performance question Josh Berkus 22:38

May 3, 2002

Thread Author Time
Odd behavior with timestamp/interval arithmetic Joseph Barillari 20:38
Returning composite types from a plpgsql function Joseph Barillari 21:24
Re: Odd behavior with timestamp/interval arithmetic Josh Berkus 21:59
Re: Returning composite types from a plpgsql function Tom Lane 22:24

May 4, 2002

Thread Author Time
difficult query Jakub Ouhrabka 14:00
Re: difficult query Ian Barwick 15:44
Re: difficult query Jakub Ouhrabka 17:34
Syntax error in plpgsql crashes backend Joseph Barillari 18:09
Re: difficult query Ian Barwick 18:19
Re: Syntax error in plpgsql crashes backend Joseph Barillari 18:19
Re: Syntax error in plpgsql crashes backend dman 18:35
Re: Syntax error in plpgsql crashes backend Joseph Barillari 18:44
Re: difficult query (fwd) Jakub Ouhrabka 19:21
More long-string woes Joseph Barillari 20:57
Re: Syntax error in plpgsql crashes backend Roberto Mello 23:26
INserting images in postgres sharmad 23:31

May 5, 2002

Thread Author Time
Re: difficult query Masaru Sugawara 05:43
Re: More long-string woes Tom Lane 06:01
Re: difficult query Joel Burton 06:19
Re: More long-string woes Tom Lane 17:47

May 6, 2002

Thread Author Time
summary VIEW Gary Stainburn 11:41
Re: summary VIEW Gary Stainburn 13:08

May 7, 2002

Thread Author Time
Optimizing the implementation of an optimized tree 📎 Christian Rishoej 01:02
Re: Optimizing the implementation of an optimized tree Christopher Kings-Lynne 02:00

Browse Archives

Prev | Next