Mailing lists [pgsql-sql]

1 June 2001

• 12:50   Problem with pg_index. David BOURIAUD
• 13:21   Re: Problem with pg_index. Tom Lane
• 13:51   [Fwd: Problem with pg_index.] David BOURIAUD
• 15:21   Re: Date manipulation Josh Berkus
• 15:30   Re: question about PL/pgSQL function Josh Berkus
• 15:33   PGAccess/pgplsql Blues Josh Berkus
• 15:53   select distinct too slow george young
• 16:52   Re: PGAccess/pgplsql Blues Tom Lane
• 18:46   Re: question about PL/pgSQL function Jan Wieck
• 19:53   date format Martín Marqués
• 20:55   Re: PGAccess/pgplsql Blues Roberto Mello

2 June 2001

• 09:13   trying to summarize into a new table by time... Larry Rosenman
• 12:50   Re: trying to summarize into a new table by time... Larry Rosenman
• 13:16   Re: trying to summarize into a new table by time... Tom Lane
• 13:44   Re: trying to summarize into a new table by time... Larry Rosenman
• 13:59   Re: trying to summarize into a new table by time... Tom Lane
• 14:02   Re: trying to summarize into a new table by time... Larry Rosenman
• 17:05   Re: trying to summarize into a new table by time... Alex Pilosov
• 17:42   list of returns types for functions Clayton Cottingham aka drfrog

4 June 2001

• 16:54   SQL Date Challenge Josh Berkus
• 17:22   Re: PGAccess/pgplsql Blues Josh Berkus
• 17:46   Re: SQL Date Challenge Manuel Sugawara
• 18:09   Re: SQL Date Challenge george young
• 18:09   Re: SQL Date Challenge Larry Rosenman
• 19:35   Re: SQL Date Challenge Josh Berkus
• 20:26   Re: SQL Date Challenge Alex Pilosov
• 20:29   Re: SQL Date Challenge Peter Eisentraut
• 20:48   Re: SQL Date Challenge Josh Berkus
• 23:33   Huh? Data typing bug? Josh Berkus
• 23:44   Re: Huh? Data typing bug? Grant

5 June 2001

• 00:25   Re: Huh? Data typing bug? Tom Lane
• 00:56   Re: Huh? Data typing bug? Josh Berkus
• 02:19   Re: SQL Date Challenge Josh Berkus
• 09:16   Problem on CREATE/ALTER USER chard
• 13:59   Re: Problem on CREATE/ALTER USER Tom Lane
• 16:52   Reading array's of integer in plpg/SQL Luis Sousa
• 19:23   Re: START for SERIAL type? Frank Contrepois
• 19:25   Distinct Values Nicolas
• 19:25   Re: SELECT * INTO TABLE is not working for me. Sergey E. Volkov
• 19:45   Re: How to use the template table in postgresql Hans-Jürgen Schönig
• 19:47   Re: INSERT value of type table Frank Contrepois
• 19:50   Re: Is it possible to defer triggers? Frank Contrepois
• 19:58   How to use the template table in postgresql stone
• 19:58   Re: Slow inserts/deletes Frank Contrepois
• 20:03   Re: Date manipulation reinoud@xs4all.nl (Reinoud van Leeuwen)
• 20:05   7.1 LOCK TABLE changes Brian Powell
• 20:05   Re: Upgd from 7.0 to 7.1 Thomas Swan
• 20:07   sql hard question limorr@scepia.com (limlim)
• 20:10   php-nuke Sharmad Naik
• 20:14   query on two databases .. Muhammed Yazici
• 20:14   Re: Case Insensitive Queries ANDREW PERRIN
• 20:27   Re: query on two databases .. Nils Zonneveld
• 20:31   Re: Distinct Values Stephan Szabo
• 20:44   Re: [PHP] PHP-PostgreSQL - install Chris Ruprecht
• 20:54   Re: query on two databases .. Muhammed Yazici
• 21:08   Re: query on two databases .. Stephan Szabo
• 21:27   Re: 7.1 LOCK TABLE changes Peter Eisentraut
• 22:20   plperl clayton cottingham
• 23:03   Re: plperl Tom Lane
• 23:04   Re: plperl Jie Liang
• 23:13   Re: sql hard question Josh Berkus
• 23:40   "Day" from 8am to 3am Judd Maltin

6 June 2001

