pgsql-sql since 2007-12-31 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

Dec. 31, 2007

Thread Author Time
Re: sql query question ? Trilok Kumar 13:53
Limit # of recs on inner join? Josh 18:52

Jan. 1, 2008

Thread Author Time
Re: Limit # of recs on inner join? Rodrigo E. De León Plicet 02:07
Re: Limit # of recs on inner join? Richard Broersma Jr 05:25
Using rules to implement backward-compatible schema changes Mario Becroft 05:51
Re: Using rules to implement backward-compatible schema changes Tom Lane 07:09
Re: Using rules to implement backward-compatible schema changes Mario Becroft 07:40
Re: EPOCH TIMESTAMP Conversion Problem Louis-David Mitterrand 14:28
Re: EPOCH TIMESTAMP Conversion Problem Tom Lane 19:03
Re: EPOCH TIMESTAMP Conversion Problem Michael Glaesemann 19:32

Jan. 2, 2008

Thread Author Time
PG is in different timezone than the OS Fernando Hevia 18:43
Re: PG is in different timezone than the OS Scott Marlowe 20:06
Re: Argentinian timezone change at the last moment. How to change pgsql tz db? Scott Marlowe 20:18
Re: PG is in different timezone than the OS Scott Marlowe 20:27
Re: [SQL] PG is in different timezone than the OS Scott Marlowe 20:31
Re: Argentinian timezone change at the last moment. How to change pgsql tz db? Joe 20:49
Re: Argentinian timezone change at the last moment. How to change pgsql tz db? Scott Marlowe 23:29
Re: Argentinian timezone change at the last moment. How to change pgsql tz db? Tom Lane 23:45

Jan. 3, 2008

Thread Author Time
Re: Argentinian timezone change at the last moment. How to change pgsql tz db? Fernando Hevia 12:27
WAL archiving blowed. Gerardo Herzig 19:33

Jan. 4, 2008

Thread Author Time
Re: [SQL] Argentinian timezone change at the last moment. How to change pgsql tz db? Fernando Hevia 03:57
Re: [SQL] Argentinian timezone change at the last moment. How to change pgsql tz db? Tom Lane 04:37
Re: [SQL] Argentinian timezone change at the last moment. How to change pgsql tz db? Fernando Hevia 14:01

Jan. 6, 2008

Thread Author Time
tsearch2: ts_headline performance problem Anders Østergaard Jensen 14:15
Re: tsearch2: ts_headline performance problem Oleg Bartunov 15:09

Jan. 7, 2008

Thread Author Time
reading WAL files in python Gerardo Herzig 13:19
Re: reading WAL files in python C. Bergström 14:05
Re: reading WAL files in python Gerardo Herzig 14:26
Cheers for DISTINCT ON Peter Kovacs 16:02
Re: Cheers for DISTINCT ON Andrew Sullivan 16:18
Re: Cheers for DISTINCT ON Bruce Momjian 16:22
Re: Cheers for DISTINCT ON Chris Browne 17:51
Re: Cheers for DISTINCT ON Chris Browne 17:52
Re: Cheers for DISTINCT ON Andrew Sullivan 18:35
Re: reading WAL files in python Erik Jones 18:53
Re: reading WAL files in python gherzig 20:47
Get the max(value1, value2, value3) from a table Emi Lu 22:03
Re: Get the max(value1, value2, value3) from a table Scott Marlowe 22:16
Re: Get the max(value1, value2, value3) from a table Richard Broersma Jr 22:27
Re: Get the max(value1, value2, value3) from a table Scott Marlowe 22:37
Re: Get the max(value1, value2, value3) from a table Emi Lu 22:37
Re: Get the max(value1, value2, value3) from a table Josh Williams 22:38
Re: Get the max(value1, value2, value3) from a table Scott Marlowe 22:40
Re: Get the max(value1, value2, value3) from a table Scott Marlowe 22:43
Re: Get the max(value1, value2, value3) from a table Emi Lu 22:53
Re: Get the max(value1, value2, value3) from a table Scott Marlowe 23:16
Re: Get the max(value1, value2, value3) from a table Erik Jones 23:16

Jan. 8, 2008

