Mailing lists [pgsql-sql]

1 May 2011

• 19:52   Multiple recursive part possible? Svenne Krap
• 22:12   Re: Multiple recursive part possible? Tom Lane

2 May 2011

• 03:18   Re: Multiple recursive part possible? Svenne Krap
• 10:46   BINARY and BINARY VARYING datatypes in PostgreSQL Grzegorz Szpetkowski
• 15:19   getting PSQLException Can't infer the SQL type to use with Native Query call Steven Dahlin
• 15:39   FATAL: invalid cache id: 19 manuel antonio ochoa
• 16:33   Re: FATAL: invalid cache id: 19 Tom Lane
• 16:34   Re: getting PSQLException Can't infer the SQL type to use with Native Query call Tom Lane
• 21:43   PLpgSQL variables persistance between several functions calls Charles N. Charotti

3 May 2011

• 02:10   Re: PLpgSQL variables persistance between several functions calls Pavel Stehule
• 08:18   checking for the existence of a current_setting ? Marc Mamin
• 09:12   Re: BINARY and BINARY VARYING datatypes in PostgreSQL Susanne Ebrecht
• 10:20   Re: PLpgSQL variables persistance between several functions calls Willy-Bas Loos
• 11:14   Re: PLpgSQL variables persistance between several functions calls Viktor Bojović
• 12:41   Re: BINARY and BINARY VARYING datatypes in PostgreSQL Grzegorz Szpetkowski
• 14:53   Re: How to realize ROW_NUMBER() in 8.3? Emi Lu
• 15:10   Re: convert in GMT time zone without summer time LaraK
• 15:54   Re: convert in GMT time zone without summer time Steve Crawford
• 22:51   function timeout Viktor Bojović

4 May 2011

• 05:28   Re: How to realize ROW_NUMBER() in 8.3? Andreas Kretschmer
• 23:27   data import via COPY, Rules + Triggers Tarlika Elisabeth Schmitz

5 May 2011

• 15:38   Re: data import via COPY, Rules + Triggers Tarlika Elisabeth Schmitz
• 20:19   Select and merge rows? Claudio Adriano Guarracino
• 20:25   Re: Select and merge rows? Oliveiros
• 20:53   Select and merge rows? Claudio Adriano Guarracino
• 21:41   Re: [SQL] Select and merge rows? Charlie
• 22:01   slightly OT - Using psql from Emacs with sql.el Seb
• 22:47   Re: slightly OT - Using psql from Emacs with sql.el Rob Sargent
• 22:56   Re: slightly OT - Using psql from Emacs with sql.el Seb
• 23:15   Re: slightly OT - Using psql from Emacs with sql.el Rob Sargent

6 May 2011

• 01:06   Re: Select and merge rows? Claudio Adriano Guarracino
• 05:08   check constraint bug? Tarlika Elisabeth Schmitz
• 05:10   Re: check constraint bug? Scott Marlowe
• 05:41   Re: Select and merge rows? Claudio Adriano Guarracino
• 14:57   None numeric exclusion constraints using GIST Richard Broersma
• 21:58   FOR EACH STATEMENT trigger ? F. BROUARD / SQLpro
• 22:12   Re: FOR EACH STATEMENT trigger ? Pavel Stehule

7 May 2011

• 09:38   Re: data import via COPY, Rules + Triggers Tarlika Elisabeth Schmitz
• 10:08   Re: data import via COPY, Rules + Triggers Tarlika Elisabeth Schmitz
• 11:19   Specifying column level collations Thomas Kellerer
• 12:03   Re: Specifying column level collations Guillaume Lelarge
• 13:34   Re: Specifying column level collations Thomas Kellerer
• 16:49   Re: Specifying column level collations Tom Lane
• 20:12   Re: Specifying column level collations Thomas Kellerer
• 22:33   Re: slightly OT - Using psql from Emacs with sql.el Seb

9 May 2011

• 06:09   FOR EACH STATEMENT trigger ? Frédéric BROUARD
• 06:09   Re: check constraint bug? Lew
• 10:19   Re: FOR EACH STATEMENT trigger ? Pavel Stehule
• 12:38   Trigger: update if record exists Tarlika Elisabeth Schmitz
• 16:27   Sorting Issue Ozer, Pam
• 20:08   Re: Sorting Issue Emi Lu
• 20:09   Re: Sorting Issue Ozer, Pam
• 20:17   Re: Sorting Issue Emi Lu
• 20:17   Re: Sorting Issue Ozer, Pam
• 20:39   Re: Sorting Issue Emi Lu
• 21:08   Re: Sorting Issue Samuel Gendler
• 21:29   Re: Sorting Issue Tom Lane
• 22:13   Re: Sorting Issue Ozer, Pam

