Mailing lists [pgsql-sql]

1 November 2007

• 21:05   Scrolling cursors in PL/PgSQL Dawid Kuroczko
• 21:23   Re: [GENERAL] Scrolling cursors in PL/PgSQL Pavel Stehule
• 21:44   Re: [GENERAL] Scrolling cursors in PL/PgSQL Tom Lane

4 November 2007

• 12:15   omitting redundant join predicate Ehab Galal
• 15:35   Re: omitting redundant join predicate Tom Lane
• 15:49   SELECT DISTINCT ... ORDER BY UPPER(column_name) fails Aymeric Levaux
• 16:12   Re: SELECT DISTINCT ... ORDER BY UPPER(column_name) fails Tom Lane
• 16:57   Partitioning and Foreign Keys Volkan YAZICI

5 November 2007

• 06:36   Returning the total number of rows as a separate column when using limit Andreas Joseph Krogh
• 08:31   Re: Backup Database Asko Oja
• 11:16   changing encoding of a postgres database Kenneth Gonsalves
• 13:18   Re: Returning the total number of rows as a separate column when using limit Tom Lane
• 13:38   Re: Returning the total number of rows as a separate column when using limit Andreas Joseph Krogh
• 14:01   Re: Returning the total number of rows as a separate column when using limit Tom Lane
• 14:15   Re: omitting redundant join predicate Ehab Galal
• 14:27   Re: Returning the total number of rows as a separate column when using limit Gregory Stark
• 15:08   Re: omitting redundant join predicate Tom Lane
• 15:33   Re: Returning the total number of rows as a separate column when using limit Andreas Joseph Krogh
• 18:21   Re: Returning the total number of rows as a separate column when using limit Gregory Stark

6 November 2007

• 05:59   Re: Returning the total number of rows as a separate column when using limit Gregory Stark
• 09:09   Treating result of subselect as row Ottó Havasvölgyi
• 11:50   Bitemporal - problem with correalated subquery? Keith Carr

7 November 2007

• 09:37   EPOCH TIMESTAMP Conversion Problem Amitanand Chikorde
• 12:23   Temporal databases Philippe Lang
• 14:35   Re: EPOCH TIMESTAMP Conversion Problem Tom Lane

8 November 2007

• 15:49   Re: Partitioning and Foreign Keys Vivek Khera
• 16:56   Obtaining the primary key of the record just inserted Oliveiros Cristina
• 17:03   Re: Obtaining the primary key of the record just inserted Scott Marlowe
• 18:10   Re: Obtaining the primary key of the record just inserted Oliveiros Cristina
• 19:06   quote_nullable alternative? Philippe Lang

9 November 2007

• 06:14   Re: quote_nullable alternative? Philippe Lang
• 12:40   design of tables for sparse data Andreas
• 12:59   Re: Temporal databases Keith Carr
• 16:21   Select in From clause Ray Madigan
• 18:14   Re: Select in From clause Alvaro Herrera
• 18:46   functions are returns columns Michele Petrazzo - Unipex srl
• 19:36   Re: functions are returns columns Pavel Stehule

10 November 2007

• 16:38   Re: functions are returns columns Michele Petrazzo - Unipex srl
• 18:36   Re: functions are returns columns Gregory Stark
• 18:46   Re: functions are returns columns Tom Lane
• 20:04   Re: functions are returns columns Gregory Stark
• 22:14   Re: functions are returns columns Tom Lane
• 23:23   general question on optimizer chester c young

12 November 2007

• 07:23   Re: Select in From clause Bart Degryse
• 08:08   Re: Temporal databases Philippe Lang
• 08:43   show value of backslashes in string array argument Sabin Coanda
• 08:58   Re: show value of backslashes in string array argument Achilleas Mantzios
• 09:13   Re: show value of backslashes in string array argument Sabin Coanda
• 09:21   Re: show value of backslashes in string array argument Achilleas Mantzios
• 09:43   plpgsql language not aware of standard_conforming_strings ? Sabin Coanda
• 10:13   Re: plpgsql language not aware of standard_conforming_strings ? Sabin Coanda
• 15:05   Re: show value of backslashes in string array argument Tom Lane
• 15:43   Re: plpgsql language not aware of standard_conforming_strings ? Sabin Coanda
• 16:18   Re: show value of backslashes in string array argument Sabin Coanda
• 19:27   Problem with UNION-queries Andreas Joseph Krogh
• 20:48   Re: design of tables for sparse data Fernando Hevia

