Mailing lists [pgsql-sql]

1 July 2002

• 08:15   Re: graphical interface - admin Andreas Joseph Krogh
• 10:33   Re: graphical interface - admin Oleg Bartunov
• 11:21   Re: graphical interface - admin Andreas Joseph Krogh
• 12:04   Re: graphical interface - admin Oleg Bartunov
• 12:11   Re: graphical interface - admin Andreas Joseph Krogh
• 13:38   Re: graphical interface - admin Roberto Mello
• 13:42   Re: pl/pgsql capabilities? Roberto Mello
• 15:26   Using union to avoid creating temp table Bruno Wolff III
• 15:33   unsubscribe Simeone, Mario
• 16:18   Re: Using union to avoid creating temp table Tom Lane
• 17:12   Re: pg_restore cannot restore function Jan Wieck
• 22:37   Re: pl/pgsql capabilities? Ferenc Engard

2 July 2002

• 04:25   Re: pl/pgsql capabilities? Roberto Mello
• 11:02   CASE Select, referring to selected value Nick Riemondi
• 13:01   Re: CASE Select, referring to selected value Achilleus Mantzios
• 13:01   Temporary table instead of repeated joins Chantal Ackermann
• 13:32   Re: CASE Select, referring to selected value Christopher Kings-Lynne

3 July 2002

• 04:01   Re: pg_restore cannot restore function Jie Liang
• 04:43   Re: CASE Select, referring to selected value Nick Riemondi
• 04:58   constraint Ricardo Javier Aranibar León
• 04:58   Why doesn't it use indexes? Ahti Legonkov
• 07:31   Re: constraint Christopher Kings-Lynne
• 07:43   Re: Why doesn't it use indexes? Christopher Kings-Lynne
• 07:45   Re: pg_restore cannot restore function Achilleus Mantzios
• 07:46   Re: Why doesn't it use indexes? Achilleus Mantzios
• 14:15   Localization GRIMOIS Eric
• 14:54   Re: pg_restore cannot restore function Jie Liang
• 16:41   Re: Localization Bruce Momjian
• 16:43   Selecting data from a table created in another database... Ligia Pimentel
• 18:02   How do I access the current row from a trigger? Magnus Sjöstrand
• 20:13   Re: pg_restore cannot restore function Jie Liang
• 22:35   Re: Possible Bug regarding temp tables (sql or psql?) Mark Frazer
• 22:44   Re: Selecting data from a table created in another database... Bruce Momjian
• 23:04   Possible Bug regarding temp tables (sql or psql?) Mark Frazer
• 23:52   Re: How do I access the current row from a trigger? Stephan Szabo
• 23:59   bit field changes in 7.2.1 Kevin Brannen

4 July 2002

• 00:14   postgres7.2.1 upgrading Jie Liang
• 02:16   Re: Possible Bug regarding temp tables (sql or psql?) Christopher Kings-Lynne
• 02:34   Re: Selecting data from a table created in another database... Rudi Starcevic
• 03:06   Re: postgres7.2.1 upgrading Christopher Kings-Lynne
• 10:24   Re: Possible Bug regarding temp tables (sql or psql?) Mark Frazer
• 11:03   how to write procedures srikanth
• 11:03   Can this be done with sql? teknokrat@yahoo.com (teknokrat)
• 12:07   Re: Possible Bug regarding temp tables (sql or psql?) Bruce Momjian
• 12:47   Re: how to write procedures Achilleus Mantzios
• 14:11   Re: how to write procedures Rajesh Kumar Mallah.
• 14:11   Re: Can this be done with sql? Rajesh Kumar Mallah.
• 15:17   Re: how to write procedures Achilleus Mantzios
• 16:41   Boolean to int Stephane Schildknecht
• 17:50   Re: Boolean to int Stephan Szabo

5 July 2002

