Home > mailing lists

Mailing lists [pgsql-sql]

1 February 2008

14:24 aggregate reverse Marcin Krawczyk
16:34 Re: aggregate reverse Pavel Stehule

2 February 2008

07:48 Re: aggregate reverse Marcin Krawczyk
22:22 can a insert with a returning clause be subquery ? chrisj
23:12 Re: can a insert with a returning clause be subquery ? Jonah H. Harris
23:38 Re: can a insert with a returning clause be subquery ? Adrian Klaver

3 February 2008

00:27 Re: can a insert with a returning clause be subquery ? Jonah H. Harris
10:44 Helper aggregate function sergey kapustin
17:58 Re: Helper aggregate function Robins Tharakan
19:07 Re: Helper aggregate function Christian Kindler

5 February 2008

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

6 February 2008

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

7 February 2008

00:09 accounting schema Medi Montaseri
00:34 Re: Information schema permissions johnf
01:35 Re: accounting schema Steve Midgley
01:54 Re: accounting schema Medi Montaseri
02:03 Re: accounting schema Robert Edwards
02:36 Re: accounting schema Steve Midgley
06:16 Re: TG_TABLE_NAME as identifier Tiziano Slack
06:52 Re: TG_TABLE_NAME as identifier Richard Huxton
13:08 Re: accounting schema John Hasler
14:52 Re: accounting schema Tony Wasson
15:10 Re: accounting schema johnf
22:10 Re: TG_TABLE_NAME as identifier Tiziano Slack

8 February 2008

09:05 performance issue - view and derived field Gary Stainburn
10:16 Serial not nulla Shavonne Marietta Wijesinghe
12:05 Postgres roles Pascal Tufenkji
12:18 Re: Serial not nulla Shane Ambler
12:54 Re: Postgres roles Shane Ambler
13:56 Re: Postgres roles Pascal Tufenkji
20:05 What are the (various) best practices/opinions for table/column/constraint naming? Ken Johanson

9 February 2008

09:58 Re: What are the (various) best practices/opinions for table/column/constraint naming? Karsten Hilbert
13:16 Re: Postgres roles Shane Ambler

11 February 2008

01:48 Can CREATE TYPE be used to create a synonym? Dean Gibson (DB Administrator)
02:14 Re: Can CREATE TYPE be used to create a synonym? Tom Lane
02:16 Re: Can CREATE TYPE be used to create a synonym? Tom Lane
04:06 Re: Bouncing replies Dean Gibson (DB Administrator)
07:54 Re: Bouncing replies Dave Page
09:15 Re: Bouncing replies Dean Gibson (DB Administrator)
09:38 Re: Serial not nulla Shavonne Marietta Wijesinghe
09:38 Usage of UUID with 8.3 (Windows) ncode@gmx.com
09:46 Re: Bouncing replies Dave Page
11:04 Check before INSERT INTO Shavonne Marietta Wijesinghe
12:14 Re: Check before INSERT INTO Shavonne Marietta Wijesinghe
15:04 Re: Check before INSERT INTO Gregory Stark
15:23 Re: Check before INSERT INTO Shavonne Marietta Wijesinghe
15:56 Re: Check before INSERT INTO Gregory Stark
15:56 Re: Usage of UUID with 8.3 (Windows) Tom Lane
16:00 Re: Check before INSERT INTO Jean-David Beyer
16:04 Re: Usage of UUID with 8.3 (Windows) Alvaro Herrera
16:35 Re: Usage of UUID with 8.3 (Windows) Tom Lane

12 February 2008

05:34 PostgreSQL does not support updateable cursors Premsun Choltanwanich
07:21 Backward compatibility psql 8.1 to 8.2 Bryce Nesbitt
07:25 Re: Proposed archival read only trigger on rows - prevent history modification Bryce Nesbitt
07:29 Re: Proposed archival read only trigger on rows - prevent history modification Bryce Nesbitt
07:33 Re: Backward compatibility psql 8.1 to 8.2 Richard Huxton
09:14 Usage of UUID with 8.3 (Windows) Sven Sporer
09:21 Re: Check before INSERT INTO Shavonne Marietta Wijesinghe
09:35 Re: Check before INSERT INTO Richard Huxton
10:06 Re: Check before INSERT INTO Shavonne Marietta Wijesinghe
11:01 Re: Check before INSERT INTO Richard Huxton
17:15 Re: Usage of UUID with 8.3 (Windows) Steve Midgley

13 February 2008

