Home > mailing lists

Mailing lists [pgsql-sql]

2 January 2004

00:51 Stored procedures beyaRecords - The home Urban music
01:11 Re: Stored procedures Tom Lane
23:18 Ambiguous error message Samuel Tardieu

3 January 2004

00:43 Re: Ambiguous error message Michael Glaesemann
00:44 Re: Ambiguous error message Tom Lane
00:51 Re: Ambiguous error message Samuel Tardieu
00:52 Re: Ambiguous error message Samuel Tardieu
01:01 Re: Ambiguous error message Michael Fuhr
01:10 sort by on two columns Andy Lewis
01:23 Re: Ambiguous error message Bertrand Petit
02:16 Re: sort by on two columns Michael Glaesemann
02:25 Re: sort by on two columns Andy Lewis
02:29 Re: sort by on two columns Michael Glaesemann
03:34 Re: sort by on two columns Adam Ruth
04:21 Re: sort by on two columns Chris Travers

4 January 2004

12:52 DO INSTEAD in rule Tatsuo Ishii
16:49 Re: DO INSTEAD in rule Tom Lane
17:55 Historic Query using a view/function ? Chris Gamache
18:29 "on insert" rules happen before the insert? treat00@yahoo.com (Thomas Reat)
18:29 Re: not in vs not exists - vastly diferent performance Randolf Richardson
18:29 Re: Radius of a zip code Randolf Richardson
18:29 Complex Update John Coryat
18:29 functional index Hijax
22:41 Re: DO INSTEAD in rule Tatsuo Ishii

5 January 2004

00:41 Re: not in vs not exists - vastly diferent performance Iain
04:27 Re: "on insert" rules happen before the insert? Tom Lane
10:07 Virtual records Kumar
10:11 Re: Complex Update Richard Huxton
17:16 ecpg - problem compiling prepare and declare statements Paul Tilles
22:21 Re: Virtual records Rich Hall

6 January 2004

05:09 Calendar Scripts - Quite a complex one Kumar
17:56 Re: Calendar Scripts - Quite a complex one Peter Eisentraut
21:37 Re: Calendar Scripts - Quite a complex one Josh Berkus

7 January 2004

05:09 Re: Calendar Scripts - Quite a complex one Kumar
06:50 Re: Calendar Scripts - Quite a complex one Chris Travers
11:42 Re: Calendar Scripts - Quite a complex one Kumar
12:56 unique constraints Kenneth Gonsalves
16:15 Notation of index Andreas
16:44 Re: unique constraints Michael Fuhr
17:18 Importation wtih copy generated some wrong registers.. Rodrigo Sakai
17:39 Re: Notation of index Richard Huxton
17:46 Re: Notation of index Peter Eisentraut
17:49 Re: Importation wtih copy generated some wrong registers.. Peter Eisentraut

8 January 2004

04:45 Re: unique constraints Kenneth Gonsalves
09:06 Re: Calendar Scripts - Quite a complex one Chris Travers
12:00 Start-up problems beyaRecords - The home Urban music
12:18 Re: Start-up problems Johannes Lochmann
13:01 Re: Start-up problems Kaloyan Iliev Iliev

9 January 2004