• 01:01   Re: Possible Bug regarding temp tables (sql or psql?) Christopher Kings-Lynne
• 01:13   Re: Possible Bug regarding temp tables (sql or psql?) Bruce Momjian
• 01:40   Re: Possible Bug regarding temp tables (sql or psql?) Tom Lane
• 01:40   Re: Possible Bug regarding temp tables (sql or psql?) Bruce Momjian
• 08:03   sql statement how to do ? juerg.rietmann@pup.ch
• 10:56   Is Dropping a column "CHECK" constraint possible? Rajesh Kumar Mallah.
• 11:02   how to use nextval() juerg.rietmann@pup.ch
• 11:06   Re: Selecting data from a table created in another database... Chantal Ackermann
• 11:28   Re: how to use nextval() Stephane Schildknecht
• 11:41   Re: how to use nextval() Achilleus Mantzios
• 11:45   Re: sql statement how to do ? Manfred Koizar
• 11:46   Re: Can this be done with sql? teknokrat@yahoo.com (teknokrat)
• 11:46   Re: Boolean to int Arjen van der Meijden
• 11:46   Re: Selecting data from a table created in another database... Ligia Pimentel
• 11:46   How do i return a dataset from a stored procedure teknokrat@yahoo.com (teknokrat)
• 11:46   algoritme dubreuil@ufr-info-p7.jussieu.fr (stephane)
• 13:51   Re: Possible Bug regarding temp tables (sql or psql?) Mark Frazer
• 13:58   Re: Boolean to int Stephane Schildknecht
• 16:58   Re: How do i return a dataset from a stored procedure Stephan Szabo
• 17:27   Re: How do i return a dataset from a stored procedure Roberto Mello
• 19:17   i18n in pgSQL Vernon Wu
• 20:17   Re: Possible Bug regarding temp tables (sql or psql?) Bruce Momjian

6 July 2002

• 01:18   Re: How do i return a dataset from a stored procedure Bruce Momjian
• 03:40   Re: Is Dropping a column "CHECK" constraint possible? Christopher Kings-Lynne
• 04:00   Re: Is Dropping a column "CHECK" constraint possible? Rajesh Kumar Mallah.

7 July 2002

• 09:59   Re: Localization Peter Eisentraut
• 09:59   Re: bit field changes in 7.2.1 Peter Eisentraut
• 12:32   Re: Can this be done with sql? Rajesh Kumar Mallah.
• 12:41   Re: Is Dropping a column "CHECK" constraint possible? Rajesh Kumar Mallah.
• 19:25   Bad SUM result Roy Souther
• 19:45   Re: Bad SUM result Stephan Szabo

8 July 2002

• 00:20   INSERT only under certain conditions (SELECT) Joachim Trinkwitz
• 08:23    jack
• 09:39   Double quotes? Archibald Zimonyi
• 09:54   Re: Double quotes? Christoph Haller
• 09:58   Re: Double quotes? Archibald Zimonyi
• 11:18   Re: INSERT only under certain conditions (SELECT) Rajesh Kumar Mallah.
• 11:36   Re: INSERT only under certain conditions (SELECT) Bruno Wolff III
• 12:20   Problem on PostgreSQL (error code, store procedures) Carmen Wai
• 12:20   Re: Boolean to int Arjen van der Meijden|Moderator P&W / Serverbeheer
• 12:20   newbie question Mirco D'Angelo
• 12:21   manipulating the database in plsql teknokrat@yahoo.com (teknokrat)
• 17:09   Re: newbie question Roberto Mello
• 17:10   Re: bit field changes in 7.2.1 Kevin Brannen
• 17:15   Re: Bad SUM result Jean-Luc Lachance
• 18:13   Re: INSERT only under certain conditions (SELECT) Joachim Trinkwitz
• 20:12   Re: manipulating the database in plsql Roberto Mello
• 21:34   Re: newbie question Richard Huxton
• 22:24   Re: newbie question Ignacio Coloma

9 July 2002

