Search

Peripheral Links

• Home
• About
• Download
• Documentation
• Community
• Developers
• Support
• Your account

pgsql-sql - January 2008

Search archives
	(enter a message-id to go directly to that message)	Advanced Search

Prev | Next

2008-01-01

• 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)

2008-01-02

• 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)

2008-01-03

• 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)

2008-01-04

• 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)

2008-01-06

• tsearch2: ts_headline performance problem Anders Østergaard Jensen (14:15)
• Re: tsearch2: ts_headline performance problem Oleg Bartunov (15:09)

2008-01-07

• 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)

2008-01-08

• 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)

2008-01-09

• 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)

2008-01-10

• 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)

2008-01-11

• 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 arow. 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)

2008-01-12

• 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)

2008-01-14

• 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)

2008-01-15

• 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)

2008-01-16

• 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)

2008-01-18

• 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)

2008-01-21

• 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)

2008-01-22

• 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)

2008-01-23

• ALTER TABLE <mytable> DROP CONSTRAINT IF EXISTS <myconstraint> ? Andreas Joseph Krogh (10:25)

2008-01-24

• 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)

2008-01-25

• 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)
• Re: regex_replace problem -additional Scott Marlowe (16:29)
• Re: This SQL works under Mysql, not Postgresql. Scott Marlowe (16:32)

Prev | Next