13 November 2007

• 01:10   Re: design of tables for sparse data Andreas
• 14:33   Re: design of tables for sparse data Erik Jones

14 November 2007

• 10:06   Originally created and last_mod by whom and when ? Aarni Ruuhimäki
• 10:29   Re: Originally created and last_mod by whom and when ? Richard Huxton
• 10:35   ALL() question Julien Cigar
• 10:57   Re: ALL() question Richard Huxton
• 11:39   Re: Originally created and last_mod by whom and when ? Aarni Ruuhimäki
• 11:46   Re: ALL() question Julien Cigar
• 11:54   Re: ALL() question Julien Cigar
• 11:57   Re: ALL() question Bart Degryse
• 12:20   Re: ALL() question Richard Huxton
• 12:21   Re: ALL() question Richard Huxton
• 12:31   Re: ALL() question hubert depesz lubaczewski
• 12:47   Re: ALL() question Julien Cigar
• 12:48   Re: Temporal databases Philippe Lang
• 14:46   Re: ALL() question Osvaldo Rosario Kussama
• 16:54   postgres bogged down beyond tolerance Tena Sakai
• 17:35   Re: postgres bogged down beyond tolerance Richard Broersma Jr

15 November 2007

• 13:14   Re: trap for any exception Sabin Coanda
• 13:14   trap for any exception Sabin Coanda
• 13:14   Re: trap for any exception Sabin Coanda
• 14:35   Re: trap for any exception Stephan Szabo
• 15:06   Is there anything special about pg_dump's compression? Jean-David Beyer
• 15:11   Re: Is there anything special about pg_dump's compression? Andrew Sullivan
• 17:36   Re: trap for any exception Stephan Szabo
• 18:06   Erlang & PostgreSQL native driver Daniel Caune

16 November 2007

• 04:13   Re: Is there anything special about pg_dump's compression? Jean-David Beyer
• 04:29   Re: Is there anything special about pg_dump's compression? Tom Lane
• 06:57   Re: trap for any exception Bart Degryse
• 11:54   Re: Is there anything special about pg_dump's compression? Jean-David Beyer
• 15:41   Re: Is there anything special about pg_dump's compression? Shane Ambler
• 19:36   Re: Is there anything special about pg_dump's compression? Jean-David Beyer

18 November 2007

• 01:46   Re: postgres bogged down beyond tolerance Gregory Stark

19 November 2007

• 13:15   EXPLAIN ANALYZE inside functions Sabin Coanda
• 14:15   Re: EXPLAIN ANALYZE inside functions Sabin Coanda
• 19:47   Aggregate question (Sum) Luiz K. Matsumura
• 20:11   Re: Aggregate question (Sum) Rodrigo De León
• 22:17   Re: Aggregate question (Sum) Luiz K. Matsumura

20 November 2007

• 08:21   Run Function With First Priority Otniel Michael
• 09:23   Loading 8.2 data into 8.1 Andreas Joseph Krogh
• 15:13   dynmic column names inside trigger? Louis-David Mitterrand
• 15:57   Re: dynmic column names inside trigger? Tom Lane

21 November 2007

• 02:14   Re: [ODBC] string function Phillip Smith
• 07:14   Re: dynmic column names inside trigger? Bart Degryse
• 12:23   PL argument max size, and doubt Martin Marques
• 14:29   Re: PL argument max size, and doubt Rodrigo De León
• 16:47   Re: PL argument max size, and doubt Martin Marques
• 17:05   Re: PL argument max size, and doubt Tom Lane

22 November 2007