• 00:22   Re: manipulating the database in plsql Janning Vygen
• 00:58   Rule WHERE condition problem Kristian Eide
• 02:31   Re: Bruce Momjian
• 05:42   Re: how to write procedures Bhuvan A
• 08:47   export plpgsql function to file Joseph Syjuco
• 09:43   SQL problem with aggregate functions. David BOURIAUD
• 11:02   Re: newbie question Christopher Kings-Lynne
• 12:24   Re: newbie question Achilleus Mantzios
• 13:12   Variables in PSQL Roger Mathis
• 13:13   Re: Rule WHERE condition problem Tom Lane
• 13:27   PLPGSQL language documentation Sandy Ear
• 13:27   Re: Rule WHERE condition problem Kristian Eide
• 13:28   is there a way to get hh:mm:ss given seconds Narendra A
• 13:55   Re: Rule WHERE condition problem Jan Wieck
• 14:42   Re: INSERT only under certain conditions (SELECT) Bruno Wolff III
• 15:04   Re: is there a way to get hh:mm:ss given seconds David Stanaway
• 15:06   Re: is there a way to get hh:mm:ss given seconds Tod McQuillin
• 16:08   Re: PLPGSQL language documentation Josh Berkus
• 16:11   Re: PLPGSQL language documentation Bradley Kieser
• 16:44   Re: export plpgsql function to file Achilleus Mantzios
• 16:50   Waiting for Update JGM
• 18:02   Re: PLPGSQL language documentation Jeff Eckermann
• 18:11   Re: is there a way to get hh:mm:ss given seconds Kevin Brannen
• 18:45   pg_restore cannot restore index Jie Liang
• 20:01   Re: pg_restore cannot restore index Jie Liang

10 July 2002

• 01:59   Re: pg_restore cannot restore index Bruce Momjian
• 04:46   Re: is there a way to get hh:mm:ss given seconds Josh Berkus
• 04:49   Re: is there a way to get hh:mm:ss given seconds Christopher Kings-Lynne
• 07:28   query/transaction history/logs q
• 08:02   Re: query/transaction history/logs David BOURIAUD
• 08:41   Help with function optimisation Ian Cass
• 09:47   Re: Problem on PostgreSQL (error code, store procedures) Christoph Haller
• 10:00   Re: Variables in PSQL Christoph Haller
• 11:02   Error with DISTINCT and AS keywords Andreas Schlegel
• 11:25   Re: Bad SUM result Petr Jezek
• 11:25   How to get total number of rows when using LIMIT/OFFSET? Dirk Lutzebaeck
• 11:26   Re: Error with DISTINCT and AS keywords Achilleus Mantzios
• 12:34   Re: Help with function optimisation Tom Lane
• 12:45   Re: Error with DISTINCT and AS keywords Richard Huxton
• 13:09   Re: Error with DISTINCT and AS keywords Tom Lane
• 14:17   Re: Error with DISTINCT and AS keywords Jean-Luc Lachance
• 14:27   Re: Waiting for Update Jan Wieck
• 14:42   Re: pg_restore cannot restore index Jie Liang
• 18:32   BETWEEN bug? Josh Berkus
• 18:46   Insert Function David Durst
• 19:10   Re: BETWEEN bug? Stephan Szabo
• 19:44   Re: Insert Function Ian Barwick
• 20:54   Re: BETWEEN bug? Josh Berkus
• 23:24   Returning rows from functions David Durst

11 July 2002

• 00:51   Re: How to get total number of rows when using LIMIT/OFFSET? Bruce Momjian
• 01:06   Re: pg_restore cannot restore index Bruce Momjian
• 02:18   Re: BETWEEN bug? Josh Berkus
• 03:59   Re: Returning rows from functions Joe Conway
• 05:37   Re: Insert Function Ian Barwick
• 07:37   Re: SQL problem with aggregate functions. Christoph Haller
• 11:08   XML to Postgres conversion nghill@yahoo.com (Nathan Hill)
• 13:02   list of tables ? Steve Brett
• 13:12   Re: list of tables ? Achilleus Mantzios
• 13:12   Re: list of tables ? -update to question ... Steve Brett
• 13:12   Re: list of tables ? Ian Barwick
• 13:15   Re: list of tables ? Steve Brett
• 13:24   Re: XML to Postgres conversion 
• 13:43   how to inherits the references... frederik nietzsche
• 14:05   Re: XML to Postgres conversion Rudi Starcevic
• 14:40   Re: pg_restore cannot restore index Jie Liang
• 15:00   Re: how to inherits the references... Stephan Szabo
• 15:48   Re: [HACKERS] please help on query Manfred Koizar
• 17:39   Re: list of tables ? -update to question ... Jan Wieck
• 17:47   Re: [HACKERS] please help on query Manfred Koizar
• 18:48   Re: pg_restore cannot restore index Jie Liang
• 21:08   Re: SQL problem with aggregate functions. Loyd Goodbar
• 21:55   Please, HELP! Why is the query plan so wrong??? Dmitry Tkach
• 22:24   PostgreSQL - contrib/xml Rudi Starcevic
• 22:26   Re: Please, HELP! Why is the query plan so wrong??? Jie Liang