09:54 return field from different table conditionally Bart Degryse
15:29 Like problem Campbell, Lance
15:42 Re: Like problem Richard Huxton
15:52 Re: Like problem Tom Lane
15:58 Re: Like problem Campbell, Lance
16:01 Re: Like problem Campbell, Lance
16:02 Re: Like problem Campbell, Lance
16:09 Re: Like problem Richard Huxton
16:16 Re: return field from different table conditionally Bart Degryse

14 February 2008

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

15 February 2008

00:47 Re: FUNCTIONs and CASTs Dean Gibson (DB Administrator)
06:27 inhibit rounding on numeric columns Horst Dehmer
06:42 Re: inhibit rounding on numeric columns Scott Marlowe
06:46 Re: inhibit rounding on numeric columns Niklas Johansson
06:54 Re: inhibit rounding on numeric columns Bart Degryse
07:50 Function description Bart Degryse
08:57 Re: Function description Richard Huxton
09:03 Re: FUNCTIONs and CASTs Richard Huxton
09:15 Re: Function description Richard Huxton
09:38 Re: Function description Bart Degryse
09:50 Re: Function description Richard Huxton
10:05 Re: Function description Bart Degryse
10:18 Re: Function description Richard Huxton
10:47 Packages Jyoti Seth
10:47 Re: Function description Gavin 'Beau' Baumanis
11:16 Re: Packages Bart Degryse
11:19 Re: Function description Bart Degryse
11:21 Re: Function description Bart Degryse
11:33 Re: Function description Gavin 'Beau' Baumanis
12:00 Re: Function description Bart Degryse
15:09 String function to Find how many times str2 is in str1? Emi Lu
16:46 Re: String function to Find how many times str2 is in str1? Rodrigo E. De León Plicet
17:18 Re: FUNCTIONs and CASTs Dean Gibson (DB Administrator)
17:23 Re: String function to Find how many times str2 is in str1? Pavel Stehule
17:28 Re: String function to Find how many times str2 is in str1? Emi Lu
21:32 Re: FUNCTIONs and CASTs Tom Lane
22:03 Re: FUNCTIONs and CASTs Dean Gibson (DB Administrator)
23:46 Re: FUNCTIONs and CASTs Dean Gibson (DB Administrator)

16 February 2008

03:31 Re: Backward compatibility psql 8.1 to 8.2 Bryce Nesbitt
04:22 Re: Backward compatibility psql 8.1 to 8.2 Scott Marlowe

17 February 2008

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

18 February 2008

01:17 comment on COLUMN, broken or misunderstanding? Bryce Nesbitt
03:40 Re: comment on COLUMN, broken or misunderstanding? Tom Lane
03:42 Re: comment on COLUMN, broken or misunderstanding? Markus Bertheau
03:45 Re: comment on COLUMN, broken or misunderstanding? Milen A. Radev
03:48 Re: comment on COLUMN, broken or misunderstanding? Michael Fuhr

19 February 2008

09:01 SELECT DISTINCT Shavonne Marietta Wijesinghe
09:58 Am I wasting my time with partitions? Stuart Brooks
11:49 UPDATE with ORDER BY Robins Tharakan
12:48 Re: Am I wasting my time with partitions? Richard Huxton
12:51 Re: SELECT DISTINCT Richard Huxton
13:10 Re: Am I wasting my time with partitions? Stuart Brooks

21 February 2008

16:47 Data layer migration from MSSQL Sebastian Rychter
17:43 Re: Data layer migration from MSSQL Medi Montaseri
17:56 Re: Data layer migration from MSSQL Sebastian Rychter

22 February 2008

02:32 Re: Proposed archival read only trigger on rows - prevent history modification Robert Treat
03:12 Re: Proposed archival read only trigger on rows - prevent history modification Phillip Smith
07:32 postgresql function not accepting null values in select statement Jyoti Seth
08:05 Re: postgresql function not accepting null values in select statement Richard Huxton
08:24 Re: postgresql function not accepting null values in select statement Jyoti Seth
08:34 Re: postgresql function not accepting null values in select statement Richard Huxton
08:34 Re: postgresql function not accepting null values in select statement Robins Tharakan
08:36 Re: postgresql function not accepting null values inselect statement Bart Degryse
17:07 Delete with foreign keys felix@crowfix.com
18:04 SQL standards in Mysql Ken Johanson
18:57 Re: SQL standards in Mysql Alvaro Herrera
21:01 Re: postgresql function not accepting null values inselect statement johnf
23:13 Re: SQL standards in Mysql Scott Marlowe

23 February 2008

01:01 Re: SQL standards in Mysql Dean Gibson (DB Administrator)
04:03 Re: SQL standards in Mysql Scott Marlowe
04:34 Re: SQL standards in Mysql Scott Marlowe
04:50 Re: SQL standards in Mysql Tom Lane
06:17 Re: Delete with foreign keys dipesh
06:47 Re: Delete with foreign keys felix@crowfix.com

