Home > mailing lists

Mailing lists [pgsql-sql]

1 January 2008

01:07 Re: Limit # of recs on inner join? Rodrigo E. De León Plicet
04:25 Re: Limit # of recs on inner join? Richard Broersma Jr
04:51 Using rules to implement backward-compatible schema changes Mario Becroft
06:09 Re: Using rules to implement backward-compatible schema changes Tom Lane
06:40 Re: Using rules to implement backward-compatible schema changes Mario Becroft
13:28 Re: EPOCH TIMESTAMP Conversion Problem Louis-David Mitterrand
18:03 Re: EPOCH TIMESTAMP Conversion Problem Tom Lane
18:33 Re: EPOCH TIMESTAMP Conversion Problem Michael Glaesemann

2 January 2008

17:43 PG is in different timezone than the OS Fernando Hevia
19:06 Re: PG is in different timezone than the OS Scott Marlowe
19:27 Re: PG is in different timezone than the OS Scott Marlowe
19:28 Re: Argentinian timezone change at the last moment. How to change pgsql tz db? Scott Marlowe
19:50 Re: Argentinian timezone change at the last moment. How to change pgsql tz db? Joe
22:29 Re: Argentinian timezone change at the last moment. How to change pgsql tz db? Scott Marlowe
22:45 Re: Argentinian timezone change at the last moment. How to change pgsql tz db? Tom Lane

3 January 2008

11:27 Re: Argentinian timezone change at the last moment. How to change pgsql tz db? Fernando Hevia
18:29 WAL archiving blowed. Gerardo Herzig

4 January 2008

02:57 Re: Argentinian timezone change at the last moment. How to change pgsql tz db? Fernando Hevia
03:38 Re: Argentinian timezone change at the last moment. How to change pgsql tz db? Tom Lane
13:00 Re: Argentinian timezone change at the last moment. How to change pgsql tz db? Fernando Hevia

6 January 2008

13:15 tsearch2: ts_headline performance problem Anders Østergaard Jensen
14:09 Re: tsearch2: ts_headline performance problem Oleg Bartunov

7 January 2008

12:16 reading WAL files in python Gerardo Herzig
13:10 Re: reading WAL files in python C." Bergström
13:22 Re: reading WAL files in python Gerardo Herzig
15:02 Cheers for DISTINCT ON Peter Kovacs
15:24 Re: Cheers for DISTINCT ON Andrew Sullivan
15:33 Re: Cheers for DISTINCT ON Bruce Momjian
17:22 Re: Cheers for DISTINCT ON Chris Browne
17:22 Re: Cheers for DISTINCT ON Chris Browne
17:35 Re: Cheers for DISTINCT ON Andrew Sullivan
17:55 Re: reading WAL files in python Erik Jones
19:47 Re: reading WAL files in python gherzig@fmed.uba.ar
21:04 Get the max(value1, value2, value3) from a table Emi Lu
21:16 Re: Get the max(value1, value2, value3) from a table Scott Marlowe
21:27 Re: Get the max(value1, value2, value3) from a table Richard Broersma Jr
21:39 Re: Get the max(value1, value2, value3) from a table Scott Marlowe
21:39 Re: Get the max(value1, value2, value3) from a table Emi Lu
21:39 Re: Get the max(value1, value2, value3) from a table Josh Williams
21:40 Re: Get the max(value1, value2, value3) from a table Scott Marlowe
21:43 Re: Get the max(value1, value2, value3) from a table Scott Marlowe
21:53 Re: Get the max(value1, value2, value3) from a table Emi Lu
22:16 Re: Get the max(value1, value2, value3) from a table Scott Marlowe
22:18 Re: Get the max(value1, value2, value3) from a table Erik Jones

8 January 2008

13:24 How to keep at-most N rows per group? periodic DELETEs or constraints or..? Jamie Tufnell
13:59 Re: How to keep at-most N rows per group? periodic DELETEs or constraints or..? codeWarrior
15:30 Re: How to keep at-most N rows per group? periodic DELETEs or constraints or..? Erik Jones
15:31 Re: How to keep at-most N rows per group? periodic DELETEs or constraints or..? Jamie Tufnell
16:22 Re: How to keep at-most N rows per group? periodic DELETEs or constraints or..? codeWarrior
16:41 Re: How to keep at-most N rows per group? periodic DELETEs or constraints or..? Jamie Tufnell
16:51 Re: How to keep at-most N rows per group? periodic DELETEs or constraints or..? Steve Midgley
17:15 trigger for TRUNCATE? Gerardo Herzig
17:29 Re: How to keep at-most N rows per group? periodic DELETEs or constraints or..? Erik Jones
17:49 Re: How to keep at-most N rows per group? periodic DELETEs or constraints or..? Jamie Tufnell
20:22 Re: trigger for TRUNCATE? Chris Browne
20:42 Re: trigger for TRUNCATE? Pavel Stehule