12 July 2002

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

13 July 2002

• 01:07   Re: XML to Postgres conversion Marc Spitzer
• 01:13   Re: Query kill Bruce Momjian
• 02:55   Re: Query kill Jan Wieck
• 03:27   Re: Query kill Bruce Momjian
• 08:53   Indexes with LIKE Julian Scarfe
• 13:51   Re: pg_restore cannot restore index Bruce Momjian
• 14:28   Re: Indexes with LIKE Stephan Szabo
• 18:28   Re: [BUGS] It is a bug in pred_test()! (Was: Please, HELP! Why is the query plan so wrong???) Tom Lane

14 July 2002

• 11:22   Re: [HACKERS] please help on query Masaru Sugawara
• 18:46   Re: Indexes with LIKE Stephan Szabo

15 July 2002

• 02:15   Quick Question Christopher Kings-Lynne
• 02:17   Sorry.. Christopher Kings-Lynne
• 02:27   Re: Sorry.. Tom Lane
• 02:32   Fwd: line datatype Tim Hart
• 06:40   Re: [HACKERS] please help on query Luis Alberto Amigo Navarro
• 11:37   line datatype Tim Hart
• 11:37   Re: sql question: Ahti Legonkov
• 11:37   sql question: Chris Aiello
• 11:37   Re: Indexes with LIKE Julian Scarfe
• 13:43   Re: line datatype Bruce Momjian
• 13:46   Re: pg_restore cannot restore index Jie Liang
• 15:14   Re: [HACKERS] please help on query Masaru Sugawara
• 16:48    Wallingford, Ted
• 16:52   Re: Bruce Momjian
• 17:46   Seeding Chad Thompson
• 17:56   Indexing UNIONs Josh Berkus
• 19:12   Re: Indexing UNIONs Stephan Szabo
• 19:57   Re: Sorry.. Josh Berkus
• 21:23   Re: pg_restore cannot restore index Bruce Momjian
• 21:52   Re: Seeding Peter Eisentraut
• 22:22   Re: pg_restore cannot restore index Jie Liang
• 22:24   Re: pg_restore cannot restore index Bruce Momjian
• 22:24   how pg_restore long form works? Jie Liang
• 22:39   pg_restore --flag Jie Liang
• 23:27   Re: Indexing UNIONs Josh Berkus
• 23:42   Re: Indexing UNIONs Stephan Szabo

16 July 2002

• 02:33   Re: line datatype Bruce Momjian
• 07:11   How do I concatenate row-wise instead of column-wise? Marcus Claesson
• 07:46   Re: [HACKERS] please help on query Luis Alberto Amigo Navarro
• 08:30   Re: How do I concatenate row-wise instead of column-wise? Richard Huxton
• 10:21   Cascading deletions does not seem to work inside PL/PGSQL functions. Rajesh Kumar Mallah.
• 10:31   Re: How do I concatenate row-wise instead of column-wise? Rajesh Kumar Mallah.
• 10:40   Re: Indexing UNIONs Bruno Wolff III
• 15:11   Re: Cascading deletions does not seem to work inside PL/PGSQL Stephan Szabo
• 15:36   Re: Indexing UNIONs Josh Berkus
• 16:18   A SQL Training Devrim GUNDUZ
• 16:37   datatype matrix (was: Re: Sorry..) Kevin Brannen
• 17:03   Re: A SQL Training Josh Berkus
• 17:37   Need help on a troublesome query plan Alain Lavigne
• 17:52   Re: Need help on a troublesome query plan Stephan Szabo
• 18:14   Re: Indexing UNIONs Bruno Wolff III
• 19:31   Re: Need help on a troublesome query plan Stephan Szabo
• 21:30   Re: datatype matrix (was: Re: Sorry..) Josh Berkus
• 21:38   Re: Indexing UNIONs Josh Berkus

