Mailing lists [pgsql-sql]

1 February 2003

• 00:15   Re: CSV import Guy Fraser
• 01:39   Re: For each record in SELECT Andrew J. Kopciuch
• 01:42   Controlling access to Sequences Matthew Horoschun
• 02:10   Re: Controlling access to Sequences Tom Lane
• 02:29   Re: Controlling access to Sequences Matthew Horoschun
• 02:45   Re: Controlling access to Sequences Tom Lane
• 03:08   Re: Which version is this? Rajesh Kumar Mallah.
• 03:15   Re: Controlling access to Sequences Matthew Horoschun
• 04:14   Re: Controlling access to Sequences Stephan Szabo
• 04:27   Re: Controlling access to Sequences Bruno Wolff III
• 10:39   update and IN vs. EXISTS pginfo
• 10:45   vacuum and serial primary keys Carmen Marincu
• 12:16   Re: vacuum and serial primary keys D'Arcy J.M. Cain
• 12:41   Re: update and IN vs. EXISTS Bruno Wolff III
• 12:48   Re: update and IN vs. EXISTS pginfo
• 21:42   Re: Controlling access to Sequences Ross J. Reedstrom

2 February 2003

• 03:07   extracting constraints from schema Agnieszka Rutkowska
• 03:07   Re: Creating tables from within functions Sondaar Roelof
• 03:07   COPY use in function with variable file name Sondaar Roelof
• 03:07   Re: double linked list jasche@gmx.de (Juergen)
• 03:07   returning table from a function Seethalakshmi VB
• 03:08   Re: double linked list 71062.1056@compuserve.com (--CELKO--)
• 03:08   Re: double linked list hidders@REMOVE.THIS.uia.ua.ac.be (Jan Hidders)
• 03:08   Re: double linked list Ryan
• 03:08   Re: Filter function Evgen Potemkin
• 03:08   how do i create a date from a substring??? joe.guyot
• 03:08   Re: [NOVICE] For each record in SELECT Andrew McMillan
• 03:08   Index File growing big. PRAGATI SAVAIKAR
• 03:08   how can i convert a substring to a date? joe.guyot
• 03:08   Re: double linked list 71062.1056@compuserve.com (--CELKO--)
• 03:08   Help with a query for charting Andrew Veitch
• 06:33   Re: Postgres MD5 Function David Durst
• 06:40   Re: how can i convert a substring to a date? Ross J. Reedstrom
• 06:43   Re: Postgres MD5 Function Joe Conway
• 07:45   Re: CR/LF conversion (was: import error) Bruce Momjian
• 11:02   Re: returning table from a function 
• 12:40   Re: Help with a query for charting 
• 12:48   help: pgSQL docs and debug Vic Cekvenich
• 13:44   How to return records from a function John Cavacas
• 14:34   Re: How to return records from a function John Cavacas
• 15:30   Re: help: pgSQL docs and debug Tomasz Myrta
• 15:38   Re: how do i create a date from a substring??? Tomasz Myrta
• 18:29   Re: Help with a query for charting greg@turnstep.com
• 19:30   Re: COPY use in function with variable file name Oliver Elphick
• 19:47    mail.luckydigital.com
• 20:01   Re: PL/pgSQL question Josh Berkus
• 20:12   Re: Oliver Elphick
• 21:46   Re: extracting constraints from schema Tomasz Myrta
• 22:55   window version of psql of postgreSQL v7.3.1 jack
• 23:36   TEMP tables Lex Berezhny
• 23:58   Re: TEMP tables Bruce Momjian

3 February 2003

• 06:39   Re: update and IN vs. EXISTS Tambet Matiisen
• 07:41   Commenting PLPGSQL David Durst
• 07:56   Re: TEMP tables Tomasz Myrta
• 07:57   Re: Commenting PLPGSQL Tomasz Myrta
• 08:32   Format in psql Bhuvan A
• 08:41   Re: Format in psql Tomasz Myrta
• 08:51   Re: Format in psql Ian Barwick
• 11:59   cannot EXPLAIN query... Rajesh Kumar Mallah.
• 12:10   Re: cannot EXPLAIN query... Tomasz Myrta
• 12:59   Re: cannot EXPLAIN query... Tom Lane
• 13:33   Re: cannot EXPLAIN query... Rajesh Kumar Mallah.
• 13:41   Re: cannot EXPLAIN query... Tom Lane
• 13:44   Re: cannot EXPLAIN query... Rajesh Kumar Mallah.
• 13:49   Re: cannot EXPLAIN query... Tom Lane
• 13:51   Re: cannot EXPLAIN query... Bruce Momjian
• 13:54   Re: cannot EXPLAIN query... Rajesh Kumar Mallah.
• 13:55   Re: cannot EXPLAIN query... Christoph Haller
• 13:56   Re: cannot EXPLAIN query... Rajesh Kumar Mallah.
• 14:28   Re: cannot EXPLAIN query... Rajesh Kumar Mallah.
• 14:40   unsubscribe Josef Astner
• 15:34   Re: cannot EXPLAIN query... 
• 17:31   float and numeric in 7.3 Tomasz Myrta
• 19:36   SQL99/SQL92 Grammar Les Hazlewood
• 19:54   Re: float and numeric in 7.3 Tom Lane

4 February 2003

• 00:43   pg_views Lex Berezhny
• 03:04   Re: Format in psql Bhuvan A
• 04:02   iceberg queries Wei Weng
• 06:40   Re: iceberg queries Christoph Haller
• 07:02   Re: pg_views Christoph Haller
• 08:59   Re: SQL99/SQL92 Grammar Bruce Momjian
• 12:10   Re: iceberg queries Wei Weng
• 13:37   Re: iceberg queries Bruno Wolff III
• 15:37   Re: pg_views Jan Wieck
• 16:09   Re: iceberg queries Jan Wieck
• 16:37   Re: iceberg queries Tom Lane
• 16:47   Re: pg_views Tom Lane
• 20:01   Serialized Transaction Locking Issues justin
• 21:17   Re: iceberg queries Jan Wieck
• 21:21   Re: Serialized Transaction Locking Issues Tom Lane

