pgsql-sql since 2009-05-28 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

May 28, 2009

Thread	Author	Time
exists and is not null equivalence in query	Raphael Bauduin	12:36
Re: exists and is not null equivalence in query	Tom Lane	15:19

June 1, 2009

Thread	Author	Time
Assigning data-entry tasks to multiple concurrent clients	Jamie Tufnell	03:54
Re: Assigning data-entry tasks to multiple concurrent clients	Jamie Tufnell	04:49
Re: Assigning data-entry tasks to multiple concurrent clients	Jamie Tufnell	05:02
Re: Assigning data-entry tasks to multiple concurrent clients	Jasen Betts	08:55
Re: Assigning data-entry tasks to multiple concurrent clients	Scott Marlowe	09:55
Avoiding "will create implicit index" NOTICE	Bryce Nesbitt	19:32
Re: Avoiding "will create implicit index" NOTICE	Scott Marlowe	20:07

June 2, 2009

Thread	Author	Time
Re: [SQL] proposal for a CookBook in postgresql.org	Bruce Momjian	20:28
Re: [SQL] proposal for a CookBook in postgresql.org	Alvaro Herrera	20:48
Re: [SQL] proposal for a CookBook in postgresql.org	Bruce Momjian	20:52
Re: [SQL] proposal for a CookBook in postgresql.org	Alvaro Herrera	21:10
complex column definition in query	Seb	22:16

June 3, 2009

Thread	Author	Time
Re: [SQL] proposal for a CookBook in postgresql.org	Bruce Momjian	00:56
Re: complex column definition in query	A. Kretschmer	05:04
Creation of file from postgresql function	Jyoti Seth	12:00
Re: Creation of file from postgresql function	A. Kretschmer	12:13
Re: complex column definition in query	Seb	12:53
Re: complex column definition in query	A. Kretschmer	13:23

June 4, 2009

Thread	Author	Time
page-base stats per query?	Rob Sargent	20:14

June 5, 2009

Thread	Author	Time
Type inheritance	Gianvito Pio	10:30
Re: Type inheritance	Tom Lane	13:48
do unneeded outer joins cost?	chester c young	15:01
Re: Type inheritance	Gianvito Pio	15:13
Re: do unneeded outer joins cost?	Tom Lane	15:25
Re: Type inheritance	Rob Sargent	16:38

June 6, 2009

Thread	Author	Time
Re: Type inheritance	Gianvito Pio	07:10
Re: Type inheritance	Jasen Betts	12:04
Re: Type inheritance	Gianvito Pio	14:18
Re: Type inheritance	Richard Broersma	14:30
Re: Type inheritance	Rob Sargent	15:11
Xml Schemas	Isaac Dover	19:53

June 8, 2009

Thread	Author	Time
'cost' and 'rows' for volitile function	Rob Sargent	16:26
Re: [SQL] 'cost' and 'rows' for volitile function	Richard Huxton	17:16
Re: 'cost' and 'rows' for volitile function	Richard Huxton	17:34
Re: 'cost' and 'rows' for volitile function	Richard Huxton	17:57
Re: Xml Schemas	Peter Eisentraut	20:53

June 9, 2009

Thread	Author	Time
pg_restore	Jyoti Seth	09:32
backup	Jyoti Seth	09:53
Re: backup	Ashish Karalkar	10:02
Re: backup	Jasen Betts	12:33
Taking the cache out of the equation?	Rob Sargent	17:51

June 10, 2009

Thread	Author	Time
Re: backup	Jyoti Seth	05:08
Re: backup	Jyoti Seth	05:46
Re: backup	Gurjeet Singh	05:50
Re: backup	Abbas	06:02
setting the where clause	johnf	12:19
Re: setting the where clause	Tom Lane	14:19
Re: setting the where clause	Rob Sargent	15:13

June 11, 2009

Thread	Author	Time
Re: Avoiding "will create implicit index" NOTICE	Bryce Nesbitt	06:20
Re: Avoiding "will create implicit index" NOTICE	Bryce Nesbitt	07:03
Re: Avoiding "will create implicit index" NOTICE	A. Kretschmer	07:31
dynamic columns in a query	Jyoti Seth	07:42
Re: dynamic columns in a query	A. Kretschmer	07:53
Re: dynamic columns in a query	Pavel Stehule	08:54
Re: Avoiding "will create implicit index" NOTICE	Rob Sargent	16:05
polymorphic function in 7.4 vs. 8.3	Richard Rosenberg	20:16
Re: polymorphic function in 7.4 vs. 8.3	Tom Lane	20:39
Re: polymorphic function in 7.4 vs. 8.3	Richard Rosenberg	21:42
Re: polymorphic function in 7.4 vs. 8.3	Tom Lane	21:49
Re: polymorphic function in 7.4 vs. 8.3	Richard Rosenberg	23:02
Re: polymorphic function in 7.4 vs. 8.3	Rob Sargent	23:16

June 12, 2009

Thread	Author	Time
Re: setting the where clause	Jasen Betts	12:33
Find periods for a given... action set?	Mario Splivalo	12:54
Re: Find periods for a given... action set?	Achilleas Mantzios	13:42
updateable/insertable view having left joined tables	Seb	21:35
Re: Taking the cache out of the equation?	Erik Jones	22:12
Re: Taking the cache out of the equation?	Greg Stark	22:25

June 13, 2009

Thread	Author	Time
Re: updateable/insertable view having left joined tables	Seb	00:22
drop PW	Mark Fenbers	20:51
Re: drop PW	Joshua Tolley	20:55
Re: drop PW	Andy Shellam	23:56

June 15, 2009

Thread	Author	Time
PHP pg_escape_string	Zdravko Balorda	08:14
Re: PHP pg_escape_string	Andy Shellam	16:10

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

Browse Archives

Prev | Next