17 July 2002

• 00:19   Newbie: Creative use of LIMIT?? Shmuel A. Kahn
• 01:35   Sequence name length Rudi Starcevic
• 01:49   Re: Sequence name length Christopher Kings-Lynne
• 02:41   Re: Sequence name length Tom Lane
• 02:44   Re: Sequence name length Christopher Kings-Lynne
• 02:48   Re: Sequence name length Rudi Starcevic
• 06:00   Re: A SQL Training Achilleus Mantzios
• 06:09   Re: Cascading deletions does not seem to work inside PL/PGSQL functions. Rajesh Kumar Mallah.
• 06:20   Large objects and Meta Data Dror Matalon
• 07:27   Re: datatype matrix (was: Re: Sorry..) Karel Zak
• 08:30   Re: Indexing UNIONs Richard Huxton
• 09:06   How to find out if an index is unique? Dirk Lutzebaeck
• 09:12   why is postgres estimating so badly? Luis Alberto Amigo Navarro
• 09:15   Re: How to find out if an index is unique? Achilleus Mantzios
• 10:58   Re: Need help on a troublesome query plan Alain Lavigne
• 11:01   Re: Indexing UNIONs Bruno Wolff III
• 12:27   Re: [HACKERS] please help on query Masaru Sugawara
• 14:07   Re: How to find out if an index is unique? Rajesh Kumar Mallah.
• 16:09   Re: Cascading deletions does not seem to work inside PL/PGSQL Stephan Szabo
• 16:43   Re: [HACKERS] why is postgres estimating so badly? Tom Lane
• 23:19   Re: Indexing UNIONs Josh Berkus

18 July 2002

• 01:23   Re: Indexing UNIONs Bruno Wolff III
• 04:39   Re: Cascading deletions does not seem to work inside PL/PGSQL functions. Rajesh Kumar Mallah." (by way of Rajesh Kumar Mallah.
• 05:36   Re: Cascading deletions does not seem to work inside PL/PGSQL functions. Rajesh Kumar Mallah.
• 07:14   Re: [HACKERS] why is postgres estimating so badly? Luis Alberto Amigo Navarro
• 08:39   how do i import my sql query result to a file Joseph Syjuco
• 08:41   Re: how do i import my sql query result to a file Steve Brett
• 09:00   Re: Newbie: Creative use of LIMIT?? Richard Huxton
• 09:32   about Inheritance... frederik nietzsche
• 11:03   Re: [HACKERS] why is postgres estimating so badly? Nathan C. Burnett
• 11:03   hints or suggestion for optimizer 
• 11:03   Re: How to find out if an index is unique? Ligia Pimentel
• 13:22   Re: How to find out if an index is unique? Christoph Haller
• 15:43   Re: how do i import my sql query result to a file Robert Treat
• 16:30   Re: Indexing UNIONs Josh Berkus
• 23:34   Re: how do i import my sql query result to a file Ludwig Lim

19 July 2002

