pgsql-sql - July 2009

Discussion for users on SQL related matters.

Search the Archives

(enter a message-id to go directly to that message)
Advanced Search

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 7 8 9 10 13 14 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31

July 1, 2009

Thread Author Time
Re: it's not NULL, then what is it? Tena Sakai 00:55
Re: it's not NULL, then what is it? Tena Sakai 00:56
Re: it's not NULL, then what is it? Tena Sakai 00:58
Re: it's not NULL, then what is it? Tena Sakai 02:09
Re: it's not NULL, then what is it? Tom Lane 02:17
Re: it's not NULL, then what is it? Tena Sakai 03:40
Re: fsync and Windows XP Rainer Bauer 08:30
Re: it's not NULL, then what is it? Rob Sargent 16:36
Xpath() return xml[] Tamayo, Damian-p65828 16:40
Partitioned tables not using index for min and max 8.2.7? 📎 Tim Haak 16:42
Re: it's not NULL, then what is it? Tena Sakai 17:02
Re: it's not NULL, then what is it? Tom Lane 17:42
Re: Partitioned tables not using index for min and max 8.2.7? Tom Lane 17:44
Re: it's not NULL, then what is it? Tena Sakai 17:47

July 2, 2009

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

July 3, 2009

Thread Author Time
Re: Create custom aggregate function and custom sfunc nha 03:48
Re: Create custom aggregate function and custom sfunc Jasmin Dizdarevic 07:14
Sequences Andre Rothe 12:50
Re: Sequences Chris Browne 21:35

July 4, 2009

Thread Author Time
Re: Sequences Jasmin Dizdarevic 12:35
Re: Sequences Scott Marlowe 17:26
Re: Sequences Andre Rothe 20:50

July 7, 2009

Thread Author Time
Best way to simulate Booleans Peter Headland 01:22
Order of "WITH RECURSIVE" output Andreas Joseph Krogh 01:44
Re: Order of "WITH RECURSIVE" output Tom Lane 01:55
Re: Order of "WITH RECURSIVE" output Andreas Joseph Krogh 02:06
Re: Best way to simulate Booleans Scott Marlowe 06:13
Re: Best way to simulate Booleans Dirk Jagdmann 09:05
Re: Best way to simulate Booleans Simon Riggs 09:17
Re: Best way to simulate Booleans Greg Stark 09:26
Re: fsync and Windows XP Jon Norman 21:03
FW: Query length limitation in postgres server > 8.2.9 jacob 22:33

July 8, 2009

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

July 9, 2009

Thread Author Time
ERROR: function expression in FROM may not refer to other relations of same query level Joseph S 01:22
Re: ERROR: function expression in FROM may not refer to other relations of same query level Tom Lane 01:58
Re: Moving text columns, when it actually is large Richard Huxton 08:09
Re: FW: Query length limitation in postgres server > 8.2.9 jacob 17:53
Re: FW: Query length limitation in postgres server > 8.2.9 Hartman, Matthew 17:58
Re: FW: Query length limitation in postgres server > 8.2.9 Tom Lane 18:05
Re: FW: Query length limitation in postgres server > 8.2.9 jacob 18:10
Re: FW: Query length limitation in postgres server > 8.2.9 Tom Lane 18:13
Re: FW: Query length limitation in postgres server > 8.2.9 jacob 18:16
Re: FW: Query length limitation in postgres server > 8.2.9 jacob 18:20
Re: FW: Query length limitation in postgres server > 8.2.9 Tom Lane 18:28
Re: FW: Query length limitation in postgres server > 8.2.9 jacob 18:33
Re: FW: Query length limitation in postgres server > 8.2.9 Tom Lane 18:43

July 10, 2009

Thread Author Time
skip if latter value equal Marcin Krawczyk 07:22
Re: skip if latter value equal Pavel Stehule 07:35
Re: skip if latter value equal Marcin Krawczyk 07:45
How update a table within a join efficiently ? Andreas 08:07
Re: How update a table within a join efficiently ? Pavel Stehule 08:21
WITH RECURSION output ordering with trees Philippe Lang 09:10
Re: WITH RECURSION output ordering with trees Philippe Lang 11:09
Re: WITH RECURSION output ordering with trees Thomas Kellerer 11:23
Re: WITH RECURSION output ordering with trees Philippe Lang 11:50
Re: WITH RECURSION output ordering with trees Harald Fuchs 12:33
Re: WITH RECURSION output ordering with trees Philippe Lang 13:05

July 13, 2009

Thread Author Time
function returning a cursor and a scalar Surajit Bhattacharjee 03:07
simple join is beating me Gary Stainburn 10:34
Re: simple join is beating me Oliveiros 11:45
Re: simple join is beating me Gary Stainburn 13:12
Re: simple join is beating me Hartman, Matthew 13:23
Re: simple join is beating me Oliveiros 14:02
Re: function returning a cursor and a scalar Alvaro Herrera 18:21

July 14, 2009

Thread Author Time
Request new version to support "on commit drop" for create temp table ... as select ? Emi Lu 15:08
Re: function returning a cursor and a scalar Surajit Bhattacharjee 15:21
Re: Request new version to support "on commit drop" for create temp table ... as select ? Tom Lane 16:47
Re: Request new version to support "on commit drop" for create temp table ... as select ? Scott Marlowe 17:33
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 ? Emi Lu 18:52

July 16, 2009

Thread Author Time
Comparing a string against an XPath result set Tim Landscheidt 21:19

July 17, 2009

Thread Author Time
De-duplicating rows Christophe 03:07
Re: De-duplicating rows Richard Huxton 07:21
Re: De-duplicating rows Frank Bax 15:04
Re: De-duplicating rows Scott Marlowe 15:32

