Mailing lists [pgsql-sql]

1 October 2008

• 01:07   Re: Can COPY update or skip existing records? Rafael Domiciano
• 02:27   Re: Can COPY update or skip existing records? Gurjeet Singh
• 02:30   Re: Can COPY update or skip existing records? Scott Marlowe
• 15:07   Accessing elements of bytea[] always returns NULL Sestak, John S
• 15:47   Re: Accessing elements of bytea[] always returns NULL Tom Lane
• 16:33   Re: Can COPY update or skip existing records? Tony Wasson

2 October 2008

• 20:50   Query how-to Montaseri
• 21:10   Re: Query how-to Richard Broersma
• 22:05   Re: Query how-to Frank Bax

3 October 2008

• 12:22   Re: Query how-to Marc Mamin
• 19:03   For each key, find row with highest value of other field Raj Mathur
• 19:11   Re: For each key, find row with highest value of other field Oliveiros Cristina
• 19:20   Re: For each key, find row with highest value of other field Fernando Hevia
• 19:56   Re: For each key, find row with highest value of other field Mark Roberts
• 20:29   Re: Query how-to Marc Mamin

6 October 2008

• 13:08   many-to-many relationship Louis-David Mitterrand
• 13:37   Re: many-to-many relationship Dave Steinberg
• 15:35   Re: many-to-many relationship Louis-David Mitterrand
• 21:03   pg_dump more than one table in one command? Emi Lu
• 21:24   Re: pg_dump more than one table in one command? Harold A. Giménez Ch.
• 21:48   Re: pg_dump more than one table in one command? Scott Marlowe
• 21:52   Re: pg_dump more than one table in one command? Harold A. Giménez Ch.

7 October 2008

• 07:28   Array from INSERT .. RETURNING in plpgsql? Erik Jones
• 07:55   Re: Array from INSERT .. RETURNING in plpgsql? Pavel Stehule

8 October 2008

• 00:16   Re: many-to-many relationship Steve Midgley
• 14:53   Re: many-to-many relationship Louis-David Mitterrand
• 17:07   100% CPU at concurent access Sabin Coanda
• 23:13   Re: 100% CPU at concurent access Tom Lane

9 October 2008

• 06:20   Re: Insert a space between each character Dirk Jagdmann
• 07:11   trigger parameters, what am I doing wrong ?? Marcin Krawczyk
• 09:38   Re: 100% CPU at concurent access Sabin Coanda
• 16:31   sequence number in a result Campbell, Lance
• 16:48   Re: sequence number in a result Oliveiros Cristina
• 16:50   Re: sequence number in a result Oliveiros Cristina
• 17:14   Re: sequence number in a result Tom Lane
• 17:22   Re: trigger parameters, what am I doing wrong ?? Tom Lane
• 17:24   Re: sequence number in a result Relyea, Mike
• 19:17   Re: many-to-many relationship Steve Midgley

10 October 2008

• 07:06   Re: trigger parameters, what am I doing wrong ?? Bart Degryse
• 11:38   Re: 100% CPU at concurent access Sabin Coanda
• 12:33   replicating a table in several databases Gerardo Herzig
• 15:38   Re: replicating a table in several databases Chris Browne
• 16:17   Problem with delete trigger: how to allow only triggers to delete a row? Christopher Maier
• 17:24   Re: Problem with delete trigger: how to allow only triggers to delete a row? aklaver@comcast.net (Adrian Klaver)
• 17:57   Re: Problem with delete trigger: how to allow only triggers to delete a row? Christopher Maier
• 18:05   Re: Problem with delete trigger: how to allow only triggers to delete a row? Alvaro Herrera
• 18:26   Re: Problem with delete trigger: how to allow only triggers to delete a row? Christopher Maier
• 18:39   Re: Problem with delete trigger: how to allow only triggers to delete a row? Alvaro Herrera
• 20:18   SELECT multiple MAX(id)s ? Aarni Ruuhimäki
• 20:53   Re: Problem with delete trigger: how to allow only triggers to delete a row? Tom Lane
• 20:57   Re: Problem with delete trigger: how to allow only triggers to delete a row? Adrian Klaver
• 21:16   Re: Problem with delete trigger: how to allow only triggers to delete a row? Christopher Maier
• 22:10   Re: Problem with delete trigger: how to allow only triggers to delete a row? Adrian Klaver

11 October 2008

• 11:22   EXISTS Denis Woodbury
• 12:32   Re: EXISTS Leif B. Kristensen
• 17:32   Re: EXISTS Tom Lane

13 October 2008

• 18:16   Order of trigger execution: AFTER DELETE ON EACH ROW doesn't appear to be working properly Christopher Maier
• 18:21   Re: Problem with delete trigger: how to allow only triggers to delete a row? Christopher Maier
• 18:30   Re: Order of trigger execution: AFTER DELETE ON EACH ROW doesn't appear to be working properly Tom Lane
• 19:08   Re: Order of trigger execution: AFTER DELETE ON EACH ROW doesn't appear to be working properly aklaver@comcast.net (Adrian Klaver)
• 19:23   Updating Query of 1 table from data in another Chris Preston
• 19:52   Re: Updating Query of 1 table from data in another Scott Marlowe
• 20:12   Re: Order of trigger execution: AFTER DELETE ON EACH ROW doesn't appear to be working properly Christopher Maier

14 October 2008

• 07:49   Re: EXISTS Craig Ringer
• 14:04   Re: EXISTS Denis Woodbury
• 15:26   Re: SELECT multiple MAX(id)s ? Fernando Hevia
• 22:52   effectiveness tool Judith Altamirano
• 23:54   Re: effectiveness tool Adrian Klaver