• 05:45   RE: Distinct Values Hartwig Jens
• 06:00   How to use the type int2vector ? David BOURIAUD
• 09:13   Re: How to use the type int2vector ? David BOURIAUD
• 11:24   help with a function Clayton Cottingham aka drfrog
• 12:00   seleting all dates between two dates Jeff Barrett
• 12:01   Foreign Keys and Inheritance Dennis Muhlestein
• 12:18   Tutorial : using foreign keys, retrictions etc Mario Bittencourt
• 12:49   Large Objects - lo_export Guru Prasad
• 13:28   Re: Large Objects - lo_export tjk@tksoft.com
• 13:58   Re: "Day" from 8am to 3am Tom Lane
• 14:57   audit trail and system catalogs Markus Wagner
• 15:14   Re: seleting all dates between two dates Josh Berkus
• 15:16   Re: "Day" from 8am to 3am Judd Maltin
• 15:17   Re: help with a function Peter Eisentraut
• 15:39   Re: Tutorial : using foreign keys, retrictions etc Stephan Szabo
• 15:45   Re: audit trail and system catalogs Stephan Szabo
• 15:47   Re: seleting all dates between two dates george young
• 16:03   Re: Foreign Keys and Inheritance Stephan Szabo
• 16:03   Re: php-nuke Roberto Mello
• 16:03   RE: Distinct Values KuroiNeko
• 16:06   Memory exhausted in AllocSetAlloc george young
• 16:14   Re: Tutorial : using foreign keys, retrictions etc Roberto Mello
• 16:16   Cascade constraint gone!!! Linh Luong
• 16:39   maximum number of rows in table - what about oid limits? jmscott@yahoo.com (jmscott@REMOVEMEyahoo.com)
• 16:39   Re: Memory exhausted in AllocSetAlloc Stephan Szabo
• 16:45   Re: Cascade constraint gone!!! Stephan Szabo
• 16:56   Re: maximum number of rows in table - what about oid limits? Stephan Szabo
• 17:18   Re: Memory exhausted in AllocSetAlloc Tom Lane
• 17:33   How to create a *pass-through-query* in postgresql DI Hasenöhrl
• 18:07   Re: maximum number of rows in table - what about oid limits? Stephan Szabo
• 18:12   Re: maximum number of rows in table - what about oid limits? John Scott
• 18:26   Re: How to create a *pass-through-query* in postgresql Alex Pilosov
• 19:28   Functions and Triggers Hunter, Ray
• 21:05   Re: maximum number of rows in table - what about oid limits? John Scott
• 21:26   Re: maximum number of rows in table - what about oid limits? Stephan Szabo
• 21:52   Re: maximum number of rows in table - what about oid limits? Tom Lane
• 21:52   Re: How to create a *pass-through-query* in postgresql Richard Huxton
• 22:12   Re: How to create a *pass-through-query* in postgresql Josh Berkus
• 22:13   Re: maximum number of rows in table - what about oid limits? Josh Berkus

7 June 2001

• 00:00   behavior of ' = NULL' vs. MySQL vs. Standards Mark Stosberg
• 00:08   Re: maximum number of rows in table - what about oid limits? John Scott
• 00:13   Re: behavior of ' = NULL' vs. MySQL vs. Standards Stephan Szabo
• 01:06   Re: maximum number of rows in table - what about oid limits? Tom Lane
• 01:13   Re: maximum number of rows in table - what about oid limits? Tom Lane
• 01:38   Re: behavior of ' = NULL' vs. MySQL vs. Standards Tom Lane
• 02:13   Re: behavior of ' = NULL' vs. MySQL vs. Standards Stephan Szabo
• 07:06   About i8n David BOURIAUD
• 07:06   Re: How to create a *pass-through-query* in postgresql Richard Huxton
• 07:55   About table column names. David BOURIAUD
• 09:09   Re: behavior of ' = NULL' vs. MySQL vs. Standards Tom Lane
• 09:49   how to configure --with-tcl in CYGWIN guard
• 10:55   Re: About i8n jdassen@cistron.nl (J.H.M. Dassen (Ray))
• 12:35   Re: maximum number of rows in table - what about oid limits? Jonathan Bartlett
• 13:46   Re: behavior of ' = NULL' vs. MySQL vs. Standards Mark Stosberg
• 13:58   Re: About table column names. Mark Stosberg
• 14:43   Re: About table column names. Peter Eisentraut
• 15:05   dropping constraints Linh Luong
• 15:13   Re: behavior of ' = NULL' vs. MySQL vs. Standards Josh Berkus
• 15:31   Re: Re: About i8n David BOURIAUD
• 15:44   Re: dropping constraints Stephan Szabo
• 15:53   Getting row with id=max(id) Gerald Gutierrez
• 16:10   Re: Re: About i8n Peter Eisentraut
• 16:10   Are SQL commands "atomic" ? Gerald Gutierrez
• 16:26   UPDATE with concatenate Laurent Patureau
• 16:30   Re: Getting row with id=max(id) Peter Eisentraut
• 16:39   Re: Are SQL commands "atomic" ? Stephan Szabo
• 16:43   Re: UPDATE with concatenate Stephan Szabo
• 17:58   Re: Are SQL commands "atomic" ? Gerald Gutierrez
• 18:06   Re: Getting row with id=max(id) Gerald Gutierrez
• 18:13   Re: Getting row with id=max(id) Gerald Gutierrez
• 19:05   Re: Getting row with id=max(id) Alex Pilosov
• 20:58   Forein Key Problem Dennis
• 22:49   Re: plperl Clayton Cottingham aka drfrog

8 June 2001