01:20 grouping by date teknokrat
01:22 COPY command azwa@nc.com.my
01:23 COPY command azwa@nc.com.my
01:23 Re: unix time -> timestamp boyd
01:27 question : the choice of the primary key. Loeke
01:27 Re: Different query results in psql and Perl DBI with Postgres 7.2.1 boyd
01:28 Different query results in psql and Perl DBI with Postgres 7.2.1 brendanl@iname.com (Brendan LeFebvre)
01:28 Re: question : the choice of the primary key. Loeke
01:29 unix time -> timestamp boyd
01:29 PostgreSQL Array Syntax Evan Klinger
01:47 data loading azwa@nc.com.my
01:50 Date select question... Lance Munslow
02:16 Re: COPY command Gregory S. Williamson
03:33 Re: COPY command azwa@nc.com.my
03:50 Re: COPY command Michael Glaesemann
04:01 Re: grouping by date Robert Creager
04:50 Re: Date select question... Tom Lane
06:36 Type conversion from TEXT to DOUBLE PRECISION Daniel Lau
06:37 Missing data for column azwa@nc.com.my
06:48 Re: Type conversion from TEXT to DOUBLE PRECISION Tom Lane
07:10 Re: Type conversion from TEXT to DOUBLE PRECISION Richard Huxton
08:55 Re: Missing data for column Michael Glaesemann
15:42 Re: Type conversion from TEXT to DOUBLE PRECISION Tom Lane
16:16 Re: Type conversion from TEXT to DOUBLE PRECISION Daniel Lau
19:05 Re: data loading Richard Huxton
19:06 Re: data loading Richard Huxton
22:06 how to show table structure? Bing Du
22:13 Re: how to show table structure? Larry Rosenman
22:29 Re: how to show table structure? scott.marlowe

10 January 2004

03:07 Re: how to show table structure? Kumar
06:55 Adding a column to a VIEW which has dependent objects. Rajesh Kumar Mallah
15:49 Re: Adding a column to a VIEW which has dependent objects. Tom Lane
17:29 Re: data loading Jeff Eckermann

11 January 2004

18:20 Re: Different query results in psql and Perl DBI with Postgres 7.2.1 Greg Sabino Mullane
18:26 Left outer join on multiple tables David Witham
18:56 Re: Left outer join on multiple tables Peter Eisentraut

12 January 2004

00:10 Select into beyaRecords - The home Urban music
00:29 Re: Missing data for column azwa@nc.com.my
03:06 Problem with NOT IN portion of query. Robert Creager
04:51 Unique key field or serverl fks ? katarn
05:28 Re: Problem with NOT IN portion of query. Tomasz Myrta
08:33 Insert into azwa@nc.com.my
08:46 Re: Select into Richard Huxton
08:53 Re: Unique key field or serverl fks ? Richard Huxton
12:07 Re: Problem with NOT IN portion of query. Robert Creager
15:15 Triggers beyaRecords - The home Urban music
15:34 Re: Triggers Peter Eisentraut
15:42 Re: Triggers Sai Hertz And Control Systems
15:54 Re: Adding a column to a VIEW which has dependent objects. scott.marlowe
16:11 Re: Triggers Richard Huxton
20:37 Re: Unique key field or serverl fks ? katarn

13 January 2004

00:13 Transpose rows to columns David Witham
02:51 Re: Transpose rows to columns Michael Glaesemann
08:12 Re: Triggers BenLaKnet
10:31 Re: Insert into Gabriel Dovalo Carril
12:43 problem with function trigger jclaudio@capitol.fr
13:05 Problems with postgresql 7.4.1 configuration - URGENT beyaRecords - The home Urban music
13:19 Email function using c instead of tclu beyaRecords - The home Urban music
14:31 Re: Problems with postgresql 7.4.1 configuration - URGENT Peter Eisentraut
14:55 Re: Problems with postgresql 7.4.1 configuration - URGENT Tom Lane
15:06 Re: Problems with postgresql 7.4.1 configuration - URGENT Sai Hertz And Control Systems
15:24 Copying rows between tables? Steve Wampler
15:29 Re: Copying rows between tables? Viorel Dragomir
15:33 Re: Copying rows between tables? Reinoud van Leeuwen
16:29 can insert 'null' into timestamp type field from command line but not from input file? Bing Du
16:45 Re: can insert 'null' into timestamp type field from command Bing Du
16:52 Re: can insert 'null' into timestamp type field from command scott.marlowe
17:44 Re: Copying rows between tables? Sai Hertz And Control Systems
17:46 Configure issues beyaRecords - The home Urban music
18:36 Re: Configure issues Peter Eisentraut
20:36 Rule won't let me NOTIFY, no matter how hard I try Jeff Boes
20:41 Historical logging of pg_stat_activity ? Stef

14 January 2004

