Mailing lists [pgsql-sql]

1 July 2009

• 00:55   Re: it's not NULL, then what is it? Tena Sakai
• 00:57   Re: it's not NULL, then what is it? Tena Sakai
• 01:02   Re: it's not NULL, then what is it? Tena Sakai
• 02:09   Re: it's not NULL, then what is it? Tena Sakai
• 02:17   Re: it's not NULL, then what is it? Tom Lane
• 03:44   Re: it's not NULL, then what is it? Tena Sakai
• 16:36   Re: it's not NULL, then what is it? Rob Sargent
• 16:51   Xpath() return xml[] Tamayo, Damian-p65828
• 17:02   Re: it's not NULL, then what is it? Tena Sakai
• 17:16   Partitioned tables not using index for min and max 8.2.7? Tim Haak
• 17:42   Re: it's not NULL, then what is it? Tom Lane
• 17:44   Re: Partitioned tables not using index for min and max 8.2.7? Tom Lane
• 17:52   Re: it's not NULL, then what is it? Tena Sakai

2 July 2009

• 09:31   Re: Partitioned tables not using index for min and max 8.2.7? Tim Haak
• 14:48   Create custom aggregate function and custom sfunc Jasmin Dizdarevic
• 17:37   Re: Create custom aggregate function and custom sfunc justin
• 21:21   Re: Create custom aggregate function and custom sfunc Greg Stark

3 July 2009

• 04:04   Re: Create custom aggregate function and custom sfunc nha
• 07:14   Re: Create custom aggregate function and custom sfunc Jasmin Dizdarevic

4 July 2009

• 11:12   Re: Sequences Chris Browne
• 12:35   Re: Sequences Jasmin Dizdarevic
• 17:26   Re: Sequences Scott Marlowe

7 July 2009

• 01:44   Order of "WITH RECURSIVE" output Andreas Joseph Krogh
• 01:55   Re: Order of "WITH RECURSIVE" output Tom Lane
• 02:06   Re: Order of "WITH RECURSIVE" output Andreas Joseph Krogh
• 03:54   Recording how a table is used Daniel Gordon
• 03:54   Re: fsync and Windows XP Rainer Bauer
• 03:55   Sequences Andre Rothe
• 03:55   Best way to simulate Booleans Peter Headland
• 03:56   Re: Sequences Andre Rothe
• 06:14   Re: Best way to simulate Booleans Scott Marlowe
• 09:05   Re: Best way to simulate Booleans Dirk Jagdmann
• 09:17   Re: Best way to simulate Booleans Simon Riggs
• 09:27   Re: Best way to simulate Booleans Greg Stark
• 21:03   Re: fsync and Windows XP Jon Norman
• 23:06   FW: Query length limitation in postgres server > 8.2.9 

8 July 2009

• 00:43   Re: FW: Query length limitation in postgres server > 8.2.9 Greg Stark
• 00:58   Re: FW: Query length limitation in postgres server > 8.2.9 Tom Lane
• 09:31   Re: Recording how a table is used nha
• 11:21   Re: Recording how a table is used nha
• 21:19   Moving text columns, when it actually is large Rob Sargent

9 July 2009

• 01:44   ERROR: function expression in FROM may not refer to other relations of same query level Joseph S
• 01:59   Re: ERROR: function expression in FROM may not refer to other relations of same query level Tom Lane
• 08:09   Re: Moving text columns, when it actually is large Richard Huxton
• 17:55   Re: FW: Query length limitation in postgres server > 8.2.9 
• 18:04   Re: FW: Query length limitation in postgres server > 8.2.9 Hartman, Matthew
• 18:05   Re: FW: Query length limitation in postgres server > 8.2.9 Tom Lane
• 18:10   Re: FW: Query length limitation in postgres server > 8.2.9 
• 18:14   Re: FW: Query length limitation in postgres server > 8.2.9 Tom Lane
• 18:16   Re: FW: Query length limitation in postgres server > 8.2.9 
• 18:20   Re: FW: Query length limitation in postgres server > 8.2.9 
• 18:29   Re: FW: Query length limitation in postgres server > 8.2.9 Tom Lane
• 18:33   Re: FW: Query length limitation in postgres server > 8.2.9 
• 18:44   Re: FW: Query length limitation in postgres server > 8.2.9 Tom Lane

10 July 2009