10 May 2011

• 14:29   view table with foreign key relative values fpirotti
• 15:07   Re: Sorting Issue Ozer, Pam
• 15:26   Re: Sorting Issue Ozer, Pam
• 16:47   Re: Sorting Issue Tom Lane
• 16:58   Dates and NULL's` John Fabiani
• 17:11   Re: Sorting Issue Edward W. Rouse
• 17:16   Re: Dates and NULL's` Richard Broersma
• 17:24   Re: Dates and NULL's` John Fabiani
• 17:31   Re: Dates and NULL's` Richard Broersma
• 17:51   Re: Dates and NULL's` John Fabiani
• 17:53   Re: Sorting Issue Samuel Gendler
• 17:58   Re: Sorting Issue Scott Marlowe
• 20:16   Re: Dates and NULL's` Emi Lu
• 20:33   Re: Dates and NULL's` Brent Dombrowski
• 20:36   Re: Dates and NULL's` Emi Lu
• 20:51   Re: Dates and NULL's` Theodore Petrosky

11 May 2011

• 05:56   Re: Dates and NULL's` Lew
• 20:29   replace " with nothing Tony Capobianco
• 20:51   Re: replace " with nothing Tony Capobianco
• 21:11   Re: replace " with nothing Leif Biberg Kristensen
• 21:22   Re: replace " with nothing Ross J. Reedstrom
• 21:25   Re: replace " with nothing Ross J. Reedstrom
• 21:37   Re: replace " with nothing Leif Biberg Kristensen
• 23:19   CROSS JOIN ordering Grzegorz Szpetkowski

12 May 2011

• 11:07   Re: CROSS JOIN ordering Richard Huxton
• 20:32   Re: replace " with nothing Lew
• 20:32   ordering by date for each ID Nguyen,Diep T
• 20:45   Re: ordering by date for each ID Thomas Kellerer
• 22:19   Re: ordering by date for each ID Samuel Gendler

14 May 2011

• 11:04   Sorting data based fields in two linked tables R. Smith
• 12:59   Re: Sorting data based fields in two linked tables Oliver d'Azevedo Christina
• 13:54   Re: [SQL] Sorting data based fields in two linked tables Charlie
• 22:09   self join Seb
• 22:39   Re: self join Ian Lawrence Barwick
• 22:49   Re: self join Seb

15 May 2011

• 03:00   Re: self join Jasen Betts
• 08:04   Re: self join Harald Fuchs

16 May 2011

• 10:05   Performance of NOT IN and <> with PG 9.0.4 Jasmin Dizdarevic
• 11:07   Re: Performance of NOT IN and <> with PG 9.0.4 Craig Ringer
• 15:50   Re: self join Steve Crawford

17 May 2011

• 09:30   Re: self join Jasen Betts

18 May 2011

• 04:23   enum data type vs table Seb
• 20:20   column type for pdf file Emi Lu
• 20:21   foreign keys and lots of tables Gary Stainburn
• 20:51   client-side lo_import() provided by libpq ? Emi Lu
• 20:56   Re: column type for pdf file Julien Cigar
• 21:00   Re: column type for pdf file Karsten Hilbert
• 21:21   Re: column type for pdf file Julien Cigar
• 21:28   Re: column type for pdf file Karsten Hilbert
• 21:38   Re: column type for pdf file Julien Cigar
• 22:22   Re: Sorting Issue Ozer, Pam
• 23:06   Re: column type for pdf file Eric McKeeth

19 May 2011

• 00:09   Re: foreign keys and lots of tables David W Noon
• 02:03   Re: client-side lo_import() provided by libpq ? Craig Ringer
• 02:15   Re: column type for pdf file Craig Ringer
• 06:00   Re: column type for pdf file Piotr Czekalski
• 08:39   Re: SOLVED - foreign keys and lots of tables Gary Stainburn
• 13:40   Re: column type for pdf file Emi Lu
• 14:03   Re: column type for pdf file Karsten Hilbert
• 14:30   Re: column type for pdf file Craig Ringer
• 17:48   Re: column type for pdf file Emi Lu

20 May 2011

• 20:15   unnest in SELECT Karl Koster

21 May 2011

• 06:59   Re: unnest in SELECT Andreas Kretschmer
• 22:32   Which version of PostgreSQL should I use. Gavin Baumanis
• 22:32   unnest in SELECT Karl Koster
• 23:46   Re: Which version of PostgreSQL should I use. Basil Bourque

22 May 2011

• 03:24   Re: unnest in SELECT Craig Ringer
• 20:08   extracting location info from string Tarlika Elisabeth Schmitz
• 22:08   Re: extracting location info from string Tarlika Elisabeth Schmitz