5 February 2003

• 01:38   Inserting a tab character Luke Pascoe
• 01:54   Re: Inserting a tab character Matthew Horoschun
• 05:59   Re: Inserting a tab character Ludwig Lim
• 06:51   Lock timeout detection in postgres 7.3.1 Muhammad Shariq Muzaffar
• 07:52   bytea Adrian Chong
• 08:15   Re: bytea Christoph Haller
• 08:22   Re: bytea Adrian Chong
• 09:43   Postgresql To Oracle9i Atul Pedgaonkar
• 10:04   Re: bytea Christoph Haller
• 12:07   Re: Inserting a tab character Christoph Haller
• 12:36   Problem with VACUUM Marcelo Pereira Tada
• 13:28   automatic time/user stamp - rule or trigger? Neal Lindsay
• 13:48   Re: [ADMIN] Problem with VACUUM Tom Lane
• 13:50   Re: automatic time/user stamp - rule or trigger? Achilleus Mantzios
• 15:49   design question: status table+log table, indexes, triggers george young
• 16:28   Re: Postgresql To Oracle9i Jan Wieck
• 17:03   Re: automatic time/user stamp - rule or trigger? Jan Wieck
• 17:07   Re: design question: status table+log table, indexes, triggers Tom Lane
• 17:37   Re: automatic time/user stamp - rule or trigger? Neal Lindsay

6 February 2003

• 02:02   to_date has beaten me... Rodger Donaldson
• 02:23   Re: to_date has beaten me... Tom Lane
• 02:25   Re: to_date has beaten me... Rodger Donaldson
• 02:59   Re: to_date has beaten me... Roberto Mello
• 07:19   Re: to_date has beaten me... Rodger Donaldson
• 07:54   Re: Lock timeout detection in postgres 7.3.1 Christoph Haller
• 09:04   TIME vs. TIMESTAMP data type Ludwig Lim
• 09:14   Re: Lock timeout detection in postgres 7.3.1 Ludwig Lim
• 10:00   Re: TIME vs. TIMESTAMP data type Tomasz Myrta
• 10:06   Trigger para fazer log Maurício Sessue Otta
• 10:08   Re: TIME vs. TIMESTAMP data type Ludwig Lim
• 10:12   Re: Lock timeout detection in postgres 7.3.1 Christoph Haller
• 10:15   Re: TIME vs. TIMESTAMP data type Julian Scarfe
• 11:44   Re: Trigger para fazer log Tomasz Myrta
• 13:51   Re: Trigger para fazer log Roberto Mello
• 16:40   Returning records from a function oogly@rogers.com (John C)
• 16:40   Re: How to return records from a function jasiek@serwer.skawsoft.com.pl
• 16:40   7.2 functions that return multiple result sets? mail.luckydigital.com
• 16:40   numeric when compared to literal Vicente Alabau Gonzalvo
• 16:40   Automatic casting Vicente Alabau Gonzalvo
• 16:40   get # of rows while doing SELECT with LIMIT at same time ? thatsamiam@yahoo.com (Sam Iam)
• 16:40   conversi ms-sql7 vs postgresql 7.3 betty
• 16:40   Re: automatic time/user stamp - rule or trigger? codeWarrior
• 16:40   Serialized Transaction Locking Issues Jasper Tymesman
• 17:01   Re: Returning records from a function Lex Berezhny
• 17:20   Re: get # of rows while doing SELECT with LIMIT at same time ? Roberto Mello
• 17:25   changing referential integrety action on existing table Matthew Nuzum
• 17:31   Re: 7.2 functions that return multiple result sets? Chad Thompson
• 18:19   Re: changing referential integrety action on existing table Stephan Szabo
• 18:31   Re: numeric when compared to literal Tom Lane
• 21:09   Re: 7.2 functions that return multiple result sets? Ian Barwick
• 21:14   Re: Automatic casting Josh Berkus

7 February 2003

• 05:47   PostgreSQL 7.3.1 multiple schema select query error: java.sql.SQLException: ERROR: parser: parse error at or near "." waimeng
• 05:58   Re: automatic time/user stamp - rule or trigger? Achilleus Mantzios
• 06:02   "function has no parameter $1" - help. Michael Weaver
• 06:11   which will be faster? w/ or w/o indices val@webtribe.net
• 06:23   PostgreSQL 7.3.1 multiple schema select query error: java.sql.SQLException: ERROR: parser: parse error at or near "." waimeng
• 06:28   Re: "function has no parameter $1" - help. Christoph Haller
• 07:21   Re: PostgreSQL 7.3.1 multiple schema select query error: Achilleus Mantzios
• 07:41   SET TIMEOUT equivalent / was: Lock timeout detection Christoph Haller
• 07:41   Re: which will be faster? w/ or w/o indices dev@archonet.com
• 08:00   Re: conversi ms-sql7 vs postgresql 7.3 Christoph Haller
• 08:10   efficient count/join query Gary Stainburn
• 08:26   Re: Lock timeout detection in postgres 7.3.1 Tomasz Myrta
• 08:26   Re: SET TIMEOUT equivalent / was: Lock timeout detection Tomasz Myrta
• 08:44   Re: efficient count/join query Tomasz Myrta
• 09:39   Re: Lock timeout detection in postgres 7.3.1 Christoph Haller
• 09:46   Re: conversi ms-sql7 vs postgresql 7.3 Richard Huxton
• 10:12   Re: efficient count/join query Gary Stainburn
• 11:00   Re: efficient count/join query Gary Stainburn
• 11:28   Re: efficient count/join query Tomasz Myrta
• 11:36   Re: efficient count/join query Richard Huxton
• 11:47   prosgrees + java + trasnacciones jose antonio leo
• 12:23   Re: efficient count/join query Gary Stainburn
• 12:33   Re: efficient count/join query Tomasz Myrta
• 15:27   Re: which will be faster? w/ or w/o indices Josh Berkus
• 15:42   update column with rowtype betty
• 15:42   Re: "function has no parameter $1" - help. Daniel Schuchardt
• 16:54   Re: bytea Steve Crawford
• 18:58   Start and End Day of a Week Luis Magaña
• 21:52   Re: Start and End Day of a Week Luis Magaña

