Home > mailing lists

Mailing lists [pgsql-sql]

1 June 2003

02:55 postgresql and the industry DIB Walid
02:56 PostgreSQL and industry walid.dib
02:56 Re: tablename as attribute in pgplsql Benoît Bournon
02:56 Help required on update query Vikas
02:56 Upgrade 7.2.3 -> 7.3 or more Benoît Bournon
02:56 Re: Index scan never executed? Morten Tryfoss
02:56 How can I use a name of table in attribute of function, I try PREPARE ... Benoît Bournon
03:28 generic return for functions Danny Su
04:10 Re: generic return for functions Avi Schwartz
04:33 Re: generic return for functions Joe Conway
11:03 Re: Upgrade 7.2.3 -> 7.3 or more Rod Taylor
11:21 Re: generic return for functions Rod Taylor
14:22 Re: generic return for functions Avi Schwartz
14:48 Re: generic return for functions Tom Lane
15:16 Re: generic return for functions Avi Schwartz
17:36 Re: PostgreSQL and industry Josh Berkus
17:46 Re: generic return for functions Josh Berkus

2 June 2003

04:30 SQL problem: bank account Erik G. Burrows
05:15 Re: SQL problem: bank account Andrew J. Kopciuch
05:21 Re: SQL problem: bank account Sean Chittenden
06:50 Re: SQL problem: bank account listrec
06:52 Re: CASE returning multiple values (was SQL Help) Richard Huxton
12:36 Using & - operator Rado Petrik
12:43 Re: SQL problem: bank account Tom Lane
13:26 Re: SQL problem: bank account Dmitry Tkach
13:29 Re: Using & - operator Dmitry Tkach
15:25 Maintaining a counter up-to-date Samuel Tardieu
15:41 Re: SQL problem: bank account Jonathan Gardner
15:42 Re: SQL problem: bank account Jonathan Gardner
16:04 Re: SQL problem: bank account Erik G. Burrows
17:28 Re: Maintaining a counter up-to-date Richard Huxton
17:30 Re: Maintaining a counter up-to-date Samuel Tardieu

5 June 2003

11:07 To ListAdms: Is pgsql-sql operating? Achilleus Mantzios

6 June 2003

08:30 Re: To ListAdms: Is pgsql-sql operating? Josh Berkus
10:39 Changing owner of function -- best method? Josh Berkus
11:06 simulating partial fkeys..
17:52 Re: simulating partial fkeys.. Bruno Wolff III
18:31 Re: simulating partial fkeys.. Jan Wieck
19:09 Re: simulating partial fkeys.. [ATTN Developers please] Richard Huxton
21:44 Re: To ListAdms: Is pgsql-sql operating? Joerg Hessdoerfer
22:52 Re: Approved

7 June 2003

10:19 Column limits in table/ views A.M.
12:31 EXTERN JOIN with WHEN query javier garcia - CEBAS
23:26 "Join" on delimeter aggregate query Michael A Nachbaur
23:26 Re: simulating partial fkeys.. [ATTN Developers please] Stephan Szabo

8 June 2003

01:02 Elegant SQL solution: Chris Gamache
01:51 (long) What's the problem? David Olbersen
02:44 Re: simulating partial fkeys.. Josh Berkus
08:23 Re: To ListAdms: Is pgsql-sql operating? Chad Thompson
08:56 (long) What's the problem? David Olbersen
09:41 Domains and Joins chester c young
11:05 Change owner of function in 7.2.4? Josh Berkus
11:43 How to make a IN without a table... ? David Pradier
17:40 Re: Changing owner of function -- best method? Dmitry Tkach
19:05 Re: Elegant SQL solution: greg@turnstep.com
19:48 Re: Elegant SQL solution: Josh Berkus
21:10 Re: Changing owner of function -- best method? Tom Lane
21:14 Re: "Join" on delimeter aggregate query Joe Conway
21:42 Creating Views with Column Names based on Distinct Row Data Damien Dougan
22:02 Re: (long) What's the problem? Rod Taylor
23:45 Re: "Join" on delimeter aggregate query Eivind Kvedalen