• 06:00   Re: Re: About i8n David BOURIAUD
• 07:54   Hidden Select Luis Sousa
• 13:44   Re: maximum number of rows in table - what about oid limits? Tom Lane
• 14:31   Re: behavior of ' = NULL' vs. MySQL vs. Standards Tom Lane
• 14:35   Re: [HACKERS] Re: behavior of ' = NULL' vs. MySQL vs. Standards Tom Lane
• 14:42   Rule ON DELETE, to perform to DELETE querys ! Luis Sousa
• 14:51   Re: maximum number of rows in table - what about oid limits? Jonathan Bartlett
• 14:51   Re: maximum number of rows in table - what about oid limits? Josh Berkus
• 15:08   Re: behavior of ' = NULL' vs. MySQL vs. Standards Josh Berkus
• 15:31   Re: Hidden Select Peter Eisentraut
• 15:48   Re: Re: About i8n Peter Eisentraut
• 15:59   Re: Getting row with id=max(id) Tom Lane
• 16:21   Re: [HACKERS] Re: behavior of ' = NULL' vs. MySQL vs. Standards Josh Berkus
• 16:49   Re: maximum number of rows in table - what about oid limits? Jonathan Bartlett
• 17:15   Re: maximum number of rows in table - what about oid limits? Josh Berkus
• 18:32   Re: Rule ON DELETE, to perform to DELETE querys ! Martín Marqués
• 20:43   Re: maximum number of rows in table - what about oid limits? Jonathan Bartlett
• 21:15   Re: behavior of ' = NULL' vs. MySQL vs. Standards Tom Lane
• 21:34   Re: maximum number of rows in table - what about oid limits? Josh Berkus

9 June 2001

• 02:27   Index usage Subra Radhakrishnan
• 02:39   Re: Index usage Stephan Szabo
• 14:18   Inconsistent usage of Index Subra Radhakrishnan
• 15:16   Re: Inconsistent usage of Index Peter Eisentraut
• 15:19   Re: Index usage Peter Eisentraut
• 15:23   Re: Inconsistent usage of Index Joe Conway

10 June 2001

• 04:08   Integrity and Inheritance Christophe Labouisse
• 04:24   Re: Integrity and Inheritance Stephan Szabo
• 15:11   Re: Integrity and Inheritance Tom Lane
• 20:03   Re: Integrity and Inheritance Stephan Szabo

11 June 2001

• 03:37   Re: maximum number of rows in table - what about oid limits? Bruce Momjian
• 03:42   Re: maximum number of rows in table - what about oid limits? Bruce Momjian
• 04:46   GRANT EXECUTE Dmitry G. Mastrukov
• 07:41   RE: GRANT EXECUTE Hartwig Jens
• 11:29   Memory exhausted David Richter
• 12:18   Re: select distinct too slow Hans-Jürgen Schönig
• 12:33   Re: seleting all dates between two dates Hans-Jürgen Schönig
• 14:20   Re: Memory exhausted Tom Lane
• 14:55   ORDER BY what? Martín Marqués
• 15:12   Table design issue.... pierre@kahuna.versions.com
• 15:15   problem with Pl/Pgsql function Matteo Centenaro
• 15:20   Re: GRANT EXECUTE Peter Eisentraut
• 15:54   Re: Hidden Select Luis Sousa
• 16:22   Re: Table design issue.... Alex Pilosov
• 16:23   Re: Hidden Select Peter Eisentraut
• 16:31   finding a maximum or minimum sum Michael Richards
• 16:50   Re: problem with Pl/Pgsql function Josh Berkus
• 16:53   Re: Table design issue.... Josh Berkus
• 16:54   Re: finding a maximum or minimum sum Alex Pilosov
• 17:33   Re: Table design issue.... pierre@kahuna.versions.com
• 17:35   Re: finding a maximum or minimum sum Michael Richards
• 17:43   Re: Table design issue.... pierre@kahuna.versions.com
• 18:22   Re: finding a maximum or minimum sum Tom Lane
• 18:23   Re: Table design issue.... Josh Berkus
• 18:40   Re: finding a maximum or minimum sum Michael Richards
• 22:24   Re: ORDER BY what? David Olbersen

12 June 2001

