pgsql-sql before 2008-02-01 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
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 14 15 16 18 21 22 23 24 25 28 29 30 31

Jan. 7, 2008

Thread Author Time
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
Re: regex_replace problem -additional Scott Marlowe 16:29
Re: This SQL works under Mysql, not Postgresql. Scott Marlowe 16:32
Re: This SQL works under Mysql, not Postgresql. acec acec 16:42
Re: This SQL works under Mysql, not Postgresql. Oliveiros Cristina 16:52
Re: This SQL works under Mysql, not Postgresql. Tom Lane 17:20
Re: regex_replace problem Frank Bax 17:43
age() function usage Marcin Krawczyk 19:06
Re: age() function usage Scott Marlowe 19:41
Re: age() function usage Marcin Krawczyk 19:53
Re: Extract interdependent info from one table Andrej Ricnik-Bay 23:05

Jan. 28, 2008

Thread Author Time
Syntax question: use of join/using with fully qualified table name Bryce Nesbitt 00:49
Re: Syntax question: use of join/using with fully qualified table name Martin Marques 01:43
Re: Syntax question: use of join/using with fully qualified table name Tom Lane 01:45
extract or date_part on an interval? How many e Bryce Nesbitt 02:30
Re: extract or date_part on an interval? How many e Adrian Klaver 02:56
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 📎 Bryce Nesbitt 04:51
Re: extract or date_part on an interval? How many e Michael Glaesemann 05:19
Slow Query problem Premsun Choltanwanich 07:18
Re: Slow Query problem Andreas Joseph Krogh 12:26
Re: Slow Query problem Tom Lane 17:20

Jan. 29, 2008

Thread Author Time
Proposed archival read only trigger on rows - prevent history modification Bryce Nesbitt 04:16
Re: Proposed archival read only trigger on rows - prevent history modification chester c young 04:40
Re: Slow Query problem Premsun Choltanwanich 08:18
Re: Slow Query problem Andreas Joseph Krogh 10:24
Slow GROUP BY query Stuart Brooks 14:43
JOINing SET returning function. Dawid Kuroczko 15:29

Jan. 30, 2008

Thread Author Time
Re: Slow Query problem Premsun Choltanwanich 03:38
Re: Slow Query problem Premsun Choltanwanich 03:39
Re: Proposed archival read only trigger on rows - prevent history modification Steve Midgley 04:31
Sql ORDER BY and ASC/DESC question 📎 Jaroslav Sivy 10:35
Re: Sql ORDER BY and ASC/DESC question A. Kretschmer 10:42
Re: Sql ORDER BY and ASC/DESC question Bart Degryse 12:30
Re: Sql ORDER BY and ASC/DESC question Gregory Stark 13:32
Re: Sql ORDER BY and ASC/DESC question Tom Lane 18:00
Re: Sql ORDER BY and ASC/DESC question Gregory Stark 20:24
Problem with the to_timestamp function Luca Clementi 23:37

Jan. 31, 2008

Thread Author Time
Re: Problem with the to_timestamp function Tom Lane 00:26
Re: Problem with the to_timestamp function Michael Glaesemann 01:19
Re: Problem with the to_timestamp function Luca Clementi 02:04
Re: Problem with the to_timestamp function Tom Lane 06:04
Re: Problem with the to_timestamp function Luca Clementi 18:00
Re: Problem with the to_timestamp function Tom Lane 18:09

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 14 15 16 18 21 22 23 24 25 28 29 30 31