9 June 2003

00:58 Using a RETURN NEXT Mr Weinbach, Larry
02:44 Re: Using a RETURN NEXT Joe Conway
06:38 Re: (long) What's the problem? Jan Wieck
07:12 Re: Domains and Joins Rod Taylor
07:14 Re: Elegant SQL solution: Ian Barwick
07:22 Re: "Join" on delimeter aggregate query Bruno Wolff III
07:27 Re: How to make a IN without a table... ? Bruno Wolff III
08:01 Re: EXTERN JOIN with WHEN query Mendola Gaetano
10:03 Re: Column limits in table/ views Rod Taylor

10 June 2003

01:38 Re: "Join" on delimeter aggregate query Tom Lane
03:11 Re: Column limits in table/ views Gaetano Mendola
03:46 Re: "Join" on delimeter aggregate query Tom Lane
03:48 Re: Using a RETURN NEXT Mendola Gaetano
04:43 Re: "Join" on delimeter aggregate query Eivind Kvedalen
04:43 Coalesce/Join/Entries may not exist. James Taylor
04:46 Re: Creating Views with Column Names based on Distinct Frank Bax
04:46 Re: Column limits in table/ views Tom Lane
05:07 how to determine array size Forest Wilkinson
05:27 Re: "Join" on delimeter aggregate query Michael A Nachbaur
05:34 Retype Rado Petrik
05:38 find open transactions/locks in 7.2? george young
08:42 left join in cursor Alexey Dashevsky
08:53 Re: Retype Richard Huxton
08:53 Re: how to determine array size Achilleus Mantzios
11:57 Re: Coalesce/Join/Entries may not exist. Rod Taylor
12:04 Re: how to determine array size Rod Taylor
13:35 Re: left join in cursor Tom Lane
13:56 Re: "Join" on delimeter aggregate query Bruno Wolff III
15:49 trigger error Yudie
15:56 Re: trigger error Dmitry Tkach
16:28 Re: trigger error Mendola Gaetano
17:46 Re: how to determine array size Forest Wilkinson
19:30 Re: how to determine array size Rod Taylor

11 June 2003

08:36 Record size Hilary Forbes
11:01 Re: find open transactions/locks in 7.2? Christoph Haller
13:12 Re: Record size Tom Lane
16:21 Re: Record size Josh Berkus
17:01 Re: Creating Views with Column Names based on Distinct Guy Fraser
18:41 Re: Using a RETURN NEXT Mr Weinbach, Larry

12 June 2003

09:19 How to make a IN without a table... ? David Pradier
11:16 Re: How to make a IN without a table... ? Christoph Haller
11:22 subselects - which is faster? Cedar Cox
11:24 multiple index search with postgres7.1.3 on solaris 8 Marco Vezzoli
11:32 (no subject) A. Van Hook
11:44 Re: (no subject) Achilleus Mantzios
11:47 Re: How to make a IN without a table... ? Bruno Wolff III
11:50 Re: How to make a IN without a table... ? David Pradier
12:04 Re: multiple index search with postgres7.1.3 on solaris 8 Bruno Wolff III
12:06 Re: How to make a IN without a table... ? Bruno Wolff III
12:10 Re: How to make a IN without a table... ? Christoph Haller
12:21 Re: How to make a IN without a table... ? David Pradier
12:22 Some Questions Ludwig Lim
12:24 Re: How to make a IN without a table... ? David Pradier
12:32 Re: multiple index search with postgres7.1.3 on solaris 8 Marco Vezzoli
12:37 Re: How to make a IN without a table... ? Christoph Haller
12:49 Re: How to make a IN without a table... ? David Pradier
13:43 Re: (no subject) Tom Lane
14:13 control structures in plpgsql Robert Treat
14:16 help Tony Simbine
14:24 Re: control structures in plpgsql Stephan Szabo
14:33 Re: Some Questions Stephan Szabo
14:44 Re: control structures in plpgsql Robert Treat
17:13 Re: help Josh Berkus