• 06:26   hiding pg messages in c programs Markus Wagner
• 07:30   Re: Hidden Select Luis Sousa
• 12:59   PL/pgsql question Andrea Suisani
• 13:46   Re: Hidden Select Peter Eisentraut
• 15:13   Re: php-nuke Nils Zonneveld
• 15:17   Re: Distinct Values Hans-Jürgen Schönig
• 15:26   Foreign key to base table with rows in inherited tables mikael.kjellstrom@_no_spam_flygtaxi.se (Mikael Kjellström)
• 15:40   PL/PGSQL Andrzej Roszkowski
• 15:53   Cluster and primary key mikael.kjellstrom@_no_spam_flygtaxi.se (Mikael Kjellström)
• 16:05   Re: Distinct Values Hans-Jürgen Schönig
• 16:05   cascading delete - recursivity Postgresql
• 16:15   audit trail and system catalogs Markus Wagner
• 16:35   Re: rpt Jeff Boes
• 16:39   multiple sql update w/ major time issues iu_23@hotmail.com (Dawn)
• 16:45   Please help! Functions passing records between them alla@sergey.com (Alla)
• 16:45   Sub-SELECT uses un-GROUPed attribute: how to solve. Gaizka Villate
• 16:56   which sql syntax is better for joins on pgsql? fabrizio
• 17:00   Re: update from another table JWR
• 17:03   Getting row with id=max(id) Gerald Gutierrez
• 17:08   Integrity reference and inheritance Christophe Labouisse
• 17:32   Re: behavior of ' = NULL' vs. MySQL vs. Standards Thomas Lockhart
• 17:32   rpt Hilkiah Lavinier
• 17:37   Bit Mapping operation Najm Hashmi
• 18:03   Re: behavior of ' = NULL' vs. MySQL vs. Standards ANDREW PERRIN
• 18:06   sum of string columns, why ? Marcos Vaz - \( NewAge Group \)
• 18:17   need help please on triggers.. Postgresql
• 18:20   Help datetime Tubagus Nizomi
• 18:32   update from another table ivan
• 18:34   Re: [HACKERS] Re: behavior of ' = NULL' vs. MySQL vs. Standards Tom Ivar Helbekkmo
• 18:44   Function returning record alla@sergey.com (Alla)
• 18:48   Re: multiple sql update w/ major time issues Hans-Jürgen Schönig
• 19:01   RE: [HACKERS] Re: behavior of ' = NULL' vs. MySQL vs. Standards Mike Mascari
• 19:33   Re: cascading delete - recursivity Stephan Szabo
• 19:37   listing foreign keys david.brown@mviva.net (David Brown)
• 19:43   Do I have to lock table in this case? Ondrej Palkovsky
• 19:47   Re: PL/PGSQL Alex Pilosov
• 19:55   Re: Foreign key to base table with rows in inherited tables Stephan Szabo
• 19:58   Re: [HACKERS] Re: behavior of ' = NULL' vs. MySQL vs. Standards Tom Ivar Helbekkmo
• 19:59   Re: rpt Chris Ruprecht
• 20:00   Re: need help please on triggers.. Martín Marqués
• 20:09   Re: UPDATE with concatenate Rene Pijlman
• 20:09   Re: Getting row with id=max(id) 
• 20:11   Re: multiple sql update w/ major time issues Tom Lane
• 20:15   Are SQL commands "atomic" ? Gerald Gutierrez
• 20:16   Re: Cluster and primary key Mathijs Brands
• 20:21   tables, permissions, sequences Martín Marqués
• 20:27   Re: audit trail and system catalogs Alex Pilosov
• 20:32   Re: cascading delete - recursivity Jan Wieck
• 20:44   Re: Bit Mapping operation Oleg Bartunov
• 20:53   Re: ORDER BY what? Martín Marqués
• 20:59   Re: PL/PGSQL Roberto Mello
• 21:00   Re: update from another table Josh Berkus
• 21:10   Re: Bit Mapping operation Philip Hallstrom
• 21:10   Re: [GENERAL] tables, permissions, sequences Martín Marqués
• 21:20   Inheritance - Multiple membership Jimmie Fulton
• 21:46   Re: Integrity reference and inheritance Christophe Labouisse

13 June 2001

• 01:08   How to store a linked list in a RDBMS Srikanth Rao
• 13:45   Re: ORDER BY what? Martín Marqués
• 14:34   Re: How to store a linked list in a RDBMS Vivek Khera
• 16:52   Re: Inheritance - Multiple membership Josh Berkus
• 17:11   IRIX AND POSTGRES 7.1.2 David M. Richter
• 17:52   Determine the time difference from records in a select Creager, Robert S
• 19:48   large going giving errors. 
• 20:03   RE: large going giving errors. Robby Slaughter
• 20:31   Getting a specific row from a table Hunter, Ray
• 20:52   Re: Determine the time difference from records in a select Josh Berkus
• 20:55   RE: large going giving errors. 
• 20:55   Re: Determine the time difference from records in a select Josh Berkus
• 21:26   Re: large going giving errors. Tom Lane

14 June 2001

• 07:40   search/replace in update Gary Stainburn
• 11:03   Re: Getting a specific row from a table Richard Huxton
• 13:59   Re: Timestamp without time zone Vivek Khera
• 14:17   Re: search/replace in update Josh Berkus
• 14:29   Re: Re: Timestamp without time zone Alex Pilosov
• 14:51   Re: Re: Timestamp without time zone Vivek Khera
• 15:06   RE: search/replace in update Jeff Eckermann
• 15:26   Re: Re: Timestamp without time zone Tom Lane
• 15:49   Re: RE: search/replace in update Josh Berkus
• 16:20   Re: Re: Timestamp without time zone Alex Pilosov
• 16:23   Re: RE: search/replace in update Alex Pilosov
• 16:40   Re: Re: Timestamp without time zone Tom Lane
• 20:57   Re: Re: Timestamp without time zone Frank Bax

15 June 2001

• 08:31   Re: search/replace in update Gary Stainburn
• 13:42   RE: search/replace in update Jeff Eckermann
• 21:11   Why doesn't this pgsql function compile? Larry Rosenman
• 21:26   Re: Why doesn't this pgsql function compile? Alex Pilosov
• 21:44   Re: Why doesn't this pgsql function compile? Larry Rosenman
• 21:52   Re: Why doesn't this pgsql function compile? Joe Conway

16 June 2001