24 February 2008

15:17 Re: SQL standards in Mysql Aarni Ruuhimäki

25 February 2008

04:37 Re: postgresql function not accepting null values inselect statement Jyoti Seth
05:38 autovacuum not freeing up unused space on 8.3.0 Stuart Brooks
06:02 Re: autovacuum not freeing up unused space on 8.3.0 Stuart Brooks
06:03 Re: postgresql function not accepting null values inselect statement Robins Tharakan
06:14 Re: postgresql function not accepting null values inselect statement Robins Tharakan
07:20 Re: postgresql function not accepting null valuesinselect statement Bart Degryse
20:08 Re: Bouncing replies [was: SQL standards in Mysql] Dean Gibson (DB Administrator)
20:29 Re: Bouncing replies [was: SQL standards in Mysql] Dave Page
20:57 Re: Bouncing replies [was: SQL standards in Mysql] Colin Wetherbee
23:42 Re: Bouncing replies [was: SQL standards in Mysql] Scott Marlowe

26 February 2008

02:13 Bounce test Dean Gibson (DB Administrator)
02:16 Re: Bounce test Adrian Klaver
02:19 Re: Bounce test Adrian Klaver
02:24 Re: Bounce test Tom Lane
02:26 Re: Bouncing replies [was: SQL standards in Mysql] Scott Marlowe
02:28 Re: Bounce test Scott Marlowe
02:30 Re: Bounce test Scott Marlowe
02:32 Re: Bounce test Scott Marlowe
02:36 Re: Bouncing replies [was: SQL standards in Mysql] D'Arcy J.M. Cain
02:36 Re: Bounce test Colin Wetherbee
02:53 Re: Bounce test Adrian Klaver
03:07 Re: Bounce test Scott Marlowe
04:07 Re: Bounce test Adrian Klaver
14:02 Re: Deploying PostgreSQL on virtualized hardware TJ O'Donnell
14:08 duplicate key violates unique constraint Shavonne Marietta Wijesinghe
14:26 Re: duplicate key violates unique constraint Teemu Torma
15:05 Re: duplicate key violates unique constraint Shavonne Marietta Wijesinghe
15:23 Re: duplicate key violates unique constraint Andrew Sullivan
15:28 Re: duplicate key violates unique constraint Teemu Torma
15:32 Function returns error (view) Professor Flávio Brito
15:34 Re: duplicate key violates unique constraint Bart Degryse
15:36 Re: Function returns error (view) Colin Wetherbee
15:44 Re: duplicate key violates unique constraint Shavonne Marietta Wijesinghe
15:49 Re: Function returns error (view) Professor Flávio Brito
16:00 Re: Function returns error (view) Bart Degryse
16:04 Re: duplicate key violates unique constraint Alvaro Herrera
16:10 Re: duplicate key violates unique constraint Rodrigo E. De León Plicet
17:23 Re: Function returns error (view) Professor Flávio Brito
19:03 Re: duplicate key violates unique constraint Edward W. Rouse

27 February 2008

06:53 Re: Function returns error (view) Bart Degryse
08:10 Re: Function returns error (view) Markus Bertheau
08:17 Re: Function returns error (view) Bart Degryse
08:32 REFERENCES and INHERITS restrictions? Stefan Scheidegger
08:44 Re: Function returns error (view) Markus Bertheau
10:50 how do I get table DDL from psql (not from pg_dump) Sofer, Yuval
11:19 Re: how do I get table DDL from psql (not from pg_dump) A. Kretschmer
13:04 Re: REFERENCES and INHERITS restrictions? Gregory Stark
16:34 Re: how do I get table DDL from psql (not from pg_dump) Frank Bax
17:51 Re: SQL standards in Mysql Steve Crawford
19:42 Re: Function returns error (view) Professor Flávio Brito
21:40 operator class miquel_ibanez
23:02 Subselects returning array and ANY... Dawid Kuroczko
23:08 Re: Subselects returning array and ANY... Josh Berkus
23:34 Re: Subselects returning array and ANY... Dawid Kuroczko
23:44 Re: Subselects returning array and ANY... Josh Berkus

28 February 2008

04:30 Re: operator class Tom Lane
06:46 Re: Function returns error (view) Bart Degryse
15:09 Re: Function returns error (view) (RESOLVED) Professor Flávio Brito
18:11 pl/pgsql and error handling Alex Hochberger

29 February 2008

03:43 Re: pl/pgsql and error handling Tom Lane
04:29 Re: pl/pgsql and error handling Alex Hochberger
06:44 Re: pl/pgsql and error handling Bart Degryse