13 June 2003

01:27 question on rules weigelt@metux.de
01:57 Re: question on rules Tom Lane
11:52 trigger : emulate "instead of" with before ? Albrecht Berger
13:10 Re: trigger : emulate "instead of" with before ? Matthew Nuzum
13:50 Re: trigger : emulate "instead of" with before ? Jeff Eckermann
13:57 Re: trigger : emulate "instead of" with before ? Tom Lane
15:07 create tables within functions Demidem Mohamed Amine
15:22 Re: create tables within functions Stephan Szabo
16:31 Re: question on rules Jan Wieck
19:16 Re: create tables within functions chester c young
19:42 rpm scripts Craig Jensen
21:19 Re: subselects - which is faster? scott.marlowe
21:22 Re: How to make a IN without a table... ? scott.marlowe

14 June 2003

23:32 WHERE of an AGGREGATE ... The Hermit Hacker
23:57 Re: WHERE of an AGGREGATE ... deststar

15 June 2003

00:39 Re: WHERE of an AGGREGATE ... The Hermit Hacker
08:22 Where of an aggregate vali@voxline.ro
15:13 Ordering in an aggregate -- points to paths Julian Scarfe
15:50 Re: Ordering in an aggregate -- points to paths Tom Lane

16 June 2003

07:28 Re: How to make a IN without a table... ? David Pradier
10:33 Let join syntax Nicolas JOUANIN
10:58 Re: Let join syntax Manfred Koizar
13:52 casting interval to time Tomasz Myrta
14:31 Re: Let join syntax Tom Lane
14:40 Re: Let join syntax Manfred Koizar
14:54 Re: casting interval to time Tom Lane
15:00 Re: casting interval to time Tomasz Myrta
15:06 [pgmail] - I have problems with pgmail BenLaKnet
15:17 Re: casting interval to time Tom Lane
15:37 Re: [pgmail] - I have problems with pgmail Tom Lane
15:56 Re: casting interval to time Antti Haapala
16:00 Re: casting interval to time Tomasz Myrta
16:40 Let join syntax Nicolas JOUANIN
17:04 date question javier garcia - CEBAS
17:04 Re: question on rules Tomasz Myrta
17:05 "No such attribute or function 'oid'" javier garcia - CEBAS
17:05 UNION & LIMIT & ORDER BY Emmanuel Engelhart
17:06 Re: Ordering in an aggregate -- points to paths Julian Scarfe
17:23 Re: date question Bruno Wolff III
17:28 Re: "No such attribute or function 'oid'" Tomasz Myrta
17:29 Re: UNION & LIMIT & ORDER BY Guillaume LELARGE
17:51 Re: casting interval to time Tom Lane
19:02 Re: casting interval to time Tom Lane
22:16 Our FLOAT(p) precision does not conform to spec Tom Lane
22:25 unique keys on inherited classes weigelt@metux.de
23:36 Re: [HACKERS] Our FLOAT(p) precision does not conform to spec Bruce Momjian

17 June 2003