• 02:36   Re: Why doesn't this pgsql function compile? Larry Rosenman
• 04:10   casts and conversions Craig Longman
• 04:40   Postgres Guru Prasad
• 12:18   calling user defined function with parameters.. Postgresql
• 14:16   not null - trivial, unexpected behavior John Scott
• 15:10   Re: not null - trivial, unexpected behavior Peter Eisentraut
• 15:21   Re: not null - trivial, unexpected behavior Tom Lane
• 15:22   Re: not null - trivial, unexpected behavior Peter Eisentraut
• 15:27   Re: calling user defined function with parameters.. Stephan Szabo
• 15:44   Re: casts and conversions Tom Lane
• 15:54   Re: [HACKERS] Postgres Tom Lane
• 21:23   Re: not null - trivial, unexpected behavior Josh Berkus
• 22:26   Re: not null - trivial, unexpected behavior John Scott
• 22:52   Re: not null - trivial, unexpected behavior Josh Berkus
• 23:13   Re: not null - trivial, unexpected behavior Peter Eisentraut

17 June 2001

• 00:23   Re: not null - trivial, unexpected behavior Tom Lane
• 12:22   storing special characters BORGULYA Gergely
• 17:08   need urgent help Jie Liang
• 18:35   Re: [ADMIN] need urgent help Tom Lane
• 19:00   Re: Re: [ADMIN] need urgent help Jie Liang
• 19:35   Re: Re: [ADMIN] need urgent help Tom Lane
• 21:13   Re: Re: [ADMIN] need urgent help Jie Liang
• 21:20   Re: Re: [ADMIN] need urgent help Tom Lane
• 22:07   Re: Re: [ADMIN] need urgent help Jie Liang

18 June 2001

• 01:03   Re: casts and conversions Ross J. Reedstrom
• 02:50   Re: casts and conversions Craig Longman
• 03:55   Re: casts and conversions Tom Lane
• 04:49   Re: casts and conversions Josh Berkus
• 13:22   Re: casts and conversions Tom Lane
• 13:30   Inheritance: Performance & Indexes Itai Zukerman
• 13:42   Re: Inheritance: Performance & Indexes Alex Pilosov
• 14:01   How to build a TRIGGER in POSTGERSQL Ilan Fait
• 15:03   Better Archives? Josh Berkus
• 15:59   Re: Better Archives? Roberto Mello
• 16:00   Re: sum of string columns, why ? Ross J. Reedstrom
• 16:09   Re: Better Archives? Tom Lane
• 16:13   Re: Better Archives? Josh Berkus
• 16:42   Re: casts and conversions Bruce Momjian
• 16:47   LEFT JOIN ... The Hermit Hacker
• 16:56   Re: casts and conversions Bruce Momjian
• 17:03   Re: Better Archives? Oleg Bartunov
• 17:29   Re: LEFT JOIN ... Tom Lane
• 17:45   Force query to use index Dennis
• 17:51   Re: Better Archives? The Hermit Hacker
• 18:05   Re: LEFT JOIN ... The Hermit Hacker
• 18:09   Re: LEFT JOIN ... Stephan Szabo
• 18:31   Re: Better Archives? Josh Berkus
• 18:54   Subselects, the Oracle way Svenne Krap
• 18:56   Re: Better Archives? The Hermit Hacker
• 19:14   Re: LEFT JOIN ... Tom Lane
• 19:38   Re: Subselects, the Oracle way Joe Conway
• 19:52   Re: LEFT JOIN ... The Hermit Hacker
• 19:54   Re: Subselects, the Oracle way - slightly OT Svenne Krap
• 20:01   Referential Integrity Question (Delete/Insert during Transaction) Stef Telford
• 20:06   Re: Subselects, the Oracle way Tom Lane
• 20:08   Re: Subselects, the Oracle way Peter Eisentraut
• 20:24   Problems ensuring uniqueness? Christopher Smith
• 21:01   Re: Problems ensuring uniqueness? Tom Lane
• 21:18   Are there array functions in Postgres? reina@nsi.edu (Tony Reina)
• 21:19   Re: Problems ensuring uniqueness? Tom Lane
• 21:20   Re: Problems ensuring uniqueness? Christopher Smith
• 21:42   Re: Problems ensuring uniqueness? Christopher Smith
• 21:59   Re: Referential Integrity Question (Delete/Insert during Transaction) Stephan Szabo

19 June 2001