8 February 2003

• 03:42   plpgsql + dblink() question Frankie
• 03:50   query help/sugestions John Cavacas
• 04:07   Re: plpgsql + dblink() question Joe Conway
• 04:30   Re: query help/sugestions Roberto Mello
• 04:56   Re: query help/sugestions John Cavacas
• 05:34   Re: query help/sugestions John Cavacas
• 14:32   Re: query help/sugestions Roberto Mello
• 15:27   Re: query help/sugestions John Cavacas
• 21:34   referencing column names properly Sill-II, Stephen

9 February 2003

• 00:08   Re: query help/sugestions Roberto Mello
• 02:26   Re: referencing column names properly Bruno Wolff III
• 03:50   Re: referencing column names properly Ross J. Reedstrom
• 05:28   Design question: How to convert a given data structure to sql and the opposite. Hanan Hotmail
• 12:18   Re: referencing column names properly Sill-II, Stephen
• 20:31   order by date desc but NULLs last A.M.
• 20:56   Re: referencing column names properly Ross J. Reedstrom
• 21:12   Re: order by date desc but NULLs last Ross J. Reedstrom
• 23:48   How to delete duplicate record Abdul Wahab Dahalan

10 February 2003

• 01:39   Re: plpgsql + dblink() question Frankie Lam
• 04:19   Re: order by date desc but NULLs last Tomasz Myrta
• 04:24   Re: How to delete duplicate record Tomasz Myrta
• 05:11   Re: How to delete duplicate record Stephan Szabo
• 05:44   Re: How to delete duplicate record Tomasz Myrta
• 05:46   Re: plpgsql + dblink() question Frankie Lam
• 08:25   index strategies val@webtribe.net
• 10:20   Referential Integrity Alexander Stanier
• 12:44   Re: How to delete duplicate record greg@turnstep.com
• 13:10   Re: Referential Integrity Tom Lane
• 13:54   Re: Referential Integrity Stephan Szabo
• 14:12   Re: Referential Integrity Alexander Stanier
• 16:05   problems with date and interval queries. 
• 16:14   Re: problems with date and interval queries. Stephan Szabo
• 16:21   Re: problems with date and interval queries. Tom Lane
• 16:33   Re: order by date desc but NULLs last Jean-Luc Lachance
• 16:52   Re: order by date desc but NULLs last Ross J. Reedstrom
• 17:03   Re: problems with date and interval queries. Stephan Szabo
• 17:04    Ehmann, Mary
• 17:04   Re: conversi ms-sql7 vs postgresql 7.3 betty
• 17:04   PL/Pgsql trigger function problem. James C. Ousley
• 17:04   DATABASE EXAMPLES? Eduardo
• 17:05   PostgreSQL SQL Conformance postgresql
• 17:05   On delete cascade not working Alexander Stanier
• 19:04   Re: conversi ms-sql7 vs postgresql 7.3 greg@turnstep.com
• 19:39   Re: conversi ms-sql7 vs postgresql 7.3 Josh Berkus

11 February 2003

• 07:14   which type for primary key? Rafal Kedziorski
• 08:06   Re: On delete cascade not working Alexander Stanier
• 08:50   Re: which type for primary key? Tomasz Myrta
• 11:29   Problems with Transactions Héctor Iturre
• 13:01   vacuum failure... Michael Richards
• 13:34   constrains questios .. Rafal Kedziorski
• 13:43   Re: vacuum failure... Tom Lane
• 14:06   PL/Pgsql trigger function issue... arcpro
• 14:27   Re: vacuum failure... Michael Richards
• 14:29   Re: vacuum failure... Tom Lane
• 14:31   Re: PL/Pgsql trigger function issue... Peter Childs
• 15:29   Re: constrains questios .. Johannes Lochmann
• 15:41   Re: constrains questios .. Matthew Nuzum
• 15:59   Re: constrains questios .. Johannes Lochmann
• 20:26   anal about my syntax James Cooper
• 21:28   What is wrong with this identification configuration? Wei Weng
• 21:42   Working with very large datasets Wilkinson Charlie E
• 21:44   adding not null constraints on columns Susan
• 22:02   Re: Working with very large datasets Stephan Szabo
• 22:33   Re: Working with very large datasets Lex Berezhny
• 23:10   Re: anal about my syntax Josh Berkus
• 23:32   Re: What is wrong with this identification configuration? Bruno Wolff III

12 February 2003