00:54 Re: Our FLOAT(p) precision does not conform to spec Richard Hall
01:55 Trouble porting a Oracle PL/SQL procedure to PL/pgSQL Tony G. Harris
02:18 Re: Trouble porting a Oracle PL/SQL procedure to PL/pgSQL Stephan Szabo
02:56 select date range? ko
03:31 Re: select date range? Josh Berkus
03:37 Re: select date range? Ramil G. Sagum
04:43 Re: Trouble porting a Oracle PL/SQL procedure to PL/pgSQL Tom Lane
09:00 Blobs with perl cristi
09:25 Catching DML exceptions in PL/pgSQL Radu-Adrian Popescu
09:44 Re: Catching DML exceptions in PL/pgSQL Tomasz Myrta
09:52 Re: Catching DML exceptions in PL/pgSQL Radu-Adrian Popescu
09:59 Re: Catching DML exceptions in PL/pgSQL Joe Conway
10:49 Re: Catching DML exceptions in PL/pgSQL Radu-Adrian Popescu
11:28 Re: help Tony Simbine
12:04 Re: select date range? scott.marlowe
12:25 yet pg_toast reindex Eric Anderson Vianet SAO
14:29 Re: [HACKERS] Our FLOAT(p) precision does not conform to spec Tom Lane
14:30 Re: Blobs with perl Jonathan Gardner
14:56 Re: yet pg_toast reindex Tom Lane
15:28 CREATE table1 FROM table2 Rado Petrik
15:32 Re: CREATE table1 FROM table2 Devrim GUNDUZ
15:32 Re: CREATE table1 FROM table2 Achilleus Mantzios
15:33 Re: CREATE table1 FROM table2 Nicolas JOUANIN
15:35 Re: CREATE table1 FROM table2 Tomasz Myrta
15:36 Re: Catching DML exceptions in PL/pgSQL Josh Berkus
15:57 Object-Relational table design question Michael A Nachbaur
16:26 Re: Object-Relational table design question Josh Berkus
17:02 Re: CREATE table1 FROM table2 Guillaume LELARGE
17:34 disabling triggers
17:59 Re: disabling triggers Josh Berkus
18:01 Re: [HACKERS] Our FLOAT(p) precision does not conform to spec Peter Eisentraut
18:06 Re: date question Peter Eisentraut
18:17 Re: disabling triggers
18:32 Re: disabling triggers Josh Berkus
18:36 join syntax Jodi Kanter
18:43 Re: [HACKERS] Our FLOAT(p) precision does not conform to spec Tom Lane
18:48 Re: disabling triggers
18:49 Re: join syntax Josh Berkus
18:50 Re: disabling triggers Josh Berkus
18:56 Re: join syntax scott.marlowe
18:58 Re: Catching DML exceptions in PL/pgSQL Radu-Adrian Popescu
19:33 Re: yet pg_toast reindex Eric Anderson Vianet SAO
20:34 Re: [ADMIN] Notification Jonathan Gardner
23:18 Re: Blobs with perl Rudi Starcevic
23:34 Re: Blobs with perl Michael A Nachbaur
23:35 Re: [ADMIN] Can the frontend get notifications from the postgres server? weigelt@metux.de
23:50 Re: yet pg_toast reindex Tom Lane

18 June 2003

11:46 Text insert max. size. Rudi Starcevic
12:41 Re: yet pg_toast reindex Eric Anderson Vianet SAO
13:21 Re: Object-Relational table design question Tm
13:25 Re: Text insert max. size. scott.marlowe
15:10 Re: Object-Relational table design question Josh Berkus
15:51 Re: Object-Relational table design question Michael A Nachbaur
16:24 comparing querys Lucas Lain
16:27 Re: comparing querys Rod Taylor
17:09 Re: [HACKERS] Our FLOAT(p) precision does not conform to spec Shridhar Daithankar
17:09 Re: Trouble porting a Oracle PL/SQL procedure to PL/pgSQL--THANKS! Tony G. Harris
17:10 Create rule/trigger Anagha Joshi
17:11 set decimal point in SQL Bu, Ning
19:02 Re: set decimal point in SQL Rodger Donaldson
19:14 Re: set decimal point in SQL Jeff Eckermann

19 June 2003

11:41 Re: [ADMIN] Latest transcation Anagha Joshi
14:07 Re: [ADMIN] Latest transcation Jonathan Gardner
15:37 Re: [GENERAL] Request for advice: Table design Guy Fraser
16:36 is this possible in plpgsql ? Marcin Winkler
18:24 Re: is this possible in plpgsql ? Richard Huxton
18:39 Re: [JDBC] maxconnection Paul Thomas

20 June 2003

05:13 Getting one row for each subquery row...? Együd Csaba
06:08 Re: Getting one row for each subquery row...? Tomasz Myrta
06:11 Re: Getting one row for each subquery row...? Tomasz Myrta
07:03 Re: Getting one row for each subquery row...? Együd Csaba
08:27 Re: [ADMIN] Latest transcation Anagha Joshi
13:43 Re: [ADMIN] Latest transcation Jonathan Gardner