• 04:07   Re: how do i import my sql query result to a file Joseph Syjuco
• 05:44   id and ID in CREATE TABLE stefan@extum.com
• 05:55   Re: id and ID in CREATE TABLE Christopher Kings-Lynne
• 06:08   Re: id and ID in CREATE TABLE stefan@extum.com
• 07:45   Re: id and ID in CREATE TABLE Josh Jore
• 10:03   Re: [GENERAL] id and ID in CREATE TABLE stefan@extum.com
• 11:17   Regarding replication Charitha
• 11:17   Re: [GENERAL] id and ID in CREATE TABLE Martijn van Oosterhout
• 12:31   Re: [GENERAL] id and ID in CREATE TABLE Tom Lane
• 14:18   Re: Regarding replication Josh Berkus
• 14:26   Adventures in PostgreSQL Josh Berkus
• 14:36   Re: id and ID in CREATE TABLE Bruce Momjian
• 14:40   Re: [GENERAL] id and ID in CREATE TABLE Thomas Swan
• 15:34   Two Index Questions Josh Berkus
• 15:44   Re: Two Index Questions Tom Lane
• 15:54   Re: Two Index Questions Bruno Wolff III
• 16:28   Re: Two Index Questions Josh Berkus
• 16:30   Re: [GENERAL] id and ID in CREATE TABLE Bruce Momjian
• 16:34   Re: [GENERAL] id and ID in CREATE TABLE Tom Lane
• 16:51   Re: Two Index Questions Bruno Wolff III
• 16:54   Re: Two Index Questions Tom Lane
• 17:12   Re: Two Index Questions Josh Berkus
• 17:28   Re: Two Index Questions Bruce Momjian
• 17:35   Re: Two Index Questions Tom Lane
• 17:39   Is it possible to use a field from another table as part of a query? Patrick Hatcher
• 17:54   Re: Is it possible to use a field from another table as part of a query? Josh Berkus
• 17:58   Re: Two Index Questions Josh Berkus
• 18:28   Re: Is it possible to use a field from another table as part of a Patrick Hatcher
• 18:33   Re: [GENERAL] id and ID in CREATE TABLE stefan@extum.com
• 18:48   Re: [GENERAL] id and ID in CREATE TABLE Stephan Szabo
• 19:16   Re: [GENERAL] id and ID in CREATE TABLE Tom Lane

21 July 2002

• 23:03   Float / Numeric ? Rudi Starcevic

22 July 2002

• 00:16   "no wait" option for locks Daniel Stüwe
• 02:26   Re: 'no wait' option for locks 
• 07:26   Re: SQL problem with aggregate functions. Hubert depesz Lubaczewski
• 11:30   Re: [GENERAL] id and ID in CREATE TABLE scott.marlowe
• 11:30   Re: [GENERAL] id and ID in CREATE TABLE scott.marlowe
• 11:30   7.3 features and enhancements mark carew
• 11:30   "no wait" in locks Daniel Stüwe
• 11:30   "no wait" in locks Daniel Stüwe
• 11:30   Re: [GENERAL] id and ID in CREATE TABLE scott.marlowe
• 11:36   Editor for pgsql Elielson Fontanezi
• 12:47   Re: 7.3 features and enhancements Bruno Wolff III
• 13:57   FATAL 1 Ian Cass
• 14:26   [NOVICE] SET CONSTRAINTS question... Michael Paesold
• 14:40   Re: [NOVICE] SET CONSTRAINTS question... Stephan Szabo
• 15:27   Re: Editor for pgsql Josh Berkus
• 15:43   Free 4GL Compiler, Informix-Postgress support ecitizen@hotmail.com (Ecitizen)
• 15:58   interval syntax change from 7.1.2 to 7.2.1? Jinn Koriech
• 16:13   Re: Float / Numeric ? Jan Wieck
• 16:35   Re: interval syntax change from 7.1.2 to 7.2.1? Gaetano Mendola
• 17:11   interval syntax change from 7.1.2 to 7.2.1? Jinn Koriech
• 19:08   Re: Editor for pgsql James Orr
• 19:53   Re: Editor for pgsql Josh Berkus
• 22:15   Re: Editor for pgsql Marc Spitzer
• 22:32   Re: Editor for pgsql Roberto Mello
• 23:41   Re: Editor for pgsql Josh Berkus

23 July 2002