July 18, 2009

Thread Author Time
Timestamp with timezone with Default value Gianvito Pio 08:19
Re: Timestamp with timezone with Default value Jasmin Dizdarevic 10:25
Table inheritance problem Gianvito Pio 17:09

July 19, 2009

Thread Author Time
Re: Timestamp with timezone with Default value Jasen Betts 12:59

July 20, 2009

Thread Author Time
how to tell if column set on update chester c young 13:19
unused columns in copy chester c young 13:22
Re: Table inheritance problem Andreas Wenk 13:32
Storing/sorting hex data in PostgreSQL JJ 19:59
Re: unused columns in copy Marcin Stępnicki 22:59

July 21, 2009

Thread Author Time
Re: how to tell if column set on update nha 00:07
Re: unused columns in copy nha 00:20
Re: Storing/sorting hex data in PostgreSQL nha 11:14
Order of operations in ascii vs archive format (moderately urgent) Rob Sargent 16:27
Re: Order of operations in ascii vs archive format (moderately urgent) Tom Lane 16:49
Re: Order of operations in ascii vs archive format (moderately urgent) Rob Sargent 16:54
Re: Order of operations in ascii vs archive format (moderately urgent) Rob Sargent 17:24
Re: Order of operations in ascii vs archive format (moderately urgent) Tom Lane 17:29

July 22, 2009

Thread Author Time
Re: how to tell if column set on update chester c young 03:51
Re: how to tell if column set on update Frank Bax 11:42
Double aggregate problem David Weilers 16:16
Re: Double aggregate problem nha 17:45
Re: Double aggregate problem Peter Eisentraut 18:04

July 23, 2009

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

July 24, 2009

Thread Author Time
Re: Bit by "commands ignored until end of transaction block" again Craig Ringer 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 Alvaro Herrera 16:54
Re: Bit by "commands ignored until end of transaction block" again Joshua Tolley 18:09
Re: using count in other column nha 22:41
Re: using count in other column nha 23:13

July 25, 2009

Thread Author Time
Re: Need magical advice for counting NOTHING nha 00:26
Re: Need magical advice for counting NOTHING Andreas 20:46

July 26, 2009

Thread Author Time
Re: Bit by "commands ignored until end of transaction block" again Glenn Maynard 21:21
Re: Bit by "commands ignored until end of transaction block" again Science 23:15

July 27, 2009

Thread Author Time
Re: Bit by "commands ignored until end of transaction block" again Craig Ringer 00:00
Re: Bit by "commands ignored until end of transaction block" again Science 12:40

July 28, 2009

Thread Author Time
sql-porting-problem oracle to postgresql with UPDATE/IS NOT NULL Gau, Hans-Jürgen 09:58
Re: sql-porting-problem oracle to postgresql with UPDATE/IS NOT NULL Daryl Richter 12:25
Detect referential integrity structure Akos Gabriel 18:12
Re: Detect referential integrity structure Rob Sargent 20:08
Tweak sql result set... ? Axe 20:49
Re: sql-porting-problem oracle to postgresql with UPDATE/IS NOT NULL nha 21:10

July 29, 2009

Thread Author Time
Re: Tweak sql result set... ? Tim Landscheidt 00:24
Re: Tweak sql result set... ? Axe 06:35
WG: sql-porting-problem oracle to postgresql with UPDATE/IS NOT NULL Gau, Hans-Jürgen 09:48
Re: WG: sql-porting-problem oracle to postgresql with UPDATE/IS NOT NULL nha 10:21
Re: WG: sql-porting-problem oracle to postgresql with UPDATE/IS NOT NULL nha 11:03
Re: Tweak sql result set... ? Jasen Betts 12:39
Re: sql-porting-problem oracle to postgresql with UPDATE/IS NOT NULL Daryl Richter 13:44
WG: WG: sql-porting-problem oracle to postgresql with UPDAT E/IS NOT NULL Gau, Hans-Jürgen 16:08
Foreign keys and fixed values... Kjell Rune Skaaraas 20:16

July 30, 2009

Thread Author Time
SQL report wkipjohn 02:48
Re: Tweak sql result set... ? Jasmin Dizdarevic 07:53
SELECT max() group by problem Heigo Niilop 09:07
SELECT max(time) group by problem Heigo Niilop 09:38
Re: Tweak sql result set... ? Axe 13:31
Re: Tweak sql result set... ? Tim Landscheidt 14:19
Re: SQL report Rob Sargent 15:16
Re: Tweak sql result set... ? Rob Sargent 15:25
Re: Foreign keys and fixed values... Daryl Richter 15:33
Re: SQL report Steve Crawford 16:41
Show CAS, USD first; the left ordered by currency name Emi Lu 19:51
Re: Show CAS, USD first; the left ordered by currency name Andreas Kretschmer 20:05
Re: Show CAS, USD first; the left ordered by currency name sergey kapustin 20:06

July 31, 2009

Thread Author Time
Re: SQL report wkipjohn 00:08
Re: SELECT max(time) group by problem nha 00:46
Re: SQL report wkipjohn 03:55
Re: Show CAS, USD first; the left ordered by currency name Harald Fuchs 11:37
Re: Show CAS, USD first; the left ordered by currency name bricklen 13:27
Re: Show CAS, USD first; the left ordered by currency name Emi Lu 14:05
on error resume next Jasmin Dizdarevic 15:24
Re: SQL report Rob Sargent 15:50
Re: on error resume next Andreas Wenk 18:12
Re: on error resume next Jasmin Dizdarevic 18:52
How fetch multiple rows into one text-field? Andreas 20:09
Re: How fetch multiple rows into one text-field? Joshua Tolley 23:29

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 7 8 9 10 13 14 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31