9 January 2008

17:21 Re: How to keep at-most N rows per group? periodic DELETEs or constraints or..? Steve Midgley
18:09 Re: Re: How to keep at-most N rows per group? periodic DELETEs or constraints or..? Scott Marlowe
19:18 Re: Re: How to keep at-most N rows per group? periodic DELETEs or constraints or..? Erik Jones
22:30 Re: Re: How to keep at-most N rows per group? periodic DELETEs or constraints or..? Jamie Tufnell

10 January 2008

02:14 Support for SQL TOP clause? Chinyi Woo
02:19 Re: Support for SQL TOP clause? Phillip Smith
06:10 Shorthand column labels (SELECT col1 foo, ...) vs (SELECT col1 AS foo, ...) Ken Johanson
06:20 Re: Shorthand column labels (SELECT col1 foo, ...) vs (SELECT col1 AS foo, ...) Paul Lambert
06:39 Re: Shorthand column labels (SELECT col1 foo, ...) vs (SELECT col1 AS foo, ...) Ken Johanson
07:03 Re: Shorthand column labels (SELECT col1 foo, ...) vs (SELECT col1 AS foo, ...) Paul Lambert
10:46 Re: Support for SQL TOP clause? Reinoud van Leeuwen
12:56 Re: Support for SQL TOP clause? Richard Broersma Jr
15:37 Re: trigger for TRUNCATE? Gerardo Herzig
16:10 Re: trigger for TRUNCATE? Alvaro Herrera
16:39 Re: trigger for TRUNCATE? Tom Lane
16:47 Re: trigger for TRUNCATE? Alvaro Herrera
17:09 Re: trigger for TRUNCATE? Gerardo Herzig
18:15 Re: trigger for TRUNCATE? Tom Lane
18:53 Re: trigger for TRUNCATE? Simon Riggs
18:54 Escape sequence for UTF-8 Character Literals? James Cloos
20:52 Re: trigger for TRUNCATE? Chris Browne
21:07 JOIN a table twice for different values in the same query Colin Wetherbee
21:18 Re: JOIN a table twice for different values in the same query Paul Lambert
21:22 Re: JOIN a table twice for different values in the same query Daniel Hernandez
21:22 Re: JOIN a table twice for different values in the same query Colin Wetherbee
21:23 Re: JOIN a table twice for different values in the same query Phillip Smith
21:31 Re: JOIN a table twice for different values in the same query Colin Wetherbee
21:41 Re: JOIN a table twice for different values in the same query Colin Wetherbee

11 January 2008

02:23 SQL stored function inserting and returning data in a row. Daniel Caune
05:58 (possible) bug with constraint exclusion Rajesh Kumar Mallah
06:20 Re: (possible) bug with constraint exclusion Rajesh Kumar Mallah
07:24 Re: trigger for TRUNCATE? Richard Huxton
10:00 Re: SQL stored function inserting and returning data in a row. Gerardo Herzig
10:15 Re: SQL stored function inserting and returning data in a row. Marcin Stępnicki
10:19 Re: SQL stored function inserting and returning data in a row. Marcin Stępnicki
12:55 Re: SQL stored function inserting and returning data in a row. Daniel Caune
13:18 Re: SQL stored function inserting and returning data in a row. Pavel Stehule
15:01 Re: trigger for TRUNCATE? Erik Jones
15:41 Re: trigger for TRUNCATE? Simon Riggs
15:49 Re: trigger for TRUNCATE? Bruce Momjian
18:56 Re: (possible) bug with constraint exclusion Tom Lane
23:10 SQL question: Highest column value of unique column pairs Kevin Jenkins

12 January 2008

00:30 Re: SQL question: Highest column value of unique column pairs Shane Ambler
02:06 Re: SQL question: Highest column value of unique column pairs Kevin Jenkins
04:18 Re: (possible) bug with constraint exclusion Rajesh Kumar Mallah
04:29 Re: (possible) bug with constraint exclusion Tom Lane
08:02 Re: (possible) bug with constraint exclusion Rajesh Kumar Mallah
09:31 Re: SQL question: Highest column value of unique column pairs Shane Ambler
21:21 UTF8 encoding and non-text data types Medi Montaseri

14 January 2008

