Skip site navigation (1)
Skip section navigation (2)
pgsql-sql 2008-01 Chronological Index (1/2)
Last updated: Wed Jan 18 04:30:13 2012
238 messages
30 January 2008
Re: Sql ORDER BY and ASC/DESC question Gregory Stark (20:24)
Re: Sql ORDER BY and ASC/DESC question Tom Lane (18:00)
Re: Sql ORDER BY and ASC/DESC question Gregory Stark (13:32)
Re: Sql ORDER BY and ASC/DESC question Bart Degryse (12:36)
Re: Sql ORDER BY and ASC/DESC question A. Kretschmer (10:42)
Sql ORDER BY and ASC/DESC question Jaroslav Sivy (10:35)
Re: Proposed archival read only trigger on rows - prevent history modification Steve Midgley (04:39)
Re: Slow Query problem Premsun Choltanwanich (03:50)
Re: Slow Query problem Premsun Choltanwanich (03:50)
29 January 2008
Slow GROUP BY query Stuart Brooks (14:47)
Re: Slow Query problem Andreas Joseph Krogh (10:26)
Re: Slow Query problem Premsun Choltanwanich (08:18)
Re: Proposed archival read only trigger on rows - prevent history modification chester c young (04:40)
Proposed archival read only trigger on rows - prevent history modification Bryce Nesbitt (04:16)
28 January 2008
Re: Slow Query problem Andreas Joseph Krogh (12:27)
Slow Query problem Premsun Choltanwanich (07:18)
Re: extract or date_part on an interval? How many e Michael Glaesemann (05:37)
Re: extract or date_part on an interval? How many e Bryce Nesbitt (04:51)
Re: extract or date_part on an interval? How many e Tom Lane (03:10)
Re: extract or date_part on an interval? How many e Adrian Klaver (02:55)
extract or date_part on an interval? How many e Bryce Nesbitt (02:30)
Re: Syntax question: use of join/using with fully qualified table name Tom Lane (01:45)
Re: Syntax question: use of join/using with fully qualified table name Martin Marques (01:43)
Syntax question: use of join/using with fully qualified table name Bryce Nesbitt (00:48)
25 January 2008
Re: age() function usage Marcin Krawczyk (19:53)
Re: age() function usage Scott Marlowe (19:41)
age() function usage Marcin Krawczyk (19:06)
Re: regex_replace problem Frank Bax (17:43)
Re: This SQL works under Mysql, not Postgresql. Tom Lane (17:21)
Re: This SQL works under Mysql, not Postgresql. Oliveiros Cristina (16:53)
Re: This SQL works under Mysql, not Postgresql. acec acec (16:42)
Re: This SQL works under Mysql, not Postgresql. Scott Marlowe (16:32)
Re: regex_replace problem -additional Scott Marlowe (16:29)
Re: This SQL works under Mysql, not Postgresql. Scott Marlowe (16:23)
Re: regex_replace problem -additional Gary Stainburn (16:21)
Re: Unclosed connections Scott Marlowe (16:19)
regex_replace problem Gary Stainburn (16:17)
This SQL works under Mysql, not Postgresql. acec acec (16:11)
Unclosed connections PostgreSQL Admin (16:02)
Re: date format Frank Bax (14:15)
Re: improvements to query with hierarchical elements Steve Midgley (08:38)
Re: Extract interdependent info from one table Phillip Smith (04:11)
Extract interdependent info from one table Andrej Ricnik-Bay (03:36)
24 January 2008
Re: ALTER TABLE <mytable> DROP CONSTRAINT IF EXISTS <myconstraint> ? Scott Marlowe (15:50)
Re: date format Scott Marlowe (15:50)
Re: date format Adrian Klaver (15:46)
Re: SQL tree duplication tv (14:07)
SQL tree duplication Philippe Lang (09:47)
Re: date format A. Kretschmer (08:21)
date format iuri de araujo sampaio (08:11)
23 January 2008
22 January 2008
Re: TIMESTAMP comparison problem Stuart Brooks (12:58)
Re: TIMESTAMP comparison problem Michael Glaesemann (12:50)
Re: currval() within one statement Richard Huxton (12:18)
Re: currval() within one statement hubert depesz lubaczewski (11:29)
Re: currval() within one statement silly_sad (11:29)
Re: currval() within one statement Richard Huxton (10:39)
Re: currval() within one statement Guillaume Lelarge (10:22)
Re: currval() within one statement sad (10:22)
Re: currval() within one statement Richard Huxton (09:14)
Re: currval() within one statement Guillaume Lelarge (09:13)
TIMESTAMP comparison problem Stuart Brooks (08:08)
Re: currval() within one statement sad (07:54)
Re: currval() within one statement A. Kretschmer (07:36)
currval() within one statement silly_sad (07:15)
Re: improvements to query with hierarchical elements Steve Midgley (05:27)
21 January 2008
Re: (possible) bug with constraint exclusion Tom Lane (15:17)
Re: (possible) bug with constraint exclusion Christian Schröder (13:50)
Re: transaction and triggers Gerardo Herzig (12:12)
Re: Having elements of an int[]-array reference other tables Pavel Stehule (11:29)
Having elements of an int[]-array reference other tables Andreas Joseph Krogh (11:17)
improvements to query with hierarchical elements Ryan Wallace (04:01)
18 January 2008
Re: transaction and triggers Gerardo Herzig (15:32)
Re: transaction and triggers Alvaro Herrera (15:26)
Re: transaction and triggers Gerardo Herzig (15:14)
Re: transaction and triggers Filip Rembiałkowski (14:44)
transaction and triggers Gerardo Herzig (14:16)
16 January 2008
Re: How to test/read a stored procedure that returns a boolean? Tom Lane (23:28)
How to test/read a stored procedure that returns a boolean? Kevin Jenkins (23:16)
Re: SQL dealing with subquery Bryan Emrys (17:35)
Re: Update PK Violation Franklin Haut (17:03)
Re: Update PK Violation Scott Marlowe (16:15)
Re: SQL dealing with subquery Bryan Emrys (15:54)
Re: Update PK Violation Achilleas Mantzios (14:41)
Re: Update PK Violation Fernando Hevia (13:41)
Re: obtaining the query string inside a trigger Richard Huxton (09:21)
15 January 2008
Re: SQL dealing with subquery Rodrigo E. De León Plicet (20:40)
Re: Update PK Violation Scott Marlowe (20:20)
Update PK Violation Franklin Haut (20:03)
Re: Is DATETIME an ANSI-SQL type? Joost Kraaijeveld (19:42)
SQL dealing with subquery comparison Bryan Emrys (19:03)
SQL dealing with subquery Bryan Emrys (18:04)
Re: UTF8 encoding and non-text data types John Hasler (16:37)
Re: Is DATETIME an ANSI-SQL type? Tom Lane (15:53)
Re: JOIN a table twice for different values in the same query Colin Wetherbee (14:03)
Re: Is DATETIME an ANSI-SQL type? Magne Mæhre (13:45)
Re: JOIN a table twice for different values in the same query Magne Mæhre (13:21)
Is DATETIME an ANSI-SQL type? Joost Kraaijeveld (13:18)
Re: UTF8 encoding and non-text data types Gregory Stark (10:31)
14 January 2008
Re: UTF8 encoding and non-text data types Tom Lane (23:24)
Re: UTF8 encoding and non-text data types Joe (23:03)
Re: UTF8 encoding and non-text data types Tom Lane (22:41)
Re: UTF8 encoding and non-text data types Steve Midgley (20:53)
Re: UTF8 encoding and non-text data types Medi Montaseri (20:43)
Re: UTF8 encoding and non-text data types Steve Midgley (20:18)
Re: UTF8 encoding and non-text data types dmp (20:03)
Re: UTF8 encoding and non-text data types dmp (19:55)
Re: UTF8 encoding and non-text data types Tom Lane (19:23)
Re: UTF8 encoding and non-text data types Medi Montaseri (19:01)
Re: table column names - search Marcin Krawczyk (18:30)
Re: table column names - search Peter Eisentraut (17:24)
table column names - search Marcin Krawczyk (16:38)
Unescaping text or binary file RDyes (14:17)
Re: trigger for TRUNCATE? Peter Childs (09:45)
Re: SQL stored function inserting and returning data in a row. Marc Mamin (08:57)
Re: SQL question: Highest column value of unique column pairs Marc Mamin (08:39)
Re: UTF8 encoding and non-text data types Steve Midgley (04:52)
12 January 2008
Re: SQL question: Highest column value of unique column pairs Shane Ambler (10:30)
Re: (possible) bug with constraint exclusion Rajesh Kumar Mallah (09:02)
Re: (possible) bug with constraint exclusion Tom Lane (05:29)
Re: (possible) bug with constraint exclusion Rajesh Kumar Mallah (05:18)
Re: SQL question: Highest column value of unique column pairs Kevin Jenkins (03:06)
Re: SQL question: Highest column value of unique column pairs Shane Ambler (01:30)
SQL question: Highest column value of unique column pairs Kevin Jenkins (00:10)
11 January 2008
Re: trigger for TRUNCATE? Bruce Momjian (16:49)
Re: trigger for TRUNCATE? Simon Riggs (16:41)
Re: trigger for TRUNCATE? Erik Jones (16:01)
Re: SQL stored function inserting and returning data in a row. Pavel Stehule (14:17)
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. Marcin Stępnicki (11:19)
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. Gerardo Herzig (11:00)
Re: trigger for TRUNCATE? Richard Huxton (08:24)
Re: (possible) bug with constraint exclusion Rajesh Kumar Mallah (07:20)
(possible) bug with constraint exclusion Rajesh Kumar Mallah (06:58)
SQL stored function inserting and returning data in a row. Daniel Caune (03:23)
10 January 2008
Re: JOIN a table twice for different values in the same query Colin Wetherbee (22:31)
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:22)
Re: JOIN a table twice for different values in the same query Daniel Hernandez (22:22)
Re: JOIN a table twice for different values in the same query Paul Lambert (22:18)
JOIN a table twice for different values in the same query Colin Wetherbee (22:07)
Re: trigger for TRUNCATE? Chris Browne (21:52)
Escape sequence for UTF-8 Character Literals? James Cloos (19:54)
Re: trigger for TRUNCATE? Simon Riggs (19:53)
Re: trigger for TRUNCATE? Tom Lane (19:15)
Re: trigger for TRUNCATE? Gerardo Herzig (18:09)
Re: trigger for TRUNCATE? Alvaro Herrera (17:47)
Re: trigger for TRUNCATE? Tom Lane (17:39)
Re: trigger for TRUNCATE? Alvaro Herrera (17:10)
Re: trigger for TRUNCATE? Gerardo Herzig (16:37)
Re: Support for SQL TOP clause? Richard Broersma Jr (13:56)
Re: Support for SQL TOP clause? Reinoud van Leeuwen (11:46)
Re: Shorthand column labels (SELECT col1 foo, ...) vs (SELECT col1 AS foo, ...) Paul Lambert (08:03)
Re: Shorthand column labels (SELECT col1 foo, ...) vs (SELECT col1 AS foo, ...) Ken Johanson (07:39)
Re: Shorthand column labels (SELECT col1 foo, ...) vs (SELECT col1 AS foo, ...) Paul Lambert (07:20)
Shorthand column labels (SELECT col1 foo, ...) vs (SELECT col1 AS foo, ...) Ken Johanson (07:10)
Re: Support for SQL TOP clause? Phillip Smith (03:19)
Support for SQL TOP clause? Chinyi Woo (03:14)
09 January 2008