pgsql-sql - February 2008

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 5 6 7 8 9 11 12 13 14 15 16 17 18 19 21 22 23 25 26 27 28 29

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
Re: Function description 📎 Gavin 'Beau' Baumanis 11:46
Re: Packages Bart Degryse 12:16
Re: Function description Bart Degryse 12:18
Re: Function description Bart Degryse 12:21
Re: Function description 📎 Gavin 'Beau' Baumanis 12:33
Re: Function description Bart Degryse 13:00
String function to Find how many times str2 is in str1? Emi Lu 16:09
Re: String function to Find how many times str2 is in str1? Rodrigo E. De León Plicet 17:46
Re: FUNCTIONs and CASTs Dean Gibson (DB Administrator) 18:18
Re: String function to Find how many times str2 is in str1? Pavel Stehule 18:23
Re: String function to Find how many times str2 is in str1? Emi Lu 18:28
Re: FUNCTIONs and CASTs Tom Lane 22:32
Re: FUNCTIONs and CASTs Dean Gibson (DB Administrator) 23:03

Feb. 16, 2008

Thread Author Time
Re: FUNCTIONs and CASTs Dean Gibson (DB Administrator) 00:45
Re: Backward compatibility psql 8.1 to 8.2 Bryce Nesbitt 04:32
Re: Backward compatibility psql 8.1 to 8.2 Scott Marlowe 05:22

Feb. 17, 2008

Thread Author Time
Re: Usage of UUID with 8.3 (Windows) Peter Eisentraut 15:20
Re: PostgreSQL does not support updateable cursors Peter Eisentraut 15:21
Re: Backward compatibility psql 8.1 to 8.2 Peter Eisentraut 15:23

Feb. 18, 2008

Thread Author Time
comment on COLUMN, broken or misunderstanding? Bryce Nesbitt 02:18
Re: comment on COLUMN, broken or misunderstanding? Tom Lane 02:35
Re: comment on COLUMN, broken or misunderstanding? Markus Bertheau 02:39
Re: comment on COLUMN, broken or misunderstanding? Milen A. Radev 02:50
Re: comment on COLUMN, broken or misunderstanding? Michael Fuhr 04:38

Feb. 19, 2008

Thread Author Time
SELECT DISTINCT Shavonne Marietta Wijesinghe 10:01
Am I wasting my time with partitions? Stuart Brooks 10:54
UPDATE with ORDER BY Robins Tharakan 12:49
Re: Am I wasting my time with partitions? Richard Huxton 13:48
Re: SELECT DISTINCT Richard Huxton 13:51
Re: Am I wasting my time with partitions? Stuart Brooks 14:05

Feb. 21, 2008

Thread Author Time
Data layer migration from MSSQL Sebastian Rychter 17:47
Re: Data layer migration from MSSQL Medi Montaseri 18:42
Re: Data layer migration from MSSQL Sebastian Rychter 18:55

Feb. 22, 2008

Thread Author Time
Re: Proposed archival read only trigger on rows - prevent history modification Robert Treat 03:31
Re: Proposed archival read only trigger on rows - prevent history modification Phillip Smith 04:09
postgresql function not accepting null values in select statement Jyoti Seth 08:30
Re: postgresql function not accepting null values in select statement Richard Huxton 09:05
Re: postgresql function not accepting null values in select statement Jyoti Seth 09:22
Re: postgresql function not accepting null values in select statement Richard Huxton 09:33
Re: postgresql function not accepting null values in select statement Robins Tharakan 09:34
Re: postgresql function not accepting null values inselect statement Bart Degryse 09:35
Re: postgresql function not accepting null values inselect statement johnf 16:30
Delete with foreign keys felix 18:00
SQL standards in Mysql Ken Johanson 18:57
Re: SQL standards in Mysql Alvaro Herrera 19:57

Feb. 23, 2008

Thread Author Time
Re: SQL standards in Mysql Scott Marlowe 00:13
Re: SQL standards in Mysql Dean Gibson (DB Administrator) 01:39
Re: SQL standards in Mysql Scott Marlowe 05:03
Re: SQL standards in Mysql Scott Marlowe 05:34
Re: SQL standards in Mysql Tom Lane 05:50
Re: Delete with foreign keys dipesh 07:12
Re: Delete with foreign keys felix 07:47
Re: SQL standards in Mysql Aarni Ruuhimäki 21:06

Feb. 25, 2008

Thread Author Time
Re: postgresql function not accepting null values inselect statement Jyoti Seth 05:20
autovacuum not freeing up unused space on 8.3.0 Stuart Brooks 06:27
Re: postgresql function not accepting null values inselect statement Robins Tharakan 06:56
Re: autovacuum not freeing up unused space on 8.3.0 Stuart Brooks 06:57
Re: postgresql function not accepting null values inselect statement Robins Tharakan 07:03
Re: postgresql function not accepting null valuesinselect statement Bart Degryse 08:05
Re: Bouncing replies [was: SQL standards in Mysql] Dean Gibson (DB Administrator) 21:08
Re: Bouncing replies [was: SQL standards in Mysql] Dave Page 21:29
Re: Bouncing replies [was: SQL standards in Mysql] Colin Wetherbee 21:33

Feb. 26, 2008

Thread Author Time
Re: Bouncing replies [was: SQL standards in Mysql] Scott Marlowe 00:42
Bounce test Dean Gibson (DB Administrator) 03:13
Re: Bounce test Adrian Klaver 03:17
Re: Bounce test Adrian Klaver 03:20
Re: Bounce test Tom Lane 03:24
Re: Bouncing replies [was: SQL standards in Mysql] Scott Marlowe 03:26
Re: Bounce test Scott Marlowe 03:28
Re: Bounce test Scott Marlowe 03:29
Re: Bounce test Scott Marlowe 03:32
Re: Bounce test Colin Wetherbee 03:36
Re: Bouncing replies [was: SQL standards in Mysql] D'Arcy J.M. Cain 03:36
Re: Bounce test Adrian Klaver 03:54
Re: Bounce test Scott Marlowe 04:07
Re: Bounce test Adrian Klaver 05:08
duplicate key violates unique constraint Shavonne Marietta Wijesinghe 14:55
Re: Deploying PostgreSQL on virtualized hardware TJ O'Donnell 14:56

Browse Archives

Prev | Next
Jump to day: 1 2 3 5 6 7 8 9 11 12 13 14 15 16 17 18 19 21 22 23 25 26 27 28 29