15 October 2008

• 00:01   Re: effectiveness tool Scott Marlowe
• 00:14   Re: replicating a table in several databases Scott Marlowe
• 01:10   Re: replicating a table in several databases zouguanghui
• 07:40   Re: effectiveness tool Stefano Buliani
• 14:26   Re: Updating Query of 1 table from data in another Scott Marlowe

16 October 2008

• 01:47   Most efficient way to achieve this ts_query Jamie Tufnell
• 03:49   Re: Most efficient way to achieve this ts_query Frank Bax
• 04:01   Search fields in multiple tables Raj Mathur
• 04:49   Re: Most efficient way to achieve this ts_query Jamie Tufnell
• 14:03   Re: Search fields in multiple tables Oliveiros Cristina

17 October 2008

• 11:53   returning count(*) when it is > 1, else -1 Gerardo Herzig
• 12:01   Re: returning count(*) when it is > 1, else -1 Pavel Stehule
• 12:01   Re: returning count(*) when it is > 1, else -1 Richard Huxton
• 12:19   Re: returning count(*) when it is > 1, else -1 Gerardo Herzig
• 12:29   Re: returning count(*) when it is > 1, else -1 Achilleas Mantzios
• 12:32   Re: returning count(*) when it is > 1, else -1 Tom Lane
• 12:35   Re: returning count(*) when it is > 1, else -1 Gerardo Herzig
• 12:58   Re: returning count(*) when it is > 1, else -1 Gerardo Herzig

20 October 2008

• 08:30   my rules wont execute aldy
• 13:24   generating date sequences Patrick Scharrenberg
• 13:41   Re: generating date sequences A. Kretschmer
• 13:55   Re: generating date sequences Patrick Scharrenberg
• 19:49   Full Text Index Stats Ryan Hansen

22 October 2008

• 05:14   grouping/clustering query David Garamond

23 October 2008

• 06:52   Re: Full Text Index Stats Oleg Bartunov
• 08:14   Postgres-sql-php Zied Kharrat
• 10:00   Re: SELECT multiple MAX(id)s ? Aarni
• 10:28   Re: Postgres-sql-php Oliveiros Cristina
• 12:46   Re: Postgres-sql-php Zied Kharrat
• 13:26   Re: Postgres-sql-php Oliveiros Cristina
• 16:09   Re: grouping/clustering query Steve Midgley
• 18:01   Re: Postgres-sql-php Oliveiros Cristina
• 22:18   Re: grouping/clustering query Joe

24 October 2008

• 15:04   Re: grouping/clustering query Steve Midgley
• 15:20   Re: grouping/clustering query Oliveiros Cristina
• 17:25   Re: grouping/clustering query Tony Wasson
• 20:48   Re: grouping/clustering query Tony Wasson

25 October 2008

• 01:50   Re: grouping/clustering query David Garamond
• 06:44   Truncate on pg_dump / pg_restore Bryce Nesbitt
• 10:18   Re: Truncate on pg_dump / pg_restore chris smith
• 15:23   Re: Truncate on pg_dump / pg_restore Bryce Nesbitt
• 15:36   Re: Truncate on pg_dump / pg_restore Harold A. Giménez Ch.

26 October 2008

• 18:22   how to sum entries from the last entry to some entry in between dynamically? Devil™ Dhuvader

27 October 2008

• 07:19   SQL Statement Missing From Log Bryce Nesbitt
• 12:15   Re: SQL Statement Missing From Log Tom Lane
• 16:32   How to hand over array as variable in plpgsql function? Jan Peters
• 19:28   Fwd: grouping/clustering query Osvaldo Kussama
• 19:46   Re: How to hand over array as variable in plpgsql function? Tom Lane

28 October 2008

• 08:23   Re: How to hand over array as variable in plpgsql function? Jan Peters
• 11:14   Performing intersection without intersect operator Nacef LABIDI
• 11:51   Re: Performing intersection without intersect operator Oliveiros Cristina
• 11:59   Re: Performing intersection without intersect operator Peter Eisentraut
• 12:31   Re: How to hand over array as variable in plpgsql function? Tom Lane
• 20:02   join table? Michael Higgins

29 October 2008

• 09:30   Comparing sequential rows in a result Murray Long
• 09:33   Re: Comparing sequential rows in a result Murray Long
• 17:45   simple SQL query Kevin Duffy
• 19:58   Re: simple SQL query Andreas Joseph Krogh
• 20:56   Re: simple SQL query Kevin Duffy
• 21:50   Re: simple SQL query Andreas Joseph Krogh
• 22:00   trying to repair a bad header block gherzig@fmed.uba.ar
• 22:23   Re: trying to repair a bad header block Tom Lane
• 22:29   Re: trying to repair a bad header block Scott Marlowe

30 October 2008

• 00:36   Re: trying to repair a bad header block Tom Lane
• 01:24   Re: trying to repair a bad header block Scott Marlowe
• 01:25   Re: trying to repair a bad header block Scott Marlowe
• 02:31   Re: simple SQL query Tom Lane
• 10:27   Re: trying to repair a bad header block gherzig@fmed.uba.ar
• 10:29   Re: trying to repair a bad header block gherzig@fmed.uba.ar
• 12:34   Subqueries Pascal Tufenkji
• 12:49   Re: Subqueries Oliveiros Cristina
• 12:53   Re: Subqueries Helio Campos Mello de Andrade
• 20:49   Date Index Ryan Hansen
• 21:06   Re: Date Index Scott Marlowe

31 October 2008

• 07:49   Re: Date Index A. Kretschmer
• 09:26   Re: Subqueries Pascal Tufenkji
• 10:58   Re: Subqueries Gregory Stark