03:52 Re: UTF8 encoding and non-text data types Steve Midgley
07:39 Re: SQL question: Highest column value of unique column pairs Marc Mamin
07:57 Re: SQL stored function inserting and returning data in a row. Marc Mamin
08:45 Re: trigger for TRUNCATE? Peter Childs
13:18 Unescaping text or binary file RDyes@monroehosp.org
15:38 table column names - search Marcin Krawczyk
16:24 Re: table column names - search Peter Eisentraut
17:30 Re: table column names - search Marcin Krawczyk
18:01 Re: UTF8 encoding and non-text data types Medi Montaseri
18:23 Re: UTF8 encoding and non-text data types Tom Lane
18:56 Re: UTF8 encoding and non-text data types dmp
19:03 Re: UTF8 encoding and non-text data types dmp
19:18 Re: UTF8 encoding and non-text data types Steve Midgley
19:43 Re: UTF8 encoding and non-text data types Medi Montaseri
19:53 Re: UTF8 encoding and non-text data types Steve Midgley
21:41 Re: UTF8 encoding and non-text data types Tom Lane
22:03 Re: UTF8 encoding and non-text data types Joe
22:24 Re: UTF8 encoding and non-text data types Tom Lane
22:41 Re: UTF8 encoding and non-text data types Joe

15 January 2008

09:31 Re: UTF8 encoding and non-text data types Gregory Stark
12:18 Is DATETIME an ANSI-SQL type? Joost Kraaijeveld
12:21 Re: JOIN a table twice for different values in the same query Magne Mæhre
12:45 Re: Is DATETIME an ANSI-SQL type? Magne Mæhre
13:03 Re: JOIN a table twice for different values in the same query Colin Wetherbee
14:53 Re: Is DATETIME an ANSI-SQL type? Tom Lane
15:37 Re: UTF8 encoding and non-text data types John Hasler
17:04 SQL dealing with subquery Bryan Emrys
18:04 SQL dealing with subquery comparison Bryan Emrys
18:42 Re: Is DATETIME an ANSI-SQL type? Joost Kraaijeveld
19:03 Update PK Violation Franklin Haut
19:20 Re: Update PK Violation Scott Marlowe
19:40 Re: SQL dealing with subquery Rodrigo E. De León Plicet
20:27 obtaining the query string inside a trigger Gerardo Herzig

16 January 2008

08:21 Re: obtaining the query string inside a trigger Richard Huxton
12:41 Re: Update PK Violation Fernando Hevia
13:41 Re: Update PK Violation Achilleas Mantzios
14:54 Re: SQL dealing with subquery Bryan Emrys
15:15 Re: Update PK Violation Scott Marlowe
16:03 Re: Update PK Violation Franklin Haut
16:35 Re: SQL dealing with subquery Bryan Emrys
22:16 How to test/read a stored procedure that returns a boolean? Kevin Jenkins
22:28 Re: How to test/read a stored procedure that returns a boolean? Tom Lane
22:50 Re: How to test/read a stored procedure that returns a boolean? Kevin Jenkins

18 January 2008

13:16 transaction and triggers Gerardo Herzig
13:44 Re: transaction and triggers Filip Rembiałkowski
14:14 Re: transaction and triggers Gerardo Herzig
14:26 Re: transaction and triggers Alvaro Herrera
14:32 Re: transaction and triggers Gerardo Herzig
14:48 Re: transaction and triggers D'Arcy J.M. Cain

21 January 2008

03:01 improvements to query with hierarchical elements Ryan Wallace
10:17 Having elements of an int[]-array reference other tables Andreas Joseph Krogh
10:30 Re: Having elements of an int[]-array reference other tables Pavel Stehule
11:12 Re: transaction and triggers Gerardo Herzig
12:50 Re: (possible) bug with constraint exclusion Christian Schröder
14:17 Re: (possible) bug with constraint exclusion Tom Lane
16:39 Re: (possible) bug with constraint exclusion Christian Schröder

22 January 2008

04:27 Re: improvements to query with hierarchical elements Steve Midgley
06:15 currval() within one statement silly_sad
06:36 Re: currval() within one statement A. Kretschmer
06:54 Re: currval() within one statement sad
07:08 TIMESTAMP comparison problem Stuart Brooks
08:13 Re: currval() within one statement Guillaume Lelarge
08:14 Re: currval() within one statement Richard Huxton
09:22 Re: currval() within one statement sad
09:22 Re: currval() within one statement Guillaume Lelarge
09:39 Re: currval() within one statement Richard Huxton
10:29 Re: currval() within one statement silly_sad
10:29 Re: currval() within one statement hubert depesz lubaczewski
11:18 Re: currval() within one statement Richard Huxton
11:50 Re: TIMESTAMP comparison problem Michael Glaesemann
11:58 Re: TIMESTAMP comparison problem Stuart Brooks
16:15 Re: TIMESTAMP comparison problem Tom Lane