Thread Author Time
How to keep at-most N rows per group? periodic DELETEs or constraints or..? Jamie Tufnell 14:24
Re: How to keep at-most N rows per group? periodic DELETEs or constraints or..? codeWarrior 15:45
Re: How to keep at-most N rows per group? periodic DELETEs or constraints or..? Erik Jones 16:30
Re: How to keep at-most N rows per group? periodic DELETEs or constraints or..? Jamie Tufnell 16:31
Re: How to keep at-most N rows per group? periodic DELETEs or constraints or..? Steve Midgley 17:31
Re: How to keep at-most N rows per group? periodic DELETEs or constraints or..? Jamie Tufnell 17:41
Re: How to keep at-most N rows per group? periodic DELETEs or constraints or..? codeWarrior 17:53
trigger for TRUNCATE? Gerardo Herzig 18:19
Re: How to keep at-most N rows per group? periodic DELETEs or constraints or..? Erik Jones 18:28
Re: How to keep at-most N rows per group? periodic DELETEs or constraints or..? Jamie Tufnell 18:49
Re: trigger for TRUNCATE? Chris Browne 20:57
Re: trigger for TRUNCATE? Pavel Stehule 21:38

Jan. 9, 2008

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

Jan. 10, 2008

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

Jan. 11, 2008

Thread Author Time
SQL stored function inserting and returning data in a row. Daniel Caune 03:23
(possible) bug with constraint exclusion Rajesh Kumar Mallah 06:58
Re: (possible) bug with constraint exclusion Rajesh Kumar Mallah 07:20
Re: trigger for TRUNCATE? Richard Huxton 08:24
Re: SQL stored function inserting and returning data in a row. Gerardo Herzig 11:03
Re: [SQL] SQL stored function inserting and returning data in a row. Hocine Abir 11:06
Re: SQL stored function inserting and returning data in a row. Marcin Stępnicki 11:15
Re: SQL stored function inserting and returning data in a row. Marcin Stępnicki 11:19
Re: SQL stored function inserting and returning data in a row. Daniel Caune 13:55
Re: SQL stored function inserting and returning data in a row. Pavel Stehule 14:17
Re: trigger for TRUNCATE? Erik Jones 16:01
Re: trigger for TRUNCATE? Simon Riggs 16:41
Re: trigger for TRUNCATE? Bruce Momjian 16:49
Re: [SQL] (possible) bug with constraint exclusion Tom Lane 19:56

Jan. 12, 2008

Thread Author Time
SQL question: Highest column value of unique column pairs Kevin Jenkins 00:10
Re: SQL question: Highest column value of unique column pairs Shane Ambler 01:29
Re: SQL question: Highest column value of unique column pairs Kevin Jenkins 03:06
Re: (possible) bug with constraint exclusion Rajesh Kumar Mallah 05:00
Re: (possible) bug with constraint exclusion Tom Lane 05:24
Re: (possible) bug with constraint exclusion Rajesh Kumar Mallah 09:02
Re: SQL question: Highest column value of unique column pairs Shane Ambler 10:30
UTF8 encoding and non-text data types Medi Montaseri 22:21

Jan. 14, 2008

Thread Author Time
Re: UTF8 encoding and non-text data types Steve Midgley 04:51
Re: SQL question: Highest column value of unique column pairs Marc Mamin 08:39
Re: SQL stored function inserting and returning data in a row. Marc Mamin 08:57
Re: trigger for TRUNCATE? Peter Childs 09:44
Unescaping text or binary file RDyes 14:17
table column names - search Marcin Krawczyk 16:38
Re: table column names - search Peter Eisentraut 17:24
Re: table column names - search Marcin Krawczyk 18:30
Re: UTF8 encoding and non-text data types Medi Montaseri 19:01
Re: UTF8 encoding and non-text data types Tom Lane 19:22
Re: UTF8 encoding and non-text data types dmp 19:51
Re: UTF8 encoding and non-text data types dmp 19:59
Re: UTF8 encoding and non-text data types Steve Midgley 20:18
Re: UTF8 encoding and non-text data types Medi Montaseri 20:43
Re: UTF8 encoding and non-text data types Steve Midgley 20:52
Re: UTF8 encoding and non-text data types Tom Lane 22:41
Re: UTF8 encoding and non-text data types Joe 23:03
Re: UTF8 encoding and non-text data types Tom Lane 23:24
Re: UTF8 encoding and non-text data types Joe 23:40