07:01 Re: Insert into:Bad date external representation azwa@nc.com.my
07:25 Re: Insert into:Bad date external representation Michael Glaesemann
20:10 Re: Transpose rows to columns Luis C. Ferreira (aka lcf)
21:48 REPOST[GENERAL] Quoting for a Select Into - Please Help A E
23:52 Atomic query and update of sequence generators Jeffrey Tenny

15 January 2004

02:17 Re: REPOST[GENERAL] Quoting for a Select Into - Please Help Stuart Barbee
02:30 Re: Atomic query and update of sequence generators Tom Lane
11:48 Re: Atomic query and update of sequence generators Greg Sabino Mullane
17:36 Re: Rule won't let me NOTIFY, no matter how hard I try Luis C. Ferreira
17:39 Problem with plpgsql function Chris Bowlby
17:48 Re: Problem with plpgsql function Joe Conway
18:05 Re: Problem with plpgsql function Chris Bowlby

16 January 2004

03:32 Initially Deffered - FK Denis
04:19 Re: Initially Deffered - FK Stephan Szabo
08:01 Re: Email function using c instead of tclu Christoph Haller
09:35 Re: problem with function trigger Christoph Haller
10:31 sql query with join and parameter in postgresql function Philippe Lang
10:44 Re: sql query with join and parameter in postgresql function Michael Glaesemann
12:03 Re: sql query with join and parameter in postgresql function Philippe Lang

17 January 2004

07:00 count(*) from cursor Yuri Gordienko

18 January 2004

13:15 Re: Is it possible in PostgreSQL? Chris Travers
19:51 Problem with LEFT JOIN Thomas Wegner
20:13 Left joins with multiple tables Colin Fox
20:17 simple tree in postgress nkunkov@optonline.net (Liza)
20:21 Re: Triggers Benoît BOURNON
20:25 Re: Transpose rows to columns Luis C. Ferreira (aka lcf)
20:37 Unique field key or several fks ? Katarn
20:42 problem with function trigger jclaudio@capitol.fr
20:46 help with limiting query results OizOne
20:46 DROP TRIGGER sad
20:46 Trigger to identify which column(s) updated Jack Kerkhof
20:47 Initially Deffered - FK denis@coralindia.com
20:48 Re: Initially Deffered - FK denis@coralindia.com
21:40 Re: Trigger to identify which column(s) updated Vishal Kashyap @ [Sai Hertz And Control Systems]
21:45 Re: Left joins with multiple tables Richard Poole
23:11 Re: Is it possible in PostgreSQL? Jim Johannsen

19 January 2004

01:59 Execute permissions for stored functions Paul Hart
03:11 Re: Problem with LEFT JOIN Tom Lane
03:30 How can I get the last element out of GROUP BY sets? Robert Creager
03:55 Re: help with limiting query results Tom Lane
03:57 Re: Left joins with multiple tables Denis
04:41 Re: Execute permissions for stored functions Tom Lane
04:45 Re: How can I get the last element out of GROUP BY sets? Tom Lane
05:20 Re: DROP TRIGGER Tom Lane
09:14 Re: How can I get the last element out of GROUP BY sets? Christoph Haller
09:35 Re: Initially Deffered - FK Stephan Szabo
10:35 name of a column returned from a table function Iain
11:10 Re: Initially Deffered - FK Denis
14:08 Re: name of a column returned from a table function Tom Lane
16:40 Re: How can I get the last element out of GROUP BY sets? Robert Creager

20 January 2004