21 June 2003

18:23 Re: date question javier garcia - CEBAS
18:23 plpgsql, double quoted column names containing spaces/hyphens Knut P. Lehre
22:18 Re: plpgsql, double quoted column names containing spaces/hyphens Tom Lane

22 June 2003

08:59 Delete duplicates Rudi Starcevic
10:21 Re: Delete duplicates Ian Barwick
11:03 Re: Delete duplicates Paul Thomas
11:36 Re: date question Bruno Wolff III
19:58 Informing end-user of check constraint rules
19:59 Re: Delete duplicates Germán Gutiérrez
20:35 Re: Informing end-user of check constraint rules Janning Vygen
21:17 Re: Delete duplicates Franco Bruno Borghesi
23:21 virtual table Tomasz Myrta

23 June 2003

05:16 Re: Delete duplicates Denis Arh
05:23 Re: Delete duplicates Sean Chittenden
05:23 Re: Delete duplicates Tom Lane
05:39 Re: Delete duplicates Rudi Starcevic
05:42 Urgent Help : Use of return from function/procedure. Anagha Joshi
08:10 convert_numeric_to_scalar: unsupported type 354210 AgentM
08:29 Re: virtual table Richard Huxton
08:39 Re: virtual table Tomasz Myrta
08:55 Re: virtual table Richard Huxton
09:09 Re: virtual table Tomasz Myrta
10:55 Re: Urgent Help : Use of return from function/procedure. Richard Huxton
11:02 Re: virtual table Richard Huxton
16:28 TR: Like and = Nicolas JOUANIN
16:29 Re: convert_numeric_to_scalar: unsupported type 354210 Tom Lane
16:32 Re: CREATE table1 FROM table2 L.V.Boldareva
16:45 Re: Urgent Help : Use of return from function/procedure. Chad Thompson
16:53 Re: TR: Like and = Randall Lucas
17:04 Re: CREATE table1 FROM table2 scott.marlowe
17:20 Re: convert_numeric_to_scalar: unsupported type 354210 Rod Taylor
17:21 multi-table unique index Markus Bertheau
17:33 Re: multi-table unique index Michael A Nachbaur
17:35 Re: TR: Like and = Tom Lane
18:17 Re: multi-table unique index Markus Bertheau
18:34 Re: multi-table unique index Michael A Nachbaur
19:09 Re: multi-table unique index Markus Bertheau
19:40 Re: multi-table unique index Richard Huxton
21:55 aggregate question Ryan
22:04 Re: aggregate question Tomasz Myrta

24 June 2003

05:17 Database Design Rudi Starcevic
05:19 Database design - AGAIN Rudi Starcevic
06:48 Re: TR: Like and = Nicolas JOUANIN
07:33 Re: aggregate question Hubert Lubaczewski
08:02 Re: aggregate question Tomasz Myrta
15:26 Re: Database design - AGAIN Josh Berkus
15:38 Re: Database design - AGAIN Jonathan Gardner
21:59 Re: Database design - AGAIN Rudi Starcevic
23:02 Re: Database design - AGAIN Michael A Nachbaur

25 June 2003

04:34 database & table size Anagha Joshi
05:57 Re: database & table size Stephan Szabo
06:17 Re: database & table size Frankie Lam
08:16 Re: Delete duplicates Dani Oderbolz
12:19 Re: TR: Like and = Dani Oderbolz
19:22 Re: Database design - AGAIN Josh Berkus

26 June 2003