• 04:45   Re: Editor for pgsql Roberto Mello
• 07:26   pg_dump and sequences Achilleus Mantzios
• 07:32   Re: pg_dump and sequences Achilleus Mantzios
• 11:26   Queries not using Index Daryl Herzmann
• 11:26   Queries not using Index Daryl Herzmann
• 11:54   Re: Queries not using Index Gaetano Mendola
• 12:11   Scan SQL Sandro Joel Eller
• 13:13   Re: Editor for pgsql Andreas Joseph Krogh
• 14:06   Re: Queries not using Index Stephan Szabo
• 14:37   Re: Editor for pgsql Josh Berkus
• 14:40   Re: Scan SQL Josh Berkus
• 15:20   Re: [GENERAL] No command history in psql Robert Treat
• 15:34   Re: Queries not using Index Daryl Herzmann
• 16:00   Re: Queries not using Index Stephan Szabo
• 16:35   Re: Scan SQL Roberto Mello
• 19:50   Re: Queries not using Index Daryl Herzmann
• 20:47   Re: Misunderstanding about your article entitled: Episode 2: Josh Berkus
• 20:53   Re: Scan SQL Josh Jore
• 21:10   Re: 7.3 features and enhancements Bruce Momjian
• 22:44   Re: FATAL 1 Bruce Momjian
• 23:33   Re: Queries not using Index Stephan Szabo
• 23:52   Re: Queries not using Index Daryl Herzmann

24 July 2002

• 00:47   Re: Queries not using Index Christopher Kings-Lynne
• 00:56   Re: Queries not using Index Daryl Herzmann
• 01:09   Re: Queries not using Index Christopher Kings-Lynne
• 01:22   Re: Queries not using Index Daryl Herzmann
• 06:24   Re: pg_dump and sequences Tom Lane
• 07:59   Re: FATAL 1 Ian Cass
• 09:55   Re: pg_dump and sequences Achilleus Mantzios
• 10:50   pg_restore vs. indexes daq
• 13:41   RES: Queries not using Index Elielson Fontanezi
• 14:18   Re: [GENERAL] RES: Queries not using Index Stephan Szabo
• 14:45   Re: RES: Queries not using Index Daryl Herzmann
• 14:53   Re: Queries not using Index Christopher Kings-Lynne
• 15:13   RES: RES: Queries not using Index Elielson Fontanezi
• 16:19   Readline ... a lot of problems... Victor Hugo Germano
• 16:19   Problem with my query whithout double-quotes ROUWEZ Stephane
• 16:19   Last record Leao Torre do Vale
• 16:19   Re: RES: Queries not using Index Phil Davey
• 16:19   Return Primary Key from Procedure Peter Atkins
• 16:23   Re: Queries not using Index Daryl Herzmann
• 16:23   Re: Scan SQL Sandro Joel Eller
• 16:23   Case in-sensitive Carmen Wai
• 16:23   No command history in psql Carmen Wai
• 16:42   Re: Last record Jan Wieck
• 16:58   Re: Last record Chris Ruprecht
• 17:11   Trying to write a function... Wim
• 17:21   Re: RES: RES: Queries not using Index Tom Lane
• 17:24   Re: Problem with my query whithout double-quotes Stephan Szabo
• 17:26   Re: Trying to write a function... Josh Berkus
• 23:48   convert a bigint into a timestamp marc sturm

25 July 2002

• 01:21   Re: Case in-sensitive Christopher Kings-Lynne
• 01:27   Re: Case in-sensitive Josh Berkus
• 09:45   Re: convert a bigint into a timestamp Richard Huxton
• 10:01   Re: Return Primary Key from Procedure Richard Huxton
• 11:23   how do I change regional setting for dates? Ligia Pimentel
• 11:23   Function using more than one database Christian Lübeck
• 12:07   use of client-side \lo_import and \lo_export commands Viacheslav Kovalchuk
• 13:29   Re: how do I change regional setting for dates? Robert Treat
• 15:48   Re: Last record omid omoomi
• 16:02   Using Tables from another database. Rogério Baldini das Neves
• 16:02   queries got slower using 7.1.3 Nathan Suderman
• 16:19   problem with plpgsql trigger function: parse error near "" Yudie@axiontech.com
• 16:30   Re: Using Tables from another database. Bruno Wolff III
• 16:32   Re: Using Tables from another database. omid omoomi
• 17:06   Re: problem with plpgsql trigger function: parse error near "" Stephan Szabo
• 17:06   Re: problem with plpgsql trigger function: parse error near "" Jan Wieck

26 July 2002

