pgsql-sql since 2009-06-16 00:00

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

June 16, 2009

Thread Author Time
left outer join on more than 2 tables? Carol Cheung 20:59
Re: left outer join on more than 2 tables? Richard Broersma 21:25
Re: left outer join on more than 2 tables? (UNCLASSIFIED) Hall, Crystal M CTR DISA JITC 21:27
Re: left outer join on more than 2 tables? Gavin Baumanis 21:39
Re: left outer join on more than 2 tables? Rob Sargent 21:40
Re: left outer join on more than 2 tables? (UNCLASSIFIED) Hall, Crystal M CTR DISA JITC 21:52
Re: left outer join on more than 2 tables? Richard Broersma 22:45
Re: left outer join on more than 2 tables? Richard Broersma 22:50
Re: left outer join on more than 2 tables? (UNCLASSIFIED) Richard Broersma 22:54
Re: left outer join on more than 2 tables? Rob Sargent 23:12

June 17, 2009

Thread Author Time
Re: left outer join on more than 2 tables? Carol Cheung 13:07
Re: left outer join on more than 2 tables? (UNCLASSIFIED) Hall, Crystal M CTR DISA JITC 15:06
Trapping statement timeout Kevin Duffy 20:26

June 18, 2009

Thread Author Time
2 tables or two db? ivan marchesini 15:22
Re: 2 tables or two db? Rob Sargent 15:32

June 19, 2009

Thread Author Time
SQL File in encrypted form Jyoti Seth 10:40
Re: SQL File in encrypted form Jasen Betts 13:36

June 23, 2009

Thread Author Time
Re: Find periods for a given... action set? James Kitambara 06:56
Composite primary keys Harald Fuchs 15:14
Re: Composite primary keys Tom Lane 15:26
Re: Composite primary keys Oliveiros Cristina 15:32
Re: Composite primary keys Joshua Tolley 18:44
Re: Composite primary keys Tom Lane 19:15
Client-side compression Rob Sargent 20:30

June 24, 2009

Thread Author Time
Re: Composite primary keys Harald Fuchs 08:37
Re: Client-side compression Jasen Betts 12:13
Re: Client-side compression Filip Rembiałkowski 15:08
Bucketing Row Data in columns Sandeep 16:39

June 25, 2009

Thread Author Time
Re: Bucketing Row Data in columns James Kitambara 08:55
Re: Bucketing Row Data in columns Oliveiros Cristina 10:37
Re: Bucketing Row Data in columns Rob Sargent 15:57
Re: Bucketing Row Data in columns Oliveiros Cristina 16:13
Re: Bucketing Row Data in columns Osvaldo Kussama 17:37
Re: Bucketing Row Data in columns bricklen 20:02

June 26, 2009

Thread Author Time
.psql_history": No such file ivan marchesini 15:53
Re: .psql_history": No such file Tom Lane 16:11
Re: .psql_history": No such file Guillaume Lelarge 16:14
Re: [pgsql-sql] Daily digest v1.3050 (5 messages) Science 17:34

June 27, 2009

Thread Author Time
Re: .psql_history": No such file Shane Ambler 15:34

June 29, 2009

Thread Author Time
uniqueness constraint with NULLs Robert Edwards 05:42
Re: uniqueness constraint with NULLs A. Kretschmer 06:26
Re: uniqueness constraint with NULLs Robert Edwards 07:08
Re: uniqueness constraint with NULLs Leo Mannhart 07:23
Re: .psql_history": No such file ivan marchesini 07:47
Re: uniqueness constraint with NULLs A. Kretschmer 08:02
Re: uniqueness constraint with NULLs A. Kretschmer 08:20
date_trunc should be called date_round? Mario Splivalo 08:47
Re: uniqueness constraint with NULLs Craig Ringer 11:32
Re: uniqueness constraint with NULLs Tom Lane 14:01
Re: date_trunc should be called date_round? Tom Lane 14:25

June 30, 2009

Thread Author Time
Re: uniqueness constraint with NULLs Robert Edwards 00:22
Re: uniqueness constraint with NULLs Craig Ringer 01:29
Recording how a table is used Daniel Gordon 06:47
Re: date_trunc should be called date_round? Mario Splivalo 06:51
fsync and Windows XP Jon Norman 16:43
it's not NULL, then what is it? Tena Sakai 22:02
Re: it's not NULL, then what is it? Edward W. Rouse 22:22
Re: it's not NULL, then what is it? Rob Sargent 22:24
Re: it's not NULL, then what is it? Steve Crawford 22:39
Re: it's not NULL, then what is it? Thomas Kellerer 22:41

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

Browse Archives

Prev | Next