• 01:34   A cute little function Josh Berkus
• 04:13   Sequence behaviour. Grant
• 05:10   Re: Sequence behaviour. Tom Lane
• 10:43   Re: How to build a TRIGGER in POSTGERSQL darcy@druid.net (D'Arcy J.M. Cain)
• 11:14   About primary keys. David BOURIAUD
• 11:37   Re: About primary keys. darcy@druid.net (D'Arcy J.M. Cain)
• 11:54   Re: About primary keys. David BOURIAUD
• 12:31   Re: How to build a TRIGGER in POSTGERSQL alla@sergey.com (Alla)
• 12:55   Re: About primary keys. Roberto Mello
• 13:47   Re: About primary keys. Tom Lane
• 13:48   Re: About primary keys. David BOURIAUD
• 22:04   Re: Sequence behaviour. Grant

20 June 2001

• 03:44   log file Jie Liang
• 04:06   pg_xlog Jie Liang
• 04:42   pg_xlogs Jie Liang
• 05:18   unrecognized language 'plpgsql' Markus Wagner
• 09:03   Re: unrecognized language 'plpgsql' Richard Huxton
• 09:03   Re: log file Richard Huxton
• 10:02   Re: [ADMIN] Row Level Locking !! Christof Glaser
• 11:56   evaluating values of attributes from computed attribute names in trigger function Markus Wagner
• 13:49   possible to lock a single row in table? bboett@erm1.u-strasbg.fr (Bruno Boettcher)
• 14:15   Re: log file Josh Berkus
• 14:22   Re: unrecognized language 'plpgsql' Josh Berkus
• 14:31   Re: Re: [ADMIN] Row Level Locking !! Roberto Mello
• 15:30   Help on a sql querry. David BOURIAUD
• 16:09   Re: possible to lock a single row in table? Peter Eisentraut
• 16:26   Re: binary data hughmandeville@hotmail.com (Hugh Mandeville)
• 16:37   Re: [GENERAL] Re: ORDER BY what? Lamar Owen
• 16:51   Re: ORDER BY what? Bruno Wolff III
• 17:08   set datestyle to European PROBLEM Alessandro Rossi
• 17:16   Re: possible to lock a single row in table? Stephan Szabo
• 17:16   casting varchar to numeric Alex K.
• 17:18   Extracting date from epoche Najm Hashmi
• 17:22   calling user defined functions with parameters.. ? Postgresql
• 17:32   Passing cursor between functions in embedded SQL alla@sergey.com (Alla)
• 17:32   Re: ORDER BY what? Bruno Wolff III
• 17:33   Moving between databases Mark
• 17:37   arguments for query files david.brown@mviva.net (David Brown)
• 17:45   Timestamp without time zone Pasi Salminen
• 17:46   Functions and Triggers Hunter, Ray
• 17:52   Re: Passing cursor between functions in embedded SQL Sergey E. Volkov
• 17:53   CAST issue/ecpg Adriaan Joubert
• 17:53   How to check if a table exists from functions. mikael.kjellstrom@_no_spam_flygtaxi.se (Mikael Kjellström)
• 18:02   Re: Re: binary data Alex Pilosov
• 18:02   Re: not null - trivial, unexpected behavior Rene Pijlman
• 18:03   Row Level Locking !! Mahesh Guleria
• 18:04   database encryption caroline_m@gmx.at (Caroline)
• 18:14   Re: storing special characters Hugh Mandeville
• 18:16   Functions and Triggers Hunter, Ray
• 18:17   Using the extract() function in plpgsql Kristis Makris
• 18:21   Re: Moving between databases mcbang@gmx.de (Ingo Oellers)
• 18:24   Re: binary data Hugh Mandeville
• 18:35   Re: Help on a sql querry. Frank Bax
• 18:40   select by streak Joseph Shraibman
• 18:42   Limit and insert Matteo Centenaro
• 18:44   How to build a TRIGGER in POSTGERSQL Ilan Fait
• 18:55   pl/pgsql question (functions) Kristoff Bonne
• 19:07   Re: set datestyle to European PROBLEM George Moga
• 21:01   Re: Using the extract() function in plpgsql Peter Eisentraut
• 21:04   Re: How to check if a table exists from functions. Stephan Szabo
• 21:39   commentds on redhats new database clayton cottingham
• 21:56   Re: Using the extract() function in plpgsql Kristis Makris
• 22:13   Re: commentds on redhats new database Ross J. Reedstrom

21 June 2001

• 04:32   Re: commentds on redhats new database Tom Lane
• 04:53   Re: commentds on redhats new database Ross J. Reedstrom
• 05:12   plsql in 7.1 Jie Liang
• 08:33   Re: select by streak Richard Huxton
• 08:33   Re: Extracting date from epoche Richard Huxton
• 08:33   Re: pl/pgsql question (functions) Richard Huxton
• 10:12   Problem by inserting rows in a table via function DI Hasenöhrl
• 13:06   Re: Extracting date from epoche Tom Lane
• 13:33   Re: Using the extract() function in plpgsql Richard Huxton
• 13:48   RE: arguments for query files Jeff Eckermann
• 14:43   Correct syntex for implicit curor in for loops Najm Hashmi
• 15:10   Re: Correct syntex for implicit curor in for loops Jan Wieck
• 15:46   Re: Correct syntex for implicit curor in for loops Josh Berkus
• 16:26   Changing PL/pgSQL triggers James Orr
• 16:29   Re: Correct syntex for implicit curor in for loops Jan Wieck
• 16:51   Re: Changing PL/pgSQL triggers Roberto Mello
• 17:03   Re: Extracting date from epoche Richard Huxton
• 17:03   Re: Correct syntex for implicit curor in for loops Tom Lane
• 17:51   RE: Select most recent record? Mark Hamby
• 18:13   Re: select by streak Joseph Shraibman
• 18:31   RE: Select most recent record? Marc Sherman
• 18:39   Re: Changing PL/pgSQL triggers Josh Berkus
• 22:10   case, new column not found Martín Marqués
• 22:46   Re: case, new column not found Stephan Szabo
• 22:50   Re: case, new column not found Tom Lane
• 23:08   Re: case, new column not found Josh Berkus

22 June 2001

• 06:48   Re: Changing PL/pgSQL triggers Kristoff Bonne
• 06:56   Difference between insert a tuple in a table by function and by datasheet DI Hasenöhrl
• 07:01   distinguishing different database connections Markus Wagner
• 07:17   Re: pl/pgsql question (functions) Kristoff Bonne
• 07:24   Dump db with LO vincent@waw.pdi.net
• 07:34   RE: [ODBC] Difference between insert a tuple in a table by function and by datasheet Hiroshi Inoue
• 08:15   Re: distinguishing different database connections Christof Glaser
• 10:33   Re: pl/pgsql question (functions) Richard Huxton
• 11:14   CAST Problem: Difference between insert a tuple in a table by function and by datasheet DI Hasenöhrl
• 11:36   select tbl1.attr1, number of tuples where tbl2.attr1=tbl1.attr1 Markus Bertheau
• 11:36   Re: distinguishing different database connections Alex Pilosov
• 11:54   constraints, 
• 12:00   firehouse sbelow
• 12:14   Re: set datestyle to European PROBLEM Roelof Sondaar
• 12:24   Re: Re: binary data Hugh Mandeville
• 12:26   Help with a double left join Ari Nepon
• 12:39   RE: Difference between insert a tuple in a table by function and by datasheet Cyril Slucki
• 12:48   Re: Changing PL/pgSQL triggers Alain Lavigne
• 12:49   Re: Re: binary data Hugh Mandeville
• 12:49   Problem with installing Postgresql 7.1.1 Wei Weng
• 12:55   What is a "tuple" Kristoff Bonne
• 13:05   Incremental sum ? domingo@dad-it.com (Domingo Alvarez Duarte)
• 13:11   RE: Help with a double left join Ari Nepon
• 13:33   Re: select tbl1.attr1, number of tuples where tbl2.attr1=tbl1.attr1 Tom Lane
• 13:36   Re: Help with a double left join Alex Pilosov
• 13:47   Re: Re: Re: binary data Tom Lane
• 14:15   View performance question Josh Berkus
• 14:17   Re: Help with a double left join Tom Lane
• 14:24   Re: What is a "tuple" Alex Pilosov
• 14:40   Re: Re: Re: binary data Karel Zak
• 14:41   Re: Incremental sum ? Alex Pilosov
• 14:55   Re: firehouse Ross J. Reedstrom
• 15:06   Re: View performance question Alex Pilosov
• 15:12   Re: Re: Re: binary data Tom Lane
• 15:20   cache lookup failed ???? What is it ???!!! J.Fernando Moyano
• 15:31   Re: Incremental sum ? Ross J. Reedstrom
• 15:31   Re: What is a "tuple" Kristoff Bonne
• 15:40   Re: Difference between insert a tuple in a table by function and by datasheet Richard Huxton
• 16:06   Re: cache lookup failed ???? What is it ???!!! Peter Eisentraut
• 16:18   Re: Incremental sum ? Tom Lane
• 16:19   Re: View performance question Tom Lane
• 16:21   Re: View performance question Alex Pilosov
• 16:24   Re: firehouse Bruce Momjian
• 16:26   Re: View performance question Josh Berkus
• 16:36   Re: Incremental sum ? Ross J. Reedstrom
• 17:07   unregister Porfirio Córdoba
• 17:20   Re: View performance question Tom Lane
• 17:32   Re: What is a "tuple" Ross J. Reedstrom
• 17:32   timestamp conversion to unisgned long? pierre@kahuna.versions.com
• 18:00   Re: distinguishing different database connections Stephan Szabo
• 18:06   Re: View performance question Josh Berkus
• 18:16   Re: timestamp conversion to unisgned long? Alex Pilosov
• 18:31   Re: timestamp conversion to unisgned long? Peter Eisentraut
• 20:12   Re: View performance question Tom Lane

23 June 2001

• 16:54   RE: firehouse Magnus Hagander
• 23:26   Re: Re: Re: binary data Bruce Momjian

24 June 2001

• 23:57   When using COPY datactrl

25 June 2001

• 07:29   Foreign key problem Andreas Tille
• 08:01   Plsql Function with error: No space left on device. David M. Richter
• 09:26   Re: Difference between insert a tuple in a table by function and by datasheet DI Hasenöhrl
• 10:24   Re: Plsql Function with error: No space left on device. Richard Huxton
• 10:33   Re: What is a "tuple" Jan Wieck
• 13:04   Re: Foreign key problem Christof Glaser
• 13:14   Re: Foreign key problem Itai Zukerman
• 14:34   Problems using a rule with the WHERE clause Luis Sousa
• 15:39   Re: Foreign key problem Stephan Szabo
• 15:42   control structure in a transaction block? Wei Weng
• 17:01   Re: Problems using a rule with the WHERE clause Tom Lane
• 21:09   select with multiple occurences in same table William Herring
• 21:41   Re: select with multiple occurences in same table Josh Berkus

26 June 2001

• 00:02   pl/pgSQL and escaping LIKE clauses Robby Slaughter
• 04:54   loosing connection after function call Markus Wagner
• 06:44   Changing datatype of a column Ilan Fait
• 08:52   Re: Problems using a rule with the WHERE clause Luis Sousa
• 10:33   TEXT field size Antti Linno
• 10:34   Re: Plsql Function with error: No space left on device. David M. Richter
• 12:26   Re: Plsql Function with error: No space left on device. David M. Richter
• 12:33   Re: Plsql Function with error: No space left on device. Richard Huxton
• 13:03   Re: TEXT field size Richard Huxton
• 13:43   Nested Transactions John Hasler
• 13:44   Re: Problems using a rule with the WHERE clause Tom Lane
• 13:56   Re: Changing datatype of a column Peter Eisentraut
• 14:18   Re: loosing connection after function call Tom Lane
• 14:24   Re: Plsql Function with error: No space left on device. Tom Lane
• 16:03   Re: Changing datatype of a column Jason Earl
• 18:58   Re: Using the extract() function in plpgsql Kristis Makris
• 21:11   Storing image contents in TEXT fields Jerome Alet
• 21:23   how to limit user to open another session Jie Liang
• 21:29   Re: Storing image contents in TEXT fields Alex Pilosov

27 June 2001

• 04:32   strange plan Craig Longman
• 04:49   Re: strange plan Craig Longman
• 05:57   session detect and terminate Jie Liang
• 06:49   Re: Using the extract() function in plpgsql Richard Huxton
• 10:53   Re: Plsql Function with error: No space left on device. David M. Richter
• 12:08   Re: Plsql Function with error: No space left on device. David M. Richter
• 13:12   Re: Plsql Function with error: No space left on device. Tom Lane
• 14:29   Re: Storing image contents in TEXT fields Jan Wieck
• 15:08   Re: Using the extract() function in plpgsql Kristis Makris
• 17:28   Re: Storing image contents in TEXT fields Jerome Alet
• 18:03   Re: Using the extract() function in plpgsql Richard Huxton
• 18:04   Re: Storing image contents in TEXT fields Jan Wieck
• 18:25   Re: Using the extract() function in plpgsql Kristis Makris
• 19:16   Re: Using the extract() function in plpgsql Tom Lane
• 20:10   Re: Using the extract() function in plpgsql Kristis Makris

28 June 2001

• 09:14   Re: Problems using a rule with the WHERE clause Luis Sousa
• 11:51   Subquery error. Help please!! kakerjak
• 12:21   filtering sbelow
• 12:42   Re: Text manipulation in SQL jim_esti@hotmail.com (Jim)
• 12:45   Link many attributes in one table to one attribute in another?? Christian Anton
• 12:56   Cast varchar to interval in plpgsql Sergei Pohilko
• 12:56   Using DateDiff with Postgres jeff@emojo.com (Jeff Rhys-Jones)
• 13:02   Re: Re: Re: binary data Hugh Mandeville
• 13:04   Re: Subquery error. Help please!! Wei Weng
• 13:35    Ilan Fait
• 13:53   Re: Link many attributes in one table to one attribute in another?? Wei Weng
• 14:03   Re: Subquery error. Help please!! Tom Lane
• 14:22   Re: Link many attributes in one table to one attribute in another?? Richard Huxton
• 14:23   examine the database Ilan Fait
• 14:42   Re: Link many attributes in one table to one attribute in another?? Christof Glaser
• 14:43   Re: Using DateDiff with Postgres Richard Huxton
• 14:54   Re: filtering Josh Berkus
• 15:39   Re: Problems using a rule with the WHERE clause Tom Lane
• 16:13   Re: Re: Re: Re: binary data Alex Pilosov
• 16:29   Re: Subquery error. Help please!! Ross J. Reedstrom
• 16:41   Re: Using DateDiff with Postgres Josh Berkus
• 17:34   restoring a dump Phuong Ma
• 18:08   timeout Jie Liang
• 18:57   Still stuck on a left join Ari Nepon
• 20:25   Re: restoring a dump Peter Eisentraut
• 21:39   Re: Still stuck on a left join Josh Berkus
• 22:31   Re: restoring a dump Phuong Ma
• 22:53   Re: restoring a dump Wei Weng

29 June 2001

• 07:34   Query Optimisation required Kapil Tilwani
• 07:35    Kapil Tilwani
• 11:33   day difference Jackie Siu
• 12:06   NOTIFY "string" from rule Jeff Boes
• 12:52   Re: [ADMIN] timeout Jeremy Buchmann
• 13:43   Re: day difference Josh Berkus
• 14:34   Evaluating Subselects Josh Berkus
• 14:40   Re: NOTIFY "string" from rule Tom Lane
• 15:27   RE: Evaluating Subselects Jeff Eckermann
• 15:30   create datatype Craig Longman
• 18:52   creating variable views Dado Feigenblatt

30 June 2001

• 03:14   Re: day difference Christopher Sawtell
• 05:13   Re: [GENERAL] Kapil Tilwani
• 11:03   Re: creating variable views Richard Huxton
• 20:08   Date validation? Josh Berkus