• 07:23   skip if latter value equal Marcin Krawczyk
• 07:35   Re: skip if latter value equal Pavel Stehule
• 07:46   Re: skip if latter value equal Marcin Krawczyk
• 08:14   How update a table within a join efficiently ? Andreas
• 08:22   Re: How update a table within a join efficiently ? Pavel Stehule
• 09:46   WITH RECURSION output ordering with trees Philippe Lang
• 11:23   Re: WITH RECURSION output ordering with trees Philippe Lang
• 11:23   Re: WITH RECURSION output ordering with trees Thomas Kellerer
• 12:04   Re: WITH RECURSION output ordering with trees Philippe Lang
• 12:34   Re: WITH RECURSION output ordering with trees Harald Fuchs
• 13:20   Re: WITH RECURSION output ordering with trees Philippe Lang

13 July 2009

• 03:33   function returning a cursor and a scalar Surajit Bhattacharjee
• 11:15   simple join is beating me Gary Stainburn
• 11:46   Re: simple join is beating me Oliveiros
• 13:12   Re: simple join is beating me Gary Stainburn
• 13:23   Re: simple join is beating me Hartman, Matthew
• 14:02   Re: simple join is beating me Oliveiros
• 18:27   Re: function returning a cursor and a scalar Alvaro Herrera

14 July 2009

• 16:18   Re: function returning a cursor and a scalar Surajit Bhattacharjee
• 16:30   Request new version to support "on commit drop" for create temp table ... as select ? Emi Lu
• 17:18   Re: Request new version to support "on commit drop" for create temp table ... as select ? Tom Lane
• 17:38   Re: Request new version to support "on commit drop" for create temp table ... as select ? Scott Marlowe
• 17:41   Re: Request new version to support "on commit drop" for create temp table ... as select ? Tom Lane
• 18:52   Re: Request new version to support "on commit drop" for create temp table ... as select ? Emi Lu

16 July 2009

• 23:40   Comparing a string against an XPath result set Tim Landscheidt

17 July 2009

• 03:14   De-duplicating rows Christophe
• 07:21   Re: De-duplicating rows Richard Huxton
• 15:14   Re: De-duplicating rows Frank Bax
• 15:33   Re: De-duplicating rows Scott Marlowe

18 July 2009

• 08:20   Timestamp with timezone with Default value Gianvito Pio
• 10:25   Re: Timestamp with timezone with Default value Jasmin Dizdarevic
• 17:09   Table inheritance problem Gianvito Pio

19 July 2009

• 13:00   Re: Timestamp with timezone with Default value Jasen Betts

20 July 2009

• 13:19   how to tell if column set on update chester c young
• 13:23   unused columns in copy chester c young
• 13:33   Re: Table inheritance problem Andreas Wenk
• 23:02   Re: unused columns in copy Marcin Stępnicki

21 July 2009

• 00:09   Re: how to tell if column set on update nha
• 00:31   Re: unused columns in copy nha
• 01:32   Storing/sorting hex data in PostgreSQL JJ
• 11:33   Re: Storing/sorting hex data in PostgreSQL nha
• 16:27   Order of operations in ascii vs archive format (moderately urgent) Rob Sargent
• 16:50   Re: Order of operations in ascii vs archive format (moderately urgent) Tom Lane
• 16:55   Re: Order of operations in ascii vs archive format (moderately urgent) Rob Sargent
• 17:27   Re: Order of operations in ascii vs archive format (moderately urgent) Rob Sargent
• 17:29   Re: Order of operations in ascii vs archive format (moderately urgent) Tom Lane

22 July 2009

• 03:51   Re: how to tell if column set on update chester c young
• 11:42   Re: how to tell if column set on update Frank Bax
• 16:22   Double aggregate problem David Weilers
• 18:40   Re: Double aggregate problem Peter Eisentraut
• 19:01   Re: Double aggregate problem nha

23 July 2009

• 01:25   Re: Double aggregate problem nha
• 01:43   Re: how to tell if column set on update nha
• 05:01   Need magical advice for counting NOTHING Andreas
• 05:06   Bit by "commands ignored until end of transaction block" again Glenn Maynard
• 05:31   Re: Bit by "commands ignored until end of transaction block" again Richard Huxton
• 06:11   Re: Bit by "commands ignored until end of transaction block" again Glenn Maynard
• 06:41   Re: Bit by "commands ignored until end of transaction block" again Richard Huxton
• 06:46   Re: Need magical advice for counting NOTHING Shane Ambler
• 06:47   Re: Bit by "commands ignored until end of transaction block" again Joshua Tolley
• 06:58   Re: Need magical advice for counting NOTHING A. Kretschmer
• 07:07   Re: Bit by "commands ignored until end of transaction block" again Chris
• 07:18   Re: Need magical advice for counting NOTHING A. Kretschmer
• 07:32   Re: Bit by "commands ignored until end of transaction block" again Thomas Kellerer
• 07:39   Re: Bit by "commands ignored until end of transaction block" again Glenn Maynard
• 08:05   Re: Double aggregate problem David Weilers
• 08:07   Re: Bit by "commands ignored until end of transaction block" again Richard Huxton
• 08:23   Re: Need magical advice for counting NOTHING Glenn Maynard
• 10:56   Re: Bit by "commands ignored until end of transaction block" again Stephen Frost
• 14:20   Re: Bit by "commands ignored until end of transaction block" again Adrian Klaver
• 20:56   using count in other column bartjoosen