• 00:45   Re: What is wrong with this identification configuration? Wei Weng
• 01:01   Re: Lock timeout detection in postgres 7.3.1 Bruce Momjian
• 01:32   Re: What is wrong with this identification configuration? Bruno Wolff III
• 04:17   How to incorporate exec sql describe select list ( available in sql server in postgres) Prashanth - Kamath
• 04:18   Re: adding not null constraints on columns Tom Lane
• 06:54   Re: How to incorporate exec sql describe select list Christoph Haller
• 07:13   timestamp Daniel Jaenecke
• 11:49   Re: PL/Pgsql trigger function problem. Christoph Haller
• 12:18   Re: Problems with Transactions Christoph Haller
• 12:37   Sum of Intervals Plant Thomas
• 12:55   Re: PL/Pgsql trigger function problem. Jr.
• 13:24   Re: Sum of Intervals Bruno Wolff III
• 14:16   Re: timestamp Dmitry Tkach
• 16:12   How do you select from a table until a condition is met? Nicholas Allen
• 17:00   Re: How do you select from a table until a condition is met? Dmitry Tkach
• 17:12   Re: How do you select from a table until a condition is met? Nicholas Allen
• 17:21   Re: How do you select from a table until a condition is met? Dmitry Tkach
• 17:22   Re: How do you select from a table until a condition is met? Bruno Wolff III
• 17:57   Re: How do you select from a table until a condition is met? Nicholas Allen
• 18:00   PL/Pgsql trigger function issue.. James C. Ousley
• 18:01   What's wrong with this identification configuration? Wei Weng
• 18:01   timestamp Daniel Jaenecke
• 18:01   null foreign key column Arunachalam Jaisankar
• 18:01   R: adding not null constraints on columns Alessandro Pedrotti
• 18:01   PL/PGSQL TUTORIAL Eduardo
• 18:02   Re: How do you select from a table until a condition is met? Nicholas Allen
• 18:24   Re: How do you select from a table until a condition is met? Bruno Wolff III
• 18:25   Re: How do you select from a table until a condition is met? Dmitry Tkach
• 18:27   Re: null foreign key column Bruno Wolff III
• 18:45   Re: timestamp Larry Rosenman
• 18:46   Re: null foreign key column Dmitry Tkach
• 19:08   Re: How do you select from a table until a condition is met? Nicholas Allen
• 19:15   Re: How do you select from a table until a condition is met? Dmitry Tkach
• 19:18   Re: Working with very large datasets Wilkinson Charlie E
• 20:23   Possible bug in Postgres? Followup to "How do you select from a table until a condition is met?" Nicholas Allen
• 20:37   Re: null foreign key column Vernon Wu
• 20:40   Re: null foreign key column Dmitry Tkach
• 21:03   Re: null foreign key column Wei Weng
• 22:59   Re: anal about my syntax Josh Berkus
• 23:52   dblink question please Frankie Lam

13 February 2003

• 00:02   SQL Functions vs PL/PgSQL Johnny Kristensen
• 00:05   Re: Possible bug in Postgres? Followup to "How do you select from a table until a condition is met?" Bruno Wolff III
• 02:20   Re: dblink question please Joe Conway
• 02:31   Re: dblink question please Frankie Lam
• 03:24   Re: What's wrong with this identification configuration? Tom Lane
• 03:28   Re: dblink question please Joe Conway
• 05:24   Re: dblink question please Frankie Lam
• 06:52   UNION or UNION ALL Abdul Wahab Dahalan
• 07:43   Re: Possible bug in Postgres? Followup to "How do you select from a table until a condition is met?" Nicholas Allen
• 07:49   Re: SQL Functions vs PL/PgSQL Tomasz Myrta
• 07:58   Re: Possible bug in Postgres? Followup to "How do you select Peter Childs
• 08:06   Re: Possible bug in Postgres? Followup to "How do you select Nicholas Allen
• 08:25   Re: Possible bug in Postgres? Followup to "How do you select Peter Childs
• 08:41   Debugging postmaster to fix possible bug in Postgres? Followup to "How do you select Nicholas Allen
• 10:05   Re: UNION or UNION ALL Tomasz Myrta
• 10:32   Re: dblink question please Joe Conway
• 13:18   Re: Debugging postmaster to fix possible bug in Postgres? Followup to "How do you select Tom Lane
• 14:21   Generating serial number column Mintoo Lall
• 14:43   Re: Generating serial number column Gary Stainburn
• 14:45   table Pivot V. Cekvenich
• 15:02   Re: SQL Functions vs PL/PgSQL Josh Berkus
• 15:30   Re: Debugging postmaster to fix possible bug in Postgres? Followup to "How do you select Nicholas Allen
• 16:43   Re: SQL Functions vs PL/PgSQL Roberto Mello
• 17:27   Re: Debugging postmaster to fix possible bug in Postgres? Stephan Szabo
• 17:40   Re: Debugging postmaster to fix possible bug in Postgres? Followup to "How do you select Manfred Koizar
• 18:05   Table Pivot V. Cekvenich
• 18:05   pg_restore fails when restoring a database view piuschan
• 18:53   Re: Debugging postmaster to fix possible bug in Postgres? Followup to "How do you select Nicholas Allen
• 19:11   Re: Debugging postmaster to fix possible bug in Postgres? Followup Dmitry Tkach
• 19:54   Extending Datatype Wei Weng
• 20:53   postmaster -i & establishes three connections why? Jeff Lu
• 21:02   Re: Debugging postmaster to fix possible bug in Postgres? Followup Manfred Koizar
• 21:06   Re: Extending Datatype Bruce Momjian
• 21:48   Re: Debugging postmaster to fix possible bug in Postgres? Followup Tom Lane
• 22:06   Re: SQL Functions vs PL/PgSQL Tom Lane
• 23:04   PL/PGSQL EDITOR Eduardo
• 23:36   Returning result sets. Michael Weaver
• 23:59   Re: Returning result sets. Joe Conway

14 February 2003