04:26 Re: Trigger to identify which column(s) updated V i s h a l Kashyap @ [Sai Hertz And Control Systems]
05:39 Database diagram Ganesan Kanavathy
06:00 Re: Database diagram Denis
06:14 Fetching a single column from a record returning function Kumar
06:17 Re: Database diagram Roberto Mello
06:36 Re: Database diagram Gregory S. Williamson
12:25 comparing nulls Kenneth Gonsalves
12:56 Re: comparing nulls Chris Bowlby
13:06 Re: comparing nulls D'Arcy J.M. Cain
13:31 Re: Database diagram Luis Sousa
13:34 Re: comparing nulls Reinoud van Leeuwen
13:42 Re: comparing nulls Kenneth Gonsalves
14:04 Re: comparing nulls Chris Bowlby
14:30 Re: comparing nulls Guy Fraser
14:54 Re: comparing nulls Jeff Eckermann
14:58 Re: Fetching a single column from a record returning function Tom Lane
15:15 Re: Fetching a single column from a record returning function Joe Conway
15:38 Re: comparing nulls Christopher Browne

21 January 2004

06:06 Re: Fetching a single column from a record returning function Kumar
07:10 cygwin warnings in the log file Terence Kearns
08:15 time series data azwa@nc.com.my
08:36 Re: time series data Tomasz Myrta
10:35 Re: time series data Tomasz Myrta
13:03 array_lower /array_prepend doubt Rajesh Kumar Mallah
14:56 Re: array_lower /array_prepend doubt Stephan Szabo
16:41 Re: array_lower /array_prepend doubt Tom Lane
17:20 Re: array_lower /array_prepend doubt Joe Conway
17:33 Re: array_lower /array_prepend doubt Tom Lane
18:13 Re: array_lower /array_prepend doubt Tom Lane
18:16 Re: array_lower /array_prepend doubt Joe Conway
18:17 Re: array_lower /array_prepend doubt Joe Conway
18:33 Re: array_lower /array_prepend doubt Tom Lane

22 January 2004

01:06 Batch Updates problem beyaRecords - The home Urban music
01:36 Batch Updates issue beyaRecords - The home Urban music
08:43 Re: Database diagram Chris Travers
11:14 Batch update issue beyaRecords - The home Urban music

23 January 2004

01:24 Re: How can I get the last element out of GROUP BY sets? Greg Stark
11:20 Fw: postgres logging Stef
11:51 Re: Fw: postgres logging [SOLVED] Stef
13:29 JDBC Batch Updates beyaRecords - The home Urban music
16:43 Re: JDBC Batch Updates pginfo
17:17 Re: [ADMIN] Database diagram Rajesh Kumar Mallah

24 January 2004

04:07 Re: [ADMIN] Fw: postgres logging A.Bhuvaneswaran

26 January 2004

19:45 Label Security James Taylor
20:06 Re: Label Security Bruno Wolff III
23:13 how to "enumerate" rows ? Karsten Hilbert
23:50 Re: Label Security James Taylor

27 January 2004

00:09 Re: how to "enumerate" rows ? Tom Lane
01:23 Re: Label Security Bruno Wolff III
08:35 Re: time series data azwa@nc.com.my
08:56 Re: time series data Tomasz Myrta
10:37 PgSQL Down Cavit Keskin
10:53 postgreSQl 7.4.1 and Hibernate beyaRecords - The home Urban music
10:56 Re: PgSQL Down Devrim GUNDUZ
15:59 Re: [BUGS] PgSQL Down Tom Lane
22:13 Re: postgreSQl 7.4.1 and Hibernate Josh Berkus

28 January 2004

04:24 Query TIME ZONE Raman
04:59 Re: Query TIME ZONE Tom Lane
05:42 Aggregate function error in 7.4 j knight
06:03 Re: Query TIME ZONE Raman Garg
06:50 Re: Aggregate function error in 7.4 Tom Lane
10:24 limit 1 and functional indexes Alexandra Birch
15:33 postgres timeout. Stef
15:49 Re: postgres timeout. Tom Lane
15:59 Re: postgres timeout. [SOLVED] Stef
16:39 Re: postgres timeout. Stef
17:00 managing users in postgresql 7.4.1 Przemysław Słupkowski
17:04 Question about isolation Samuel Tardieu
18:38 Re: Aggregate function error in 7.4 j knight
19:13 Re: Question about isolation Chester Kustarz
19:37 Re: Question about isolation Chester Kustarz
20:46 Re: Question about isolation Samuel Tardieu
22:03 Re: Question about isolation Tom Lane