Jan. 15, 2008

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

Jan. 16, 2008

Thread Author Time
Re: obtaining the query string inside a trigger Richard Huxton 09:21
Re: Update PK Violation Fernando Hevia 13:32
Re: Update PK Violation Achilleas Mantzios 14:30
Re: SQL dealing with subquery Bryan Emrys 15:54
Re: Update PK Violation Scott Marlowe 16:15
Re: SQL dealing with subquery Bryan Emrys 17:34
Re: Update PK Violation 📎 Franklin Haut 18:07
How to test/read a stored procedure that returns a boolean? Kevin Jenkins 23:15
Re: How to test/read a stored procedure that returns a boolean? Tom Lane 23:28
Re: How to test/read a stored procedure that returns a boolean? Kevin Jenkins 23:50

Jan. 18, 2008

Thread Author Time
transaction and triggers Gerardo Herzig 14:17
Re: transaction and triggers Filip Rembiałkowski 14:42
Re: transaction and triggers Gerardo Herzig 15:16
Re: transaction and triggers Alvaro Herrera 15:26
Re: transaction and triggers Gerardo Herzig 15:33
Re: transaction and triggers D'Arcy J.M. Cain 15:48

Jan. 21, 2008

Thread Author Time
improvements to query with hierarchical elements Ryan Wallace 04:01
Having elements of an int[]-array reference other tables Andreas Joseph Krogh 11:16
Re: Having elements of an int[]-array reference other tables Pavel Stehule 11:29
Re: transaction and triggers Gerardo Herzig 12:12
Re: (possible) bug with constraint exclusion Christian Schröder 13:48
Re: (possible) bug with constraint exclusion Tom Lane 15:11
Re: (possible) bug with constraint exclusion Christian Schröder 17:39

Jan. 22, 2008

Thread Author Time
Re: improvements to query with hierarchical elements Steve Midgley 05:21
currval() within one statement silly_sad 07:16
Re: currval() within one statement A. Kretschmer 07:36
Re: currval() within one statement sad 07:54
TIMESTAMP comparison problem Stuart Brooks 08:05
Re: currval() within one statement Guillaume Lelarge 09:13
Re: currval() within one statement Richard Huxton 09:13
Re: currval() within one statement Guillaume Lelarge 10:22
Re: currval() within one statement sad 10:22
Re: currval() within one statement Richard Huxton 10:39
Re: currval() within one statement silly_sad 11:27
Re: currval() within one statement hubert depesz lubaczewski 11:27
Re: currval() within one statement Richard Huxton 12:18
Re: TIMESTAMP comparison problem Michael Glaesemann 12:42
Re: TIMESTAMP comparison problem Stuart Brooks 12:52
Re: TIMESTAMP comparison problem Tom Lane 17:13

Jan. 23, 2008

Thread Author Time
ALTER TABLE <mytable> DROP CONSTRAINT IF EXISTS <myconstraint> ? Andreas Joseph Krogh 10:25

Jan. 24, 2008

Thread Author Time
date format iuri de araujo sampaio 08:06
Re: date format A. Kretschmer 08:21
SQL tree duplication Philippe Lang 09:42
Re: SQL tree duplication tv 14:09
Re: date format Adrian Klaver 15:37
Re: date format Scott Marlowe 15:41
Re: ALTER TABLE <mytable> DROP CONSTRAINT IF EXISTS <myconstraint> ? Scott Marlowe 15:44
Re: date format Scott Marlowe 20:59

Jan. 25, 2008

Thread Author Time
Extract interdependent info from one table Andrej Ricnik-Bay 03:32
Re: Extract interdependent info from one table Phillip Smith 04:11
Re: improvements to query with hierarchical elements Steve Midgley 08:38
Re: date format Frank Bax 14:15
Unclosed connections PostgreSQL Admin 16:02
This SQL works under Mysql, not Postgresql. acec acec 16:11
regex_replace problem Gary Stainburn 16:15
Re: [SQL] Unclosed connections Scott Marlowe 16:19
Re: regex_replace problem -additional Gary Stainburn 16:19
Re: This SQL works under Mysql, not Postgresql. Scott Marlowe 16:23

Browse Archives

Prev | Next