24 July 2009

• 09:43   Re: Bit by "commands ignored until end of transaction block" again Craig Ringer
• 09:52   Re: Bit by "commands ignored until end of transaction block" again Craig Ringer
• 16:56   Re: Bit by "commands ignored until end of transaction block" again Alvaro Herrera
• 18:10   Re: Bit by "commands ignored until end of transaction block" again Joshua Tolley
• 22:42   Re: using count in other column nha
• 23:14   Re: using count in other column nha

25 July 2009

• 00:27   Re: Need magical advice for counting NOTHING nha
• 20:46   Re: Need magical advice for counting NOTHING Andreas

26 July 2009

• 21:28   Re: Bit by "commands ignored until end of transaction block" again Glenn Maynard
• 23:15   Re: Bit by "commands ignored until end of transaction block" again Science

27 July 2009

• 00:01   Re: Bit by "commands ignored until end of transaction block" again Craig Ringer
• 12:40   Re: Bit by "commands ignored until end of transaction block" again Science

28 July 2009

• 10:28   sql-porting-problem oracle to postgresql with UPDATE/IS NOT NULL Gau, Hans-Jürgen
• 12:26   Re: sql-porting-problem oracle to postgresql with UPDATE/IS NOT NULL Daryl Richter
• 18:28   Detect referential integrity structure Akos Gabriel
• 20:09   Re: Detect referential integrity structure Rob Sargent
• 21:13   Re: sql-porting-problem oracle to postgresql with UPDATE/IS NOT NULL nha
• 23:39   Tweak sql result set... ? Axe

29 July 2009

• 00:24   Re: Tweak sql result set... ? Tim Landscheidt
• 09:48   WG: sql-porting-problem oracle to postgresql with UPDATE/IS NOT NULL Gau, Hans-Jürgen
• 10:28   Re: WG: sql-porting-problem oracle to postgresql with UPDATE/IS NOT NULL nha
• 11:05   Re: WG: sql-porting-problem oracle to postgresql with UPDATE/IS NOT NULL nha
• 12:41   Re: Tweak sql result set... ? Jasen Betts
• 13:44   Re: sql-porting-problem oracle to postgresql with UPDATE/IS NOT NULL Daryl Richter
• 16:09   WG: WG: sql-porting-problem oracle to postgresql with UPDAT E/IS NOT NULL Gau, Hans-Jürgen

30 July 2009

• 03:18   Re: Tweak sql result set... ? Axe
• 03:19   Foreign keys and fixed values... Kjell Rune Skaaraas
• 03:19   SQL report wkipjohn@gmail.com
• 07:53   Re: Tweak sql result set... ? Jasmin Dizdarevic
• 09:38   SELECT max(time) group by problem Heigo Niilop
• 14:19   Re: Tweak sql result set... ? Tim Landscheidt
• 15:16   Re: SQL report Rob Sargent
• 15:26   Re: Tweak sql result set... ? Rob Sargent
• 15:35   Re: Foreign keys and fixed values... Daryl Richter
• 16:07   SELECT max() group by problem Heigo Niilop
• 16:38   SELECT max(time) group by problem Heigo Niilop
• 16:42   Re: SQL report Steve Crawford
• 19:51   Show CAS, USD first; the left ordered by currency name Emi Lu
• 20:05   Re: Show CAS, USD first; the left ordered by currency name Andreas Kretschmer
• 20:06   Re: Show CAS, USD first; the left ordered by currency name sergey kapustin

31 July 2009

• 00:48   Re: SELECT max(time) group by problem nha
• 11:37   Re: Show CAS, USD first; the left ordered by currency name Harald Fuchs
• 13:28   Re: Show CAS, USD first; the left ordered by currency name bricklen
• 14:10   Re: Show CAS, USD first; the left ordered by currency name Emi Lu
• 15:24   on error resume next Jasmin Dizdarevic
• 15:50   Re: SQL report Rob Sargent
• 18:16   Re: on error resume next Andreas Wenk
• 18:52   Re: on error resume next Jasmin Dizdarevic
• 20:03   How fetch multiple rows into one text-field? Andreas
• 23:30   Re: How fetch multiple rows into one text-field? Joshua Tolley