08:03 Object based Query Requirement. Anagha Joshi
11:23 Join or Where? Együd Csaba
12:31 Change the behaviour of the SERIAL "Type" Dani Oderbolz
12:46 Re: Change the behaviour of the SERIAL "Type" Bruno Wolff III
14:00 Re: Join or Where? Richard Huxton
15:05 contrib/tsearch - chopped words? Bruce Young
16:06 Re: Change the behaviour of the SERIAL "Type" Randall Lucas
16:14 Temporary table performance? Michael A Nachbaur
17:23 Re: Temporary table performance? Rod Taylor
21:01 Rules: passing new/old to functions Gunter Diehl
21:01 Re: Informing end-user of check constraint rules
21:01 UPDATE table SET col = (SELECT ...) Vangelis-Maria Tougia
21:02 Postgres - Delphi Application murali
21:12 Re: UPDATE table SET col = (SELECT ...) Ian Barwick

27 June 2003

03:49 Re: Rules: passing new/old to functions Tom Lane
06:44 Re: TR: Like and = Nicolas JOUANIN
07:06 Re: Postgres - Delphi Application Tomasz Myrta
08:45 Re: Change the behaviour of the SERIAL "Type" Dani Oderbolz
10:30 Re: Postgres - Delphi Application Tomasz Myrta
11:13 Getting all rows even if not a member of any groups Együd Csaba
14:05 Re: Getting all rows even if not a member of any groups Bruno Wolff III
14:08 Re: Postgres - Delphi Application Együd Csaba
14:18 Re: Getting all rows even if not a member of any groups Együd Csaba
14:23 Re: Change the behaviour of the SERIAL "Type" Bruno Wolff III
14:35 Re: Change the behaviour of the SERIAL "Type" Dani Oderbolz
14:55 Re: Change the behaviour of the SERIAL "Type" Rod Taylor
15:07 Re: Getting all rows even if not a member of any groups Bruno Wolff III
15:17 Re: Change the behaviour of the SERIAL "Type" Bruno Wolff III
17:27 Re: Postgres - Delphi Application
17:27 Re: Postgres - Delphi Application
17:28 Inheritance and standards Markus Bertheau
23:09 need some help with a delete statement Matthew Hixson

28 June 2003

00:00 Re: need some help with a delete statement Bruno Wolff III
05:46 Question on OUTER JOINS. Ludwig Lim
06:03 Re: Question on OUTER JOINS. Tom Lane
06:16 Re: Question on OUTER JOINS. Ludwig Lim
11:19 Re: Question on OUTER JOINS. Bruno Wolff III
15:43 Re: Question on OUTER JOINS. Tom Lane

30 June 2003

07:47 Re: Postgres - Delphi Application Tomasz Myrta
08:29 select column from table Abdul Wahab Dahalan
10:54 Seqno. is not btree? Anagha Joshi
12:11 Bitwise operation Rudi Starcevic
12:13 Re: need some help with a delete statement scott.marlowe
12:37 Re: Bitwise operation Hubert Lubaczewski
12:39 Re: Bitwise operation Bruno Wolff III
13:08 Re: select column from table scott.marlowe
14:27 Re: Seqno. is not btree? Tom Lane
16:09 ERROR: ExecEvalExpr: unknown expression type 108 Markus Bertheau
16:41 Re: ERROR: ExecEvalExpr: unknown expression type 108 Rod Taylor
16:51 Re: ERROR: ExecEvalExpr: unknown expression type 108 Tom Lane
17:05 Re: ERROR: ExecEvalExpr: unknown expression type 108 Tom Lane
17:58 Re: need some help with a delete statement Matthew Hixson
19:07 Re: need some help with a delete statement scott.marlowe
21:13 cleaning up useless pl/pgsql functions Tomasz Myrta
21:32 Re: cleaning up useless pl/pgsql functions Tomasz Myrta
21:45 Need help creating a BEFORE DELETE trigger Michael A Nachbaur
22:03 Re: cleaning up useless pl/pgsql functions Josh Berkus
22:26 help with "delete joins" Robert Treat
22:37 Re: help with "delete joins" Stephan Szabo
22:40 Re: help with "delete joins" Robert Treat
23:41 Re: cleaning up useless pl/pgsql functions Mendola Gaetano
23:47 Re: Bitwise operation Rudi Starcevic