• 01:59   update on join ? Andreas
• 02:34   Re: update on join ? Frank Bax
• 02:38   Re: update on join ? Richard Broersma Jr
• 02:41   Re: update on join ? chester c young
• 06:44   Bad Schema Design or Useful Trick? Richard Broersma Jr
• 10:02   How to have a unique primary key on two tables Daniel \"bodom_lx\" Graziotin
• 10:11   Re: How to have a unique primary key on two tables Bart Degryse
• 10:20   Re: How to have a unique primary key on two tables A. Kretschmer
• 12:19   Re: Loading 8.2 data into 8.1 Peter Eisentraut
• 12:46   Re: Bad Schema Design or Useful Trick? Richard Huxton
• 12:49   Re: How to have a unique primary key on two tables D'Arcy J.M. Cain
• 12:54   Re: dynmic column names inside trigger? Louis-David Mitterrand
• 12:55   Re: dynmic column names inside trigger? Louis-David Mitterrand
• 13:11   Re: dynmic column names inside trigger? Bart Degryse
• 14:24   SQL state: 22P02 Franklin Haut
• 15:06   Re: SQL state: 22P02 Rodrigo De León
• 20:37   Re: PL argument max size, and doubt Martin Marques

23 November 2007

• 05:40   Re: PL argument max size, and doubt Tom Lane
• 08:46   Aleatory exception Sabin Coanda
• 08:46   Re: Aleatory exception Sabin Coanda
• 09:38   Re: PL argument max size, and doubt Martin Marques
• 10:46   Re: Aleatory exception - found cause Sabin Coanda
• 16:06   Re: dynmic column names inside trigger? Louis-David Mitterrand
• 19:54   Re: dynmic column names inside trigger? Michael Glaesemann

26 November 2007

• 07:13   Re: dynmic column names inside trigger? Bart Degryse
• 20:08   PG trouble with index-usage in sort Andreas Joseph Krogh
• 20:17   materialize Ehab Galal
• 20:53   Re: materialize Tom Lane

27 November 2007

• 18:55   pg_clog (?) problem with VACUMM Gerardo Herzig
• 19:17   Re: pg_clog (?) problem with VACUMM Gregory Stark
• 20:34   Re: pg_clog (?) problem with VACUMM Gerardo Herzig
• 21:06   Re: pg_clog (?) problem with VACUMM Stefan Becker
• 23:16   Strang behaviour SELECT ... LIMIT n FOR UPDATE Daniel Caune

28 November 2007

• 01:04   NULLIF problem Gera Mel Handumon
• 01:48   Re: NULLIF problem Michael Glaesemann
• 03:46   Re: Strang behaviour SELECT ... LIMIT n FOR UPDATE Tom Lane
• 03:50   Re: Strang behaviour SELECT ... LIMIT n FOR UPDATE Bruce Momjian
• 14:14   obtaining column names from tables or views John van Zantvoort
• 14:29   Re: obtaining column names from tables or views Richard Huxton
• 18:01   Re: NULLIF problem Erik Jones
• 18:51   Re: Strang behaviour SELECT ... LIMIT n FOR UPDATE Daniel Caune
• 19:33   Re: Strang behaviour SELECT ... LIMIT n FOR UPDATE Tom Lane
• 20:28   Re: Strang behaviour SELECT ... LIMIT n FOR UPDATE Daniel Caune
• 21:08   Re: Strang behaviour SELECT ... LIMIT n FOR UPDATE Tom Lane

29 November 2007

• 00:08   Re: Strang behaviour SELECT ... LIMIT n FOR UPDATE Alvaro Herrera
• 08:44   Re: NULLIF problem Gera Mel Handumon
• 11:46   Re: NULLIF problem Michael Glaesemann
• 12:02   statement-level trigger sample out there? Christian Kindler
• 12:48   Re: statement-level trigger sample out there? Pavel Stehule
• 13:16   Re: statement-level trigger sample out there? Stephen Cook
• 13:27   Re: statement-level trigger sample out there? Pavel Stehule
• 13:44   ... Christian Kindler
• 14:05   Re: statement-level trigger sample out there? Christian Kindler
• 18:06   Re: statement-level trigger sample out there? Gerardo Herzig
• 18:17   Re: statement-level trigger sample out there? Alvaro Herrera
• 18:57   Re: statement-level trigger sample out there? Gerardo Herzig

30 November 2007

• 08:41   Re: statement-level trigger sample out there? hubert depesz lubaczewski
• 14:00   Using schema Daniel Caune