23 May 2011

• 01:11   Re: extracting location info from string Andrej
• 01:42   Re: extracting location info from string Craig Ringer
• 14:38   Re: Which version of PostgreSQL should I use. Gavin Baumanis
• 14:38   Re: extracting location info from string Lew
• 15:17   Re: extracting location info from string Edward W. Rouse
• 15:31   Re: Which version of PostgreSQL should I use. jasmin.dizdarevic@gmail.com
• 16:02   Re: extracting location info from string Tarlika Elisabeth Schmitz
• 16:54   problem with update data sets from front ends 8.4, Ubuntu 10.04 Dean le Roux
• 18:01   Re: problem with update data sets from front ends 8.4, Ubuntu 10.04 Samuel Gendler
• 21:23   Re: problem with update data sets from front ends 8.4, Ubuntu 10.04 Dean le Roux
• 23:08   Re: extracting location info from string Tarlika Elisabeth Schmitz
• 23:18   Re: Which version of PostgreSQL should I use. Craig Ringer

24 May 2011

• 00:59   Re: extracting location info from string Craig Ringer
• 01:05   Re: problem with update data sets from front ends 8.4, Ubuntu 10.04 Adrian Klaver
• 06:48   Re: Which version of PostgreSQL should I use. Craig Ringer
• 10:49   Re: Performance of NOT IN and <> with PG 9.0.4 Jasmin Dizdarevic
• 10:58   Re: Which version of PostgreSQL should I use. Jasmin Dizdarevic
• 11:45   Re: Performance of NOT IN and <> with PG 9.0.4 Jasmin Dizdarevic
• 19:23   Problems Pgdump manuel antonio ochoa
• 19:26   Re: Problems Pgdump manuel antonio ochoa
• 21:10   Re: Performance of NOT IN and <> with PG 9.0.4 Jasmin Dizdarevic

25 May 2011

• 01:56   Re: Which version of PostgreSQL should I use. Craig Ringer
• 02:07   Re: Problems Pgdump Craig Ringer
• 09:09   Re: extracting location info from string Lew
• 09:09   Re: Performance of NOT IN and <> with PG 9.0.4 Robert Haas
• 09:09   Re: Performance of NOT IN and <> with PG 9.0.4 Robert Haas
• 14:13   Re: Performance of NOT IN and <> with PG 9.0.4 Tom Lane
• 15:43   Re: extracting location info from string Rob Sargent
• 15:48   Re: Performance of NOT IN and <> with PG 9.0.4 Jasmin Dizdarevic
• 18:57   Re: extracting location info from string Tarlika Elisabeth Schmitz
• 21:38   Re: extracting location info from string Tarlika Elisabeth Schmitz
• 22:07   Re: extracting location info from string Rob Sargent
• 22:11   Re: [SQL] extracting location info from string Charlie
• 22:21   Re: extracting location info from string Andrej
• 22:29   Re: enum data type vs table Peter Koczan
• 22:35   Re: Sorting Issue Ozer, Pam
• 23:23   Re: enum data type vs table Seb

26 May 2011

• 18:08   Re: column type for pdf file Ross J. Reedstrom
• 21:08   Re: extracting location info from string Tarlika Elisabeth Schmitz

27 May 2011

• 16:39   Re: Performance of NOT IN and <> with PG 9.0.4 Robert Haas
• 17:09   Re: 500KB PDF files for postgresql8.3, which is the most efficient way? Emi Lu
• 17:09   500KB PDF files for postgresql8.3, which is the most efficient way? Emi Lu
• 19:28   Re: Re: 500KB PDF files for postgresql8.3, which is the most efficient way? Samuel Gendler
• 19:29   Order of evaluation in triggers for checks on inherited table partitions Kevin Crain
• 20:08   Re: Order of evaluation in triggers for checks on inherited table partitions Tarlika Elisabeth Schmitz

28 May 2011

• 08:14   Re: Re: 500KB PDF files for postgresql8.3, which is the most efficient way? Piotr Czekalski

29 May 2011

• 07:38   Function to total reset a schema Surfing
• 07:50   Re: Function to total reset a schema Scott Marlowe
• 07:54   Re: Function to total reset a schema Thomas Kellerer
• 08:03   Re: Function to total reset a schema Surfing

30 May 2011

• 20:20   Re: Function to total reset a schema Rob Sargent
• 20:23   Function to total reset a schema Surfing
• 21:02   Re: Order of evaluation in triggers for checks on inherited table partitions Jasen Betts

31 May 2011

• 14:10   Re: Re: Order of evaluation in triggers for checks on inherited table partitions Kevin Crain
• 14:59   Re: Re: Order of evaluation in triggers for checks on inherited table partitions Kevin Crain