pgsql-sql since 2008-01-12 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

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

Feb. 1, 2008

Thread Author Time
aggregate reverse Marcin Krawczyk 15:24
Re: aggregate reverse Pavel Stehule 17:33

Feb. 2, 2008

Thread Author Time
Re: aggregate reverse Marcin Krawczyk 08:48
can a insert with a returning clause be subquery ? chrisj 23:22

Feb. 3, 2008

Thread Author Time
Re: can a insert with a returning clause be subquery ? Jonah H. Harris 00:12
Re: can a insert with a returning clause be subquery ? Adrian Klaver 00:40
Re: can a insert with a returning clause be subquery ? Jonah H. Harris 01:27
Helper aggregate function sergey kapustin 11:44
Re: Helper aggregate function Robins Tharakan 18:58
Re: Helper aggregate function Christian Kindler 20:07

Feb. 5, 2008

Thread Author Time
Except without elimination of non-distinct rows Ray Madigan 02:16
Re: Except without elimination of non-distinct rows Tom Lane 02:19
Re: Except without elimination of non-distinct rows Ray Madigan 03:23
TG_TABLE_NAME as identifier Tiziano Slack 08:45
Re: TG_TABLE_NAME as identifier Richard Huxton 09:32
Re: TG_TABLE_NAME as identifier Robins Tharakan 10:07
Re: Cast in PG 8.3 Jaime Casanova 19:18
Cast in PG 8.3 📎 Franklin Haut 19:22
Re: Cast in PG 8.3 Li, Jingfa 19:39
Negative numbers for PK/ID's? Steve Midgley 19:42
Re: Cast in PG 8.3 Jaime Casanova 19:46
Re: Cast in PG 8.3 Li, Jingfa 20:07
Re: Cast in PG 8.3 Markus Bertheau 20:12
Re: Cast in PG 8.3 Tom Lane 21:13
Re: Negative numbers for PK/ID's? Tom Lane 21:23
Re: Cast in PG 8.3 Volkan YAZICI 22:39

Feb. 6, 2008

Thread Author Time
Multiple postgresql functions in a single transaction Jyoti Seth 06:21
Re: Multiple postgresql functions in a single transaction Robins Tharakan 07:23
Re: Multiple postgresql functions in a single transaction Jyoti Seth 07:37
Re: Multiple postgresql functions in a single transaction sad 07:42
undefined relations in pg_locks Sabin Coanda 13:36
Re: undefined relations in pg_locks Guillaume Lelarge 14:01
Create Table xtest (like xtype) TJ O'Donnell 19:40
Columns view? (Finding column names for a table) Steve Midgley 20:33
Re: Columns view? (Finding column names for a table) Thomas Kellerer 20:43
Double query PostgreSQL Admin 21:01
Information schema permissions johnf 21:01
Re: Double query D'Arcy J.M. Cain 21:17
outer join issues Tom Hart 21:36
Re: outer join issues Colin Wetherbee 22:02
Re: outer join issues Terry Fielder 22:22
Re: outer join issues Tom Hart 22:37
Re: Create Table xtest (like xtype) Tom Lane 23:21
Re: Information schema permissions Tom Lane 23:37

Feb. 7, 2008

Thread Author Time
Re: Create Table xtest (like xtype) TJ O'Donnell 00:37
accounting schema Medi Montaseri 01:08
Re: Information schema permissions johnf 01:33
Re: accounting schema Steve Midgley 02:35
Re: accounting schema Medi Montaseri 02:54
Re: accounting schema Robert Edwards 03:02
Re: accounting schema Steve Midgley 03:35
Re: TG_TABLE_NAME as identifier Tiziano Slack 07:16
Re: TG_TABLE_NAME as identifier Richard Huxton 07:52
Re: accounting schema John Hasler 14:08
Re: accounting schema Tony Wasson 15:52
Re: accounting schema johnf 16:09
Re: TG_TABLE_NAME as identifier Tiziano Slack 23:10

Feb. 8, 2008

Thread Author Time
performance issue - view and derived field Gary Stainburn 09:56

Browse Archives

Prev | Next