• 11:04   Re: Using Tables from another database. Reinoud van Leeuwen
• 11:04   Change size of a field ROUWEZ Stephane
• 11:48   Re: Change size of a field Achilleus Mantzios
• 12:19   Re: Change size of a field Achilleus Mantzios
• 12:28   set DateStyle to 'SQL' Elielson Fontanezi
• 12:55   Re: Using Tables from another database. D'Arcy J.M. Cain
• 13:42   RES: [GENERAL] set DateStyle to 'SQL' Elielson Fontanezi
• 15:56   RES: [GENERAL] set DateStyle to 'SQL' Elielson Fontanezi
• 16:09   Numeric Style format Elielson Fontanezi
• 17:18   Re: set DateStyle to 'SQL' Roberto João Lopes Garcia
• 17:34   1 milion data insertion Elielson Fontanezi
• 17:53   Re: 1 milion data insertion Marc Spitzer
• 20:44   Re: Function using more than one database Roberto Mello
• 20:52   Re: RES: [GENERAL] set DateStyle to 'SQL' Roberto Mello

27 July 2002

• 20:27   using LIMIT only on primary table Dan Langille

28 July 2002

• 14:50   performance difference in count(1) vs. count(*)? Markus Bertheau
• 16:02   Re: performance difference in count(1) vs. count(*)? Tom Lane
• 22:52   Abbr. for TIMESTAMP WITHOUT TIME ZONE? Josh Berkus

29 July 2002

• 02:36   Re: Problem with my query whithout double-quotes Keith Gray
• 05:12   Re: Abbr. for TIMESTAMP WITHOUT TIME ZONE? Tom Lane
• 10:34   RES: [GENERAL] The best book Elielson Fontanezi
• 10:44   RES: [GENERAL] The best book Elielson Fontanezi
• 10:56   RES: RES: [GENERAL] set DateStyle to 'SQL' Elielson Fontanezi
• 11:06   Re: [GENERAL] 1 milion data insertion Chris Albertson
• 11:06   Alter column Thiemo Kellner
• 11:06   Re: using LIMIT only on primary table Lee Harr
• 15:43   Re: RES: RES: [GENERAL] set DateStyle to 'SQL' Roberto Mello
• 17:24   Returning PK of first insert for second insert use. Peter Atkins
• 18:43   Re: Returning PK of first insert for second insert use. Peter Atkins
• 19:00   Decision support query inefficiencies ... Gunther Schadow
• 19:11   Re: Returning PK of first insert for second insert use. Peter Atkins
• 19:40   Re: Decision support query inefficiencies ... Tom Lane
• 22:35   Extremely slow query Patrick Hatcher

30 July 2002

• 01:00   Re: Extremely slow query Christopher Kings-Lynne
• 05:54   contrib/dblink suggestion Bhuvan A
• 11:35   Is login_cnt is reserved attribute name? Rajesh Kumar Mallah.
• 14:26   Re: contrib/dblink suggestion Bruce Momjian
• 14:35   Re: contrib/dblink suggestion Joe Conway
• 16:40   Delete a FOREIGN KEY Marcelo Henrique da Silva
• 18:19   Re: Returning PK of first insert for second insert use. Christopher Kings-Lynne
• 18:20   formating numeric values Elielson Fontanezi
• 18:23   Re: Delete a FOREIGN KEY Stephan Szabo
• 20:26   COUNT DISTINCT? Josh Berkus
• 20:45   Re: COUNT DISTINCT? Stephan Szabo
• 21:51   Re: COUNT DISTINCT? Josh Berkus

31 July 2002

• 03:33   Re: contrib/dblink suggestion Bhuvan A
• 10:28   3-tier Elielson Fontanezi
• 11:24   Re: 3-tier Achilleus Mantzios
• 12:16   SQL syntax Mindaugas Riauba
• 14:57   Re: SQL syntax Stephan Szabo
• 18:15   negative queries puzzle Jinn Koriech
• 19:08   Re: negative queries puzzle Stephan Szabo
• 21:59   Case Statement Tom Haddon
• 22:17   Re: Case Statement Stephan Szabo
• 22:32   FW: Case Statement Tom Haddon
• 23:20   Re: Case Statement Otto Hirr
• 23:23   Re: FW: Case Statement Stephan Szabo