29 January 2004

03:27 LEFT JOIN on one and/or another column Octavio Alvarez
05:11 SQL Query for Top Down fetching of childs Kumar
07:28 auto_insert jodi
07:32 Re: auto_insert Viorel Dragomir
08:28 Re: time series data azwa@nc.com.my
09:28 Re: SQL Query for Top Down fetching of childs Richard Huxton
11:12 query not using index for descending records? email lists
11:51 Re: limit 1 and functional indexes Bruno Wolff III
11:59 Re: LEFT JOIN on one and/or another column Bruno Wolff III
12:00 Re: SQL Query for Top Down fetching of childs Kumar
12:03 MUKTA
12:10 Re: Viorel Dragomir
12:18 Re: query not using index for descending records? Bruno Wolff III
12:32 Re: query not using index for descending records? Achilleus Mantzios
12:36 Re:
13:06 Re: query not using index for descending records? Bruno Wolff III
13:11 Re: MUKTA
14:02 Re: limit 1 and functional indexes Alexandra Birch
14:05 Re: query not using index for descending records? Achilleus Mantzios
14:07 How to retrieve N lines of a text field. Chris Travers
14:11 Re: limit 1 and functional indexes Bruno Wolff III
14:51 Re: How to retrieve N lines of a text field. Tom Lane
15:08 Re: query not using index for descending records? Stephan Szabo
15:36 java.lang.StringIndexOutOfBoundsException: String index out of range: 23 at java.lang.String.charAt(String.java:460) mohan@physics.gmu.edu
15:55 Re: java.lang.StringIndexOutOfBoundsException: String index Achilleus Mantzios
16:25 Re: query not using index for descending records? Tom Lane
16:54 Re: How to retrieve N lines of a text field. Joe Conway
17:28 Re: query not using index for descending records? Stephan Szabo
17:41 Re: LEFT JOIN on one and/or another column (thanks) Octavio Alvarez
17:41 Re: query not using index for descending records? Tom Lane
18:23 Re: [PERFORM] Set-Returning Functions WAS: On the performance of views Josh Berkus
19:51 Re: java.lang.StringIndexOutOfBoundsException: String index mohan@physics.gmu.edu
22:19 Re: [PERFORM] Set-Returning Functions WAS: On the performance of views Josh Berkus
22:24 Re: java.lang.StringIndexOutOfBoundsException: String index Josh Berkus

30 January 2004

02:06 Re: Chris Travers
05:08 Re: limit 1 and functional indexes Greg Stark
06:41 locking problem cheater cheater
08:03 Re: java.lang.StringIndexOutOfBoundsException: String index Achilleus Mantzios
08:06 Re: limit 1 and functional indexes: SOLVED Alexandra Birch
08:57 Re: limit 1 and functional indexes: SOLVED Greg Stark
11:13 Empty String Comparison Standard compliant? Christoph Haller
14:19 Re: Empty String Comparison Standard compliant? Tom Lane
14:29 Re: Empty String Comparison Standard compliant? Stephan Szabo
15:05 PROBLEM SOLVEDRe: java.lang.StringIndexOutOfBoundsException: String index mohan@physics.gmu.edu

31 January 2004

04:03 Re: query not using index for descending records? email lists
09:51 Mechanics of Update:Cascade beyaRecords - The home Urban music
14:23 Re: [NOVICE] 'select nextval('seq_name');' in a function ? Stephan Szabo
14:25 Re: Mechanics of Update:Cascade Stephan Szabo
16:42 Re: Mechanics of Update:Cascade Richard Huxton
19:02 Sometimes referential integrity seems not to work Enio Schutt Junior
19:02 'select nextval('seq_name');' in a function ? Pragati Kenkare
19:04 An order by question David Arnold
19:05 Mechanics of UpDate:Cascade beyaNet Consultancy
20:41 Re: Sometimes referential integrity seems not to work Stephan Szabo
22:41 Re: Sometimes referential integrity seems not to work Tom Lane