23 January 2008

09:26 ALTER TABLE DROP CONSTRAINT IF EXISTS ? Andreas Joseph Krogh

24 January 2008

07:11 date format iuri de araujo sampaio
07:21 Re: date format A. Kretschmer
08:47 SQL tree duplication Philippe Lang
13:07 Re: SQL tree duplication tv@fuzzy.cz
14:46 Re: date format Adrian Klaver
14:50 Re: date format Scott Marlowe
14:50 Re: ALTER TABLE DROP CONSTRAINT IF EXISTS ? Scott Marlowe
21:21 Re: date format Scott Marlowe

25 January 2008

02:36 Extract interdependent info from one table Andrej Ricnik-Bay
03:11 Re: Extract interdependent info from one table Phillip Smith
07:38 Re: improvements to query with hierarchical elements Steve Midgley
13:15 Re: date format Frank Bax
15:02 Unclosed connections PostgreSQL Admin
15:12 This SQL works under Mysql, not Postgresql. acec acec
15:17 regex_replace problem Gary Stainburn
15:19 Re: Unclosed connections Scott Marlowe
15:21 Re: regex_replace problem -additional Gary Stainburn
15:23 Re: This SQL works under Mysql, not Postgresql. Scott Marlowe
15:29 Re: regex_replace problem -additional Scott Marlowe
15:32 Re: This SQL works under Mysql, not Postgresql. Scott Marlowe
15:42 Re: This SQL works under Mysql, not Postgresql. acec acec
15:53 Re: This SQL works under Mysql, not Postgresql. Oliveiros Cristina
16:21 Re: This SQL works under Mysql, not Postgresql. Tom Lane
16:43 Re: regex_replace problem Frank Bax
18:06 age() function usage Marcin Krawczyk
18:41 Re: age() function usage Scott Marlowe
18:53 Re: age() function usage Marcin Krawczyk
22:05 Re: Extract interdependent info from one table Andrej Ricnik-Bay

27 January 2008

23:48 Syntax question: use of join/using with fully qualified table name Bryce Nesbitt

28 January 2008

00:43 Re: Syntax question: use of join/using with fully qualified table name Martin Marques
00:45 Re: Syntax question: use of join/using with fully qualified table name Tom Lane
01:30 extract or date_part on an interval? How many e Bryce Nesbitt
01:55 Re: extract or date_part on an interval? How many e Adrian Klaver
02:10 Re: extract or date_part on an interval? How many e Tom Lane
03:51 Re: extract or date_part on an interval? How many e Bryce Nesbitt
04:37 Re: extract or date_part on an interval? How many e Michael Glaesemann
06:18 Slow Query problem Premsun Choltanwanich
11:27 Re: Slow Query problem Andreas Joseph Krogh
16:20 Re: Slow Query problem Tom Lane

29 January 2008

03:16 Proposed archival read only trigger on rows - prevent history modification Bryce Nesbitt
03:40 Re: Proposed archival read only trigger on rows - prevent history modification chester c young
07:18 Re: Slow Query problem Premsun Choltanwanich
09:26 Re: Slow Query problem Andreas Joseph Krogh
13:47 Slow GROUP BY query Stuart Brooks
14:30 JOINing SET returning function. Dawid Kuroczko

30 January 2008

02:50 Re: Slow Query problem Premsun Choltanwanich
02:50 Re: Slow Query problem Premsun Choltanwanich
03:39 Re: Proposed archival read only trigger on rows - prevent history modification Steve Midgley
09:35 Sql ORDER BY and ASC/DESC question Jaroslav Sivy
09:42 Re: Sql ORDER BY and ASC/DESC question A. Kretschmer
11:36 Re: Sql ORDER BY and ASC/DESC question Bart Degryse
12:32 Re: Sql ORDER BY and ASC/DESC question Gregory Stark
17:00 Re: Sql ORDER BY and ASC/DESC question Tom Lane
19:24 Re: Sql ORDER BY and ASC/DESC question Gregory Stark
22:37 Problem with the to_timestamp function Luca Clementi
23:26 Re: Problem with the to_timestamp function Tom Lane

31 January 2008

00:20 Re: Problem with the to_timestamp function Michael Glaesemann
01:05 Re: Problem with the to_timestamp function Luca Clementi
05:04 Re: Problem with the to_timestamp function Tom Lane
17:00 Re: Problem with the to_timestamp function Luca Clementi
17:09 Re: Problem with the to_timestamp function Tom Lane