pgsql-sql since 2008-01-22 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. 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
Serial not nulla Shavonne Marietta Wijesinghe 11:15
Postgres roles Pascal Tufenkji 13:02
Re: Serial not nulla Shane Ambler 13:17
Re: Postgres roles Shane Ambler 13:53
Re: Postgres roles Pascal Tufenkji 14:54
What are the (various) best practices/opinions for table/column/constraint naming? Ken Johanson 21:04

Feb. 9, 2008

Thread Author Time
Re: What are the (various) best practices/opinions for table/column/constraint naming? Karsten Hilbert 10:58
Re: Postgres roles Shane Ambler 14:16

Feb. 11, 2008

Thread Author Time
Can CREATE TYPE be used to create a synonym? Dean Gibson (DB Administrator) 01:38
Re: Can CREATE TYPE be used to create a synonym? Tom Lane 02:57
Re: Can CREATE TYPE be used to create a synonym? Tom Lane 03:11
Re: Bouncing replies Dean Gibson (DB Administrator) 05:06
Re: Bouncing replies Dave Page 08:54
Re: Bouncing replies Dean Gibson (DB Administrator) 09:30
Re: Serial not nulla Shavonne Marietta Wijesinghe 10:24
Usage of UUID with 8.3 (Windows) ncode 10:25
Re: Bouncing replies Dave Page 10:42
Check before INSERT INTO Shavonne Marietta Wijesinghe 12:04
Re: Check before INSERT INTO Shavonne Marietta Wijesinghe 13:13
Re: Check before INSERT INTO Gregory Stark 16:03
Re: Check before INSERT INTO Shavonne Marietta Wijesinghe 16:22
Re: Check before INSERT INTO Jean-David Beyer 16:55
Re: Check before INSERT INTO Gregory Stark 16:56
Re: Usage of UUID with 8.3 (Windows) Tom Lane 16:56
Re: Usage of UUID with 8.3 (Windows) Alvaro Herrera 17:04
Re: Usage of UUID with 8.3 (Windows) Tom Lane 17:35

Feb. 12, 2008

Thread Author Time
PostgreSQL does not support updateable cursors Premsun Choltanwanich 06:33
Backward compatibility psql 8.1 to 8.2 Bryce Nesbitt 08:22
Re: Proposed archival read only trigger on rows - prevent history modification Bryce Nesbitt 08:25
Re: Proposed archival read only trigger on rows - prevent history modification 📎 Bryce Nesbitt 08:30
Re: Backward compatibility psql 8.1 to 8.2 Richard Huxton 08:32
Usage of UUID with 8.3 (Windows) Sven Sporer 09:05
Re: Check before INSERT INTO Shavonne Marietta Wijesinghe 10:00
Re: Check before INSERT INTO Richard Huxton 10:35
Re: Check before INSERT INTO Shavonne Marietta Wijesinghe 11:06
Re: Check before INSERT INTO Richard Huxton 12:01
Re: Usage of UUID with 8.3 (Windows) Steve Midgley 18:11

Feb. 13, 2008

Thread Author Time
return field from different table conditionally Bart Degryse 10:54
Like problem Campbell, Lance 16:30
Re: Like problem Richard Huxton 16:42
Re: Like problem Tom Lane 16:52
Re: Like problem Campbell, Lance 16:59
Re: Like problem Campbell, Lance 17:02
Re: Like problem Campbell, Lance 17:03
Re: Like problem Richard Huxton 17:09
Re: return field from different table conditionally Bart Degryse 17:16

Feb. 14, 2008

Thread Author Time
PL/pgSQL question Sebastian Ritter 13:23
Re: PL/pgSQL question Milen A. Radev 13:50
FUNCTIONs and CASTs Dean Gibson (DB Administrator) 23:08
Re: FUNCTIONs and CASTs Tom Lane 23:19

Feb. 15, 2008

Thread Author Time
Re: FUNCTIONs and CASTs Dean Gibson (DB Administrator) 01:47
inhibit rounding on numeric columns Horst Dehmer 07:28
Re: inhibit rounding on numeric columns Scott Marlowe 07:42
Re: inhibit rounding on numeric columns Niklas Johansson 07:46
Re: inhibit rounding on numeric columns Bart Degryse 07:53
Function description Bart Degryse 08:50
Re: Function description Richard Huxton 09:09
Re: FUNCTIONs and CASTs Richard Huxton 09:38
Re: Function description Richard Huxton 10:15
Re: Function description Bart Degryse 10:37
Re: Function description Richard Huxton 10:50
Re: Function description Bart Degryse 11:05
Re: Function description Richard Huxton 11:17
Packages Jyoti Seth 11:46

Browse Archives

Prev | Next