• 00:59   Re: dblink question please Frankie Lam
• 01:24   Re: PL/PGSQL EDITOR Frankie Lam
• 01:50   Re: PL/PGSQL EDITOR Josh Berkus
• 01:54   Passing arrays Michael Weaver
• 02:16   Re: Passing arrays Josh Berkus
• 02:37   rownum chester c young
• 02:56   Re: rownum Josh Berkus
• 02:57   Re: Passing arrays Stephan Szabo
• 03:20   Re: rownum Tom Lane
• 03:51   Re: Extending Datatype Wei Weng
• 03:53   Re: dblink question please Joe Conway
• 05:55   Re: Passing arrays Michael Weaver
• 06:09   Re: Passing arrays Achilleus Mantzios
• 06:20   Re: Passing arrays David Durst
• 06:43   Re: PL/PGSQL EDITOR Tomasz Myrta
• 07:14   Re: Passing arrays Michael Weaver
• 07:16   Re: Passing arrays Achilleus Mantzios
• 07:48   Re: Table Pivot Christoph Haller
• 08:10   Re: rownum Richard Huxton
• 10:05   Re: Table Pivot Gary Stainburn
• 10:38   Re: Extending Datatype Bruce Momjian
• 13:34   Drop temporary table only if it exists Mintoo Lall
• 13:37   Re: Table Pivot Joe Conway
• 13:44   Re: rownum Joe Conway
• 13:50   Re: Passing arrays Joe Conway
• 14:21   Re: rownum Tom Lane
• 15:28   Timezone conversion Jeff Boes
• 15:28   Re: SQL Functions vs PL/PgSQL Johnny Kristensen
• 15:28   Re: PL/PGSQL EDITOR Tambet Matiisen
• 15:48   Re: Drop temporary table only if it exists Josh Berkus
• 16:00   Re: Timezone conversion Stephan Szabo
• 16:12   Re: Drop temporary table only if it exists Mintoo Lall
• 16:21   sub-query optimization Brad Hilton
• 16:37   Re: sub-query optimization Brad Hilton
• 16:41   Re: Drop temporary table only if it exists greg@turnstep.com
• 17:33   Re: sub-query optimization Tomasz Myrta
• 17:41   Re: sub-query optimization Brad Hilton
• 18:04   Re: sub-query optimization Stephan Szabo
• 18:04   Re: PL/PGSQL EDITOR Johannes Lochmann
• 18:42   Re: sub-query optimization Tomasz Myrta
• 19:08   Re: Timezone conversion Tom Lane
• 19:49   Re: postmaster -i & establishes three connections why? Robert Treat
• 20:08   Re: sub-query optimization Tom Lane
• 20:25   Re: sub-query optimization Brad Hilton
• 20:46   Re: sub-query optimization Brad Hilton

15 February 2003

• 02:54   Re: rownum chester c young
• 07:00   Re: sub-query optimization Tomasz Myrta

16 February 2003

• 01:53   is current_timestamp unique for a transaction? Alan Gutierrez
• 02:15   Re: is current_timestamp unique for a transaction? Bruno Wolff III
• 02:23   Re: is current_timestamp unique for a transaction? Rod Taylor
• 14:57   Re: select from update from select? Dima Tkach
• 15:12   Re: Table Pivot Vic Cekvenich
• 15:14   Re: Table Pivot Vic Cekvenich

17 February 2003

• 02:04   Re: Table Pivot Joe Conway
• 04:15   Trigger that will execute external program David Loh
• 04:27   Re: Trigger that will execute external program Tomasz Myrta
• 05:11   Re: is current_timestamp unique for a transaction? Rajesh Kumar Mallah
• 08:54   Special Date/Time Inputs Tomasz Myrta
• 10:07   Re: Special Date/Time Inputs A.Bhuvaneswaran
• 10:17   Re: Special Date/Time Inputs Tomasz Myrta
• 10:19   Re: Special Date/Time Inputs Tomasz Myrta
• 11:32    iafmgc@unileon.es
• 14:25   Re: rownum Terry Yapt
• 15:18   Re: sub-query optimization Brad Hilton
• 16:12   Re: sub-query optimization Tomasz Myrta
• 16:34   Re: sub-query optimization jasiek@serwer.skawsoft.com.pl
• 16:34   Re: PL/PGSQL EDITOR Eduardo
• 16:34   convert from an integer to a date STashlitsky@JEFCO.com
• 16:35   Fwd: Re: Table Pivot V. Cekvenich
• 16:35   Re: trigger after with cursor betty
• 16:35   trigger after with cursor betty
• 16:35   select from update from select? Dave Gomboc
• 16:35    George
• 16:35   Re: sub-query optimization jasiek@serwer.skawsoft.com.pl
• 17:52   Re: PL/PGSQL EDITOR Josh Berkus
• 18:07   Returning multiple rows from plpgsql function Mintoo Lall
• 18:18   Re: Returning multiple rows from plpgsql function Stephan Szabo
• 18:47   Format Function Yudie
• 18:58   Re: Format Function Josh Berkus
• 19:02   Re: Tomasz Myrta
• 19:46   Re: convert from an integer to a date Frank Bax
• 22:12   Re: Format Function Yudie

18 February 2003

• 06:51   Re: trigger after with cursor Christoph Haller
• 08:01   How to make sequence skip existing key in table? Raymond Pau
• 08:04   " Adding missing FROM-clause entry for table .... " problem. Rajesh Kumar Mallah
• 08:34   Re: " Adding missing FROM-clause entry for table .... " problem. Christoph Haller
• 08:44   Re: " Adding missing FROM-clause entry for table .... " problem. Tomasz Myrta
• 09:30   Re: " Adding missing FROM-clause entry for table .... " problem. Tomasz Myrta
• 09:51   Re: " Adding missing FROM-clause entry for table .... " problem. Christoph Haller
• 11:29   Re: How to make sequence skip existing key in table? Bruno Wolff III
• 11:59   Re: " Adding missing FROM-clause entry for table .... " problem. Bruno Wolff III
• 13:40   Re: " Adding missing FROM-clause entry for table .... " problem. Tom Lane
• 13:50   Re: " Adding missing FROM-clause entry for table .... " problem. Tom Lane
• 14:03   Re: " Adding missing FROM-clause entry for table .... " problem. Jeff Eckermann
• 14:06   Re: " Adding missing FROM-clause entry for table .... " problem. Stephan Szabo
• 14:07   Re: Jeff Eckermann
• 15:08   Re: How to make sequence skip existing key in table? Josh Berkus
• 15:24   select from update from select? Dave Gomboc
• 15:24   Re: Trigger that will execute external program Hans-Jürgen Schönig
• 15:24   Re: trigger after with cursor betty
• 15:24   Re: select from update from select? Tambet Matiisen
• 15:24   Re: convert from an integer to a date miquels@cistron-office.nl (Miquel van Smoorenburg)
• 15:40   Re: Drop temporary table only if it exists Jan Wieck
• 15:58   Rule Creates Duplicates retry Martin Davidsson
• 16:28   Re: Drop temporary table only if it exists Josh Berkus
• 18:21   Re: trigger after with cursor Jeff Eckermann
• 18:22   Re: Trigger that will execute external program Jan Wieck
• 18:49   Re: Drop temporary table only if it exists Jan Wieck
• 21:13   once again, sorting with Unicode JBJ
• 22:12   point <-> polygon not supported? Scott Ding

19 February 2003

• 04:30   Re: Drop temporary table only if it exists Josh Berkus
• 05:39   Re: Rule Creates Duplicates retry Tom Lane
• 09:16   Re: once again, sorting with Unicode Troy
• 10:37   Re: once again, sorting with Unicode Antti Haapala
• 10:49   Re: select from update from select? Richard Huxton
• 10:59   VIEW or Stored Proc - Is this even possible? Stephen.Thompson@bmwfin.com
• 11:04   Re: " Adding missing FROM-clause entry for table .... " problem. Christoph Haller
• 12:27   Default column titles in a select... Axel Schlueter
• 13:07   Re: Default column titles in a select... greg@turnstep.com
• 13:09   Re: Default column titles in a select... Bruno Wolff III
• 13:10   Re: Default column titles in a select... Christoph Haller
• 13:22   Re: once again, sorting with Unicode Tom Lane
• 16:12   Re: VIEW or Stored Proc - Is this even possible? Richard Huxton
• 17:07   Re: Passing arrays Guy Fraser
• 17:52   simple join problem Matthew Nuzum
• 18:22   Re: simple join problem Richard Huxton
• 18:38   Re: once again, sorting with Unicode Troy
• 18:39   Re: simple join problem Stephan Szabo
• 18:42   Re: Passing arrays Guy Fraser
• 18:51   Re: PL/PGSQL EDITOR Guy Fraser
• 19:07   Re: simple join problem Josh Berkus
• 19:12   Re: once again, sorting with Unicode JBJ
• 20:05   Re: simple join problem Matthew Nuzum
• 21:34   Re: PL/PGSQL EDITOR Josh Berkus
• 22:04   Date-range LEFT OUTER JOIN not using an index Michael Nachbaur

20 February 2003

• 02:06   Re: simple join problem 
• 02:48   Re: simple join problem Matthew Nuzum
• 03:58   problem on truncate for v.7.3.2 jack
• 04:16   Re: problem on truncate for v.7.3.2 Josh Berkus
• 04:21   EXCEPT Queries Mark Mitchell
• 04:46   Re: EXCEPT Queries Josh Berkus
• 06:29   Re: EXCEPT Queries Peter Childs
• 08:18   Re: VIEW or Stored Proc - Is this even possible? Stephen.Thompson@bmwfin.com
• 08:53   Re: once again, sorting with Unicode Troy
• 08:55   Re: once again, sorting with Unicode Troy
• 09:08   Re: VIEW or Stored Proc - Is this even possible? Richard Huxton
• 11:47   Re: VIEW or Stored Proc - Is this even possible? Stephen.Thompson@bmwfin.com
• 13:14   Re: problem on truncate for v.7.3.2 Tom Lane
• 13:29   Re: point <-> polygon not supported? Tomasz Myrta
• 14:52   Re: point <-> polygon not supported? Scott Ding
• 15:08   Re: point <-> polygon not supported? Tomasz Myrta
• 16:48   Re: point <-> polygon not supported? Scott Ding
• 17:29   Re: PL/PGSQL EDITOR Josh Berkus
• 18:10   How to drop all the sequences Arunachalam Jaisankar
• 18:10   pg_func problem Graham Vickrage
• 18:10   Re: once again, sorting with Unicode Troy
• 18:10   Re: select from update from select? Dave Gomboc
• 18:55   Re: How to drop all the sequences Tomasz Myrta
• 21:58   Nth Select Mark Mitchell
• 23:36   Re: EXCEPT Queries Jeff Boes

21 February 2003

• 01:40   Fw: 向华东
• 01:41   Fw: 向华东
• 04:30   Re: How to make sequence skip existing key in table? Raymond Pau
• 06:04   Re: How to drop all the sequences Oleg Samoylov
• 06:37   Re: Fw: Tomasz Myrta
• 11:12   Re: " Adding missing FROM-clause entry for table .... " problem. Rajesh Kumar Mallah
• 11:29   good style? Rafal Kedziorski
• 11:52   Re: good style? Rajesh Kumar Mallah
• 11:55   function defination help .. Rajesh Kumar Mallah
• 11:55   Re: good style? Alan Gutierrez
• 13:05   Re: good style? Tambet Matiisen
• 14:06   Re: good style? Rafal Kedziorski
• 16:04   7.3 "group by" issue Dan Langille
• 16:23   Re: 7.3 "group by" issue Gaetano Mendola
• 16:27   Re: 7.3 "group by" issue Dan Langille
• 18:18   Re: 7.3 "group by" issue Chad Thompson
• 18:19   Re: Fw: Daniel Schuchardt
• 18:20   How do I view triggers Graham Vickrage
• 18:44   Re: 7.3 "group by" issue Dan Langille
• 19:05   Re: 7.3 "group by" issue Chad Thompson
• 19:23   Re: 7.3 "group by" issue Dan Langille
• 19:32   Re: 7.3 "group by" issue Chad Thompson
• 19:37   Re: How do I view triggers Chad Thompson
• 21:01   join gone awry Matthew Nuzum
• 21:33   Re: 7.3 "group by" issue Josh Berkus
• 22:26   Re: 7.3 "group by" issue Dan Langille

22 February 2003

• 00:03   Re: function defination help .. Peter Eisentraut
• 00:04   Re: 7.3 "group by" issue Peter Eisentraut
• 04:25   Re: [BUGS] 7.3 GROUP BY differs from 7.2 Tom Lane
• 06:25   Re: function defination help .. Rajesh Kumar Mallah
• 07:13   Re: [BUGS] 7.3 GROUP BY differs from 7.2 Stephan Szabo
• 07:14   Re: [BUGS] 7.3 GROUP BY differs from 7.2 Tom Lane
• 15:43   Re: [BUGS] 7.3 GROUP BY differs from 7.2 Stephan Szabo
• 17:45   Re: 7.3 "group by" issue Josh Berkus
• 22:59   sql question after upgrade James Cooper
• 23:42   Re: sql question after upgrade Neil Conway

23 February 2003

• 00:14   Re: 7.3 "group by" issue Peter Eisentraut
• 00:14   Re: sql question after upgrade Peter Eisentraut
• 08:50   how to return ONE single record from a function in plpgsql? Hubert depesz Lubaczewski
• 09:34   Porting from db2 problem Wayne Armstrong
• 14:49   Re: how to return ONE single record from a function in plpgsql? Tom Lane
• 17:12   Help with query involving aggregation and joining. Eddie Cheung
• 18:03   Re: 7.3 "group by" issue Josh Berkus
• 18:22   Re: [BUGS] 7.3 GROUP BY differs from 7.2 Josh Berkus
• 18:28   Re: Help with query involving aggregation and joining. Josh Berkus
• 18:37   Re: Help with query involving aggregation and joining. Bruno Wolff III
• 20:18   SQL Statements question, why I get errors... 
• 20:18   syntax question James Cooper
• 20:54   Re: syntax question Josh Berkus
• 21:00   Re: SQL Statements question, why I get errors... Josh Berkus
• 21:09   Re: syntax question Josh Berkus
• 21:15   Re: SQL Statements question, why I get errors... 
• 21:53   Re: good style? Rafal Kedziorski
• 22:28   Re: syntax question Josh Berkus

24 February 2003

• 01:14   Re: SQL Statements question, why I get errors... Bruno Wolff III
• 03:17   Re: Help with query involving aggregation and joining. Eddie Cheung
• 03:19   Re: Help with query involving aggregation and joining. Eddie Cheung
• 05:55   Re: Help with query involving aggregation and joining. Josh Berkus
• 07:33   Re: Porting from db2 problem Christoph Haller
• 11:24   Re: Help with query involving aggregation and joining. Rajesh Kumar Mallah
• 11:49   Re: Help with query involving aggregation and joining. Christoph Haller
• 13:19   Re: syntax question Jeff Eckermann
• 13:33   Re: syntax question Tom Lane
• 13:50   Re: Help with query involving aggregation and joining. 
• 15:26   Re: Help with query involving aggregation and joining. Bruno Wolff III
• 16:49   Re: syntax question Josh Berkus
• 18:11   Re: Denormalizing during select Jeff Boes
• 21:31   indexing James Cooper
• 23:22   Re: Denormalizing during select Josh Berkus
• 23:33   indexing James Cooper

25 February 2003

• 00:57   Problem with deferred referential integrity checks Bob Smith
• 02:39   Re: indexing Josh Berkus
• 07:43   Sub Select inside Check ? Rudi Starcevic
• 08:13   Re: Problem with deferred referential integrity checks Stephan Szabo
• 08:49   Re: good style? Rafal Kedziorski
• 08:55   Re: Help with query involving aggregation and joining. Eddie Cheung
• 10:42   Re: Sub Select inside Check ? Tomasz Myrta
• 12:19   STORAGE and GiST Itai Zukerman
• 12:54   how can i drop a constraint rute solipa
• 13:08   Re: how can i drop a constraint Christoph Haller
• 13:15   Polymorphic? Itai Zukerman
• 13:34   Re: how can i drop a constraint Christoph Haller
• 13:44   Re: STORAGE and GiST Tom Lane
• 14:04   Relation "pg_relcheck" Victor Yegorov
• 14:05   Re: Sub Select inside Check ? Stephan Szabo
• 14:21   Re: Relation "pg_relcheck" Victor Yegorov
• 14:24   Re: Relation "pg_relcheck" Stephan Szabo
• 14:32   Re: Polymorphic? Tom Lane
• 14:34   Re: Relation "pg_relcheck" Ian Barwick
• 14:41   Re: Relation "pg_relcheck" Tom Lane
• 14:49   Re: Relation "pg_relcheck" Rod Taylor
• 16:41   Re: Denormalizing during select Josh Berkus
• 17:20   Return type of triger functions from OPAQUE to TRIGGER in 7.3 Roberto Mello
• 17:34   Re: Return type of triger functions from OPAQUE to TRIGGER in 7.3 Josh Berkus
• 19:21   Re: Return type of triger functions from OPAQUE to TRIGGER in 7.3 Tom Lane
• 20:32   a change of query James Cooper
• 21:04   Re: a change of query Brad Hilton
• 21:07   Re: a change of query Rod Taylor
• 21:07   Re: a change of query Chad Thompson
• 21:32   Re: Help with query involving aggregation and joining. Josh Berkus
• 23:05   Postgres locking Bob Smith
• 23:36   Followup Re: Postgres locking Bob Smith

26 February 2003

• 01:09   performance James Cooper
• 01:29   OffsetNumber, picksplit, and GiST Itai Zukerman
• 01:42   Re: Polymorphic? Itai Zukerman
• 02:45   Re: Return type of triger functions from OPAQUE to TRIGGER in 7.3 Roberto Mello
• 02:48   Re: Return type of triger functions from OPAQUE to TRIGGER in 7.3 Roberto Mello
• 07:09   Copy from a SELECT val@webtribe.net
• 11:18   WebDB, iAS gyurika
• 11:22   Re: WebDB, iAS Victor Yegorov
• 11:39   Re: WebDB, iAS D'Arcy J.M. Cain
• 12:37   disable constraints rute solipa
• 12:48   Re: disable constraints Patrik Kudo
• 13:35   Design Q.:logic in app or db? george young
• 13:57   Re: Design Q.:logic in app or db? Achilleus Mantzios
• 13:59   Re: OffsetNumber, picksplit, and GiST Itai Zukerman
• 15:05   Re: disable constraints rute solipa
• 15:14   Re: Return type of triger functions from OPAQUE to TRIGGER in 7.3 Josh Berkus
• 16:38   Re: Design Q.:logic in app or db? Josh Berkus
• 17:05   btree_gist, gint4_union Itai Zukerman
• 18:40   Re: Relation "pg_relcheck" Tilo Schwarz
• 19:10   Re: Relation "pg_relcheck" Tom Lane
• 20:47   pgsql problem Grignon Etienne
• 23:17   timestamp output as seconds since epoch? A.M.

27 February 2003

• 00:09   Re: timestamp output as seconds since epoch? Rod Taylor
• 08:16   Re: how can i drop a constraint Christoph Haller
• 10:44   Re: Copy from a SELECT Christoph Haller
• 12:45   Re: pgsql problem Christoph Haller
• 16:59   Re: Copy from a SELECT Valerie Goodman
• 17:29   Analyse article Dan Langille
• 18:10   GiST, Not Using Index Itai Zukerman
• 18:25   Re: Analyse article Dan Langille
• 18:58   Re: pgsql problem Grignon Etienne
• 19:40   Re: GiST, Not Using Index Tom Lane
• 20:04   Re: GiST, Not Using Index Itai Zukerman
• 22:23   Re: pgsql problem Stephan Szabo
• 23:07   Re: GiST, Not Using Index Itai Zukerman
• 23:12   Re: GiST, Not Using Index Tom Lane

28 February 2003

• 00:24   Are scalar type's in/out functions implicitly STRICT? Denis Zaitsev
• 01:32   Re: Are scalar type's in/out functions implicitly STRICT? Tom Lane
• 01:44   Re: Are scalar type's in/out functions implicitly STRICT? Bruno Wolff III
• 02:01   calling a stored procedure via pqSendQuery victor@inf.ufsc.br
• 02:49   PSQL segmentation fault? Frankie Lam
• 09:49   Re: pgsql problem Victor Yegorov
• 11:22   Re: Copy from a SELECT Christoph Haller
• 11:23   Re: pgsql problem Christoph Haller
• 12:36   Re: Copy from a SELECT val@webtribe.net
• 16:23   Query Against a dblink View Takes Too Long to Return Dawn Hollingsworth
• 16:30   DELETE FROM t WHERE EXISTS Dan Langille
• 16:49   Re: WebDB, iAS Guy Fraser
• 18:27   Re: DELETE FROM t WHERE EXISTS Jakub Ouhrabka
• 19:09   Re: DELETE FROM t WHERE EXISTS Jeff Eckermann
• 19:42   Re: DELETE FROM t WHERE EXISTS Tom Lane
• 19:57   Re: DELETE FROM t WHERE EXISTS Stephan Szabo
• 19:58   Re: DELETE FROM t WHERE EXISTS Tomasz Myrta
• 20:00   Re: DELETE FROM t WHERE EXISTS Robert Treat
• 20:15   Re: disable constraints Dmitry Tkach
• 20:19   Re: DELETE FROM t WHERE EXISTS Dmitry Tkach
• 21:47   Re: DELETE FROM t WHERE EXISTS Dan Langille
• 21:50   Re: DELETE FROM t WHERE EXISTS Dan Langille
• 21:51   Re: DELETE FROM t WHERE EXISTS Dan Langille
• 23:01   Optimizing Montrone, Marc -- 7183
• 23:01   Optimizing Montrone, Marc -- 7183
• 23:17   Beginner needs help Aaron Chu
• 23:17   Executing SQL commands via triggers without the use of procedures Susan Hoddinott
• 23:17   Beginner needs help Aaron Chu
• 23:19   how to return ONE single record from a function in plpgsql? Hubert depesz Lubaczewski
• 23:20   Re: inserting multiple rows with one statement codeWarrior
• 23:21   SORT with accents Edipo E. F. Melo
• 23:21   Users and groups Teddy
• 23:23   Re: Optimizing Dan Langille
• 23:23   Re: Optimizing Steve Crawford
• 23:27   use of geometric types in select ? dhoubrechts