Home > mailing lists

Mailing lists [pgsql-sql]

1 July 1999

01:13 Re: [SQL] Beginner's headache of joins Chris Bitmead
02:28 Re: [SQL] begin/end/abort work for sequences? Bruce Momjian
02:43 Re: [SQL] String concat operator??? Bruce Momjian
13:19 Re: [SQL] begin/end/abort work for sequences? Kyle Bateman
14:31 Re: [SQL] begin/end/abort work for sequences? Bruce Momjian
15:27 Re: [SQL] begin/end/abort work for sequences? D'Arcy" "J.M." Cain
15:50 RE: [SQL] Port? Clark Joel A1C AMC CSS
15:59 DISTINCT on multiple fields Matthew Hagerty
17:18 a little conversion problem. . . JT Kirkpatrick
19:49 Re: [SQL] DISTINCT on multiple fields (fwd) Fomichev Michael
22:24 Re: [SQL] begin/end/abort work for sequences? Kyle Bateman

2 July 1999

10:29 Re: [SQL] Beginner's headache of joins webmaster
20:05 Tricky SQL (?) Peter Eisentraut

3 July 1999

02:38 Re: [SQL] Tricky SQL (?) Chris Bitmead
06:46 Index on Type Numeric Steven Pennie
07:36 Ascii null in varchars Thomas Mack
13:50 problem creating table blackgr
13:55 plpgsql function problems Thomas Mack
15:22 Re: [SQL] problem creating table Tom Lane

4 July 1999

10:07 Re: [SQL] Escaping w/i regular expressions Herouth Maoz
10:57 Re: [SQL] Tricky SQL (?) Herouth Maoz

5 July 1999

15:54 Problems with jdbc & pgsql 6.5 timbert@subnet-89.el-equip.com
22:57 Large Objects Eid, Bilal
23:18 Re: [SQL] Large Objects Chris Bitmead

6 July 1999

11:25 PB creating view : DefineQueryRewrite: rule plan string too big Olivier Ertz
13:33 How to have the types definition table ? Olivier Ertz
13:52 Re: [SQL] How to have the types definition table ? secret
17:42 Large Objects Eid, Bilal
17:49 Type Conversion: int4 -> Money secret

7 July 1999

00:08 Re: [SQL] problem creating table blackgr
01:45 Re: [SQL] How match percent sign in SELECT using LIKE? Bruce Momjian
01:45 Re: [SQL] How match percent sign in SELECT using LIKE? Bruce Momjian
07:39 Tips and tricks John Ridout
09:57 Re: [SQL] problem creating table Oliver Graf
10:57 Re: [SQL] Type Conversion: int4 -> Money Herouth Maoz
11:28 RETURN VALUES ON INTEGERS Alessandro Rossi
11:31 RETURN VALUES ON INTEGERS Alessandro Rossi
11:52 Re: [SQL] RETURN VALUES ON INTEGERS Herouth Maoz
13:37 RE: [SQL] RETURN VALUES ON INTEGERS John Ridout
13:56 Good Optimization secret
14:22 Re: [SQL] Good Optimization Roderick A. Anderson
14:43 Re: [SQL] Good Optimization Tom Lane
15:08 Re: [SQL] Good Optimization Tom Lane
15:10 Re: [SQL] Good Optimization Roderick A. Anderson
15:46 Re: [SQL] Good Optimization Bruce Momjian
16:22 Re: [SQL] Good Optimization wieck@debis.com (Jan Wieck)
17:02 Re: [SQL] Good Optimization Bruce Momjian
17:08 Index on TIMESTAMP Steven Bradley
17:11 Re: [SQL] Good Optimization Tom Lane
17:26 Re: [SQL] Oddities with NULL and GROUP BY Bruce Momjian
18:11 Re: [SQL] Good Optimization Bruce Momjian
22:49 Re: [SQL] Tips and tricks Chris Bitmead

8 July 1999

01:19 Re: [SQL] Escaping w/i regular expressions Bruce Momjian
02:05 Re: [SQL] Index on Type Numeric Bruce Momjian
07:10 Re: [SQL] Good Optimization Patrik Kudo
07:27 concatenation varchar and float Eric BASIER
08:09 Re: [SQL] Good Optimization wieck@debis.com (Jan Wieck)
08:24 Re: [SQL] Good Optimization Patrik Kudo
09:23 Re: [SQL] Good Optimization wieck@debis.com (Jan Wieck)
09:54 unsubscribe Seb
14:03 Re: [SQL] Good Optimization Tom Lane
15:02 Re: [SQL] Good Optimization Bruce Momjian
15:02 Re: [SQL] Good Optimization Bruce Momjian
15:16 RewriteDefine.c : Rule size Olivier Ertz
15:29 Re: [SQL] RewriteDefine.c : Rule size wieck@debis.com (Jan Wieck)
17:05 uncorrelated subqueries Bruce Lowery
18:31 Re: [SQL] uncorrelated subqueries Tom Lane
19:19 Referential Integrity Gilson Costa
19:34 offtopic: odbc C frontend for linux? Engard Ferenc
19:36 Re: [SQL] Referential Integrity Steven Bradley
20:44 Re: [SQL] offtopic: odbc C frontend for linux? Stephen Boyle
20:51 Re: [SQL] offtopic: odbc C frontend for linux? wieck@debis.com (Jan Wieck)

9 July 1999

01:52 subscribe Soon-Suk Kim
02:03 subscribe Soon-Suk Kim
02:34 Undeliverable Message
03:25 Re: [SQL] RewriteDefine.c : Rule size Jim Rowan
05:43 Anna Langer
08:26 Bad date representation Roland_DUBOULOZ
09:02 RE: [SQL] Good Optimization Ansley, Michael
09:18 Good Optimization Ansley, Michael
09:57 RE: [SQL] Good Optimization John Ridout
13:26 Re: [SQL] RewriteDefine.c : Rule size Tom Lane
15:56 Re: [SQL] Good Optimization Bruce Momjian
16:00 Re: [SQL] RewriteDefine.c : Rule size Bruce Momjian
16:09 Re: [SQL] RewriteDefine.c : Rule size Bruce Momjian
16:11 Re: Good Optimization Bruce Momjian
16:27 RE: [SQL] offtopic: odbc C frontend for linux? Eid, Bilal
18:31 class as a table column? George Young
19:37 class as a table column? George Young
19:48 RE: [SQL] Re: Good Optimization Jackson, DeJuan
19:56 class as a table column George Young

10 July 1999

03:59 a problem of the postgresql .. welssen crow
19:03 Re: [SQL] Oddities with NULL and GROUP BY Tom Lane
19:17 SELECT DISTINCT question Oleg Bartunov
20:19 Re: [HACKERS] SELECT DISTINCT question Tom Lane

11 July 1999

14:33 Re: [SQL] Bad date representation Herouth Maoz
14:33 Re: [SQL] uncorrelated subqueries Herouth Maoz
14:40 Re: [SQL] Re: [HACKERS] SELECT DISTINCT question Tom Lane
14:41 Re: [SQL] Re: [HACKERS] SELECT DISTINCT question Oleg Bartunov
16:36 Aggregates qd@sea.com.ua
16:46 accumulated statistics Oleg Bartunov

12 July 1999

01:36 Re: [HACKERS] accumulated statistics Philip Warner
07:28 Stupid question about default time value Nikolay Mijaylov
12:38 SQL: Getting table structure John Bowden
12:48 calculating percentages Thomas Good
13:55 Re: [SQL] calculating percentages Tiberiu Craciun
14:07 Re: [SQL] Stupid question about default time value Tom Lane
14:08 Re: [SQL] calculating percentages Tom Lane
14:52 Re: [SQL] calculating percentages Thomas Good
15:58 Re: [SQL] calculating percentages Thomas Good
15:58 Re: [SQL] calculating percentages Tom Lane
17:25 Left joins Peter Eisentraut

13 July 1999

01:18 variables in pgSQL? Heinz Hemken
01:42 variables in pgSQL? Heinz Hemken
02:13 Re: [SQL] variables in pgSQL? Chris Bitmead
03:34 create temp table Steven Bradley
04:15 Using Indexes Mr. Poet
04:32 Re: [SQL] create temp table Bruce Momjian
04:54 Re: [SQL] Using Indexes Chris Bitmead
06:15 Problem with timestamp and primary key. Esteban Chiner Sanz
10:31 Postgres ERROR Esteban Chiner Sanz
11:15 "quoting" column names Patrik Kudo
11:39 JT Kirkpatrick
11:54 Re: [SQL] calculating percentages D'Arcy" "J.M." Cain
13:02 Re: [SQL] Postgres ERROR Tom Lane
13:09 Re: [SQL] "quoting" column names Tom Lane
13:10 Re: [SQL] calculating percentages Thomas Good
13:20 Re: [SQL] "quoting" column names Patrik Kudo
13:30 Re: [SQL] "quoting" column names Herouth Maoz
14:22 Re: [SQL] Problem with timestamp and primary key. Steven Bradley
14:45 ... Hub.Org News Admin
15:06 Re: [SQL] Problem with timestamp and primary key. Herouth Maoz
16:02 Re: [SQL] Postgres ERROR Bruce Momjian
16:02 Re: [SQL] Problem with timestamp and primary key. Bruce Momjian
17:56 ... Hub.Org News Admin
19:41 Re: [HACKERS] SELECT DISTINCT question Hannu Krosing
20:33 Re: [HACKERS] SELECT DISTINCT question Tom Lane
22:31 counting bools in a complex query Michael Richards

14 July 1999

04:17 WHERE clause? Jim Rowan
06:14 OFF-TOPIC: Postgresql for NT? Johann Spies
07:58 Few questions about my slow query webmaster
08:23 Re: Few questions about my slow query webmaster
08:43 Re: [SQL] counting bools in a complex query Herouth Maoz
12:08 SQL query to check size of database webmaster
12:36 Re: [SQL] SQL query to check size of database Tom Lane
13:01 Re: [SQL] WHERE clause? Tom Lane
13:32 Prolem wiht long query? Jérome Knöbl
13:43 Re: [SQL] Few questions about my slow query Tom Lane
14:21 Re: [SQL] Prolem wiht long query? Tom Lane
14:48 Re: [SQL] WHERE clause? Steven Bradley
20:11 SELECT using arrays Evan Klinger
21:57 How big can a transaction query be? Kyle Bateman
23:28 Re: [SQL] How big can a transaction query be? Tom Lane

15 July 1999

16:15 Foreign keys Esteban Chiner Sanz
16:58 RE: [SQL] Foreign keys Jackson, DeJuan
18:13 query length limits tjk@tksoft.com

16 July 1999

00:17 query length limits tjk@tksoft.com
06:09 RE: query length limits Ansley, Michael
07:38 Re: [HACKERS] Counting bool flags in a complex query Michael Richards
08:23 RE: [HACKERS] Counting bool flags in a complex query Ansley, Michael
09:04 RE: [HACKERS] Counting bool flags in a complex query Ansley, Michael
12:14 Stored Procedures and other stuffs Ademir Mazer Jr
13:40 Re: [HACKERS] Counting bool flags in a complex query Tom Lane
20:21 Re: [HACKERS] Counting bool flags in a complex query Michael Richards
21:00 Re: [SQL] Re: [HACKERS] Counting bool flags in a complex query Tom Lane
21:24 user defined function speeds tjk@tksoft.com

17 July 1999

02:41 Fix up for BTP_CHAIN problems Wayne Piekarski
22:30 Re: [SQL] Stored Procedures and other stuffs Stephen Boyle

19 July 1999

00:57 Re: [HACKERS] Fix up for BTP_CHAIN problems Vadim Mikheev
10:48 Re: [SQL] SELECT using arrays Herouth Maoz
11:11 Re: [SQL] Re: [HACKERS] Counting bool flags in a complex query Herouth Maoz
13:04 Re: [SQL] Good Optimization secret
13:20 Re: [SQL] Good Optimization secret
13:46 Large text Àíäðåé Íîâèêîâ
13:54 Re: [SQL] Re: [HACKERS] Counting bool flags in a complex query Tom Lane
14:04 Re: [SQL] Good Optimization Bruce Momjian
14:16 Re: [SQL] Good Optimization Tom Lane
16:16 RE: pgsql-sql-digest V1 #281 Dionisio Barrantes

20 July 1999

03:36 ... Vikrant Rathore
13:03 bad select performance for where (x=1 or x=3) George Young
13:54 Re: [SQL] bad select performance for where (x=1 or x=3) Tom Lane
16:15 Can I prevent my sequence to increment if an insert is rejected? Frederic De Leersnijder
18:01 Re: [SQL] Can I prevent my sequence to increment if an insert is rejected? tjk@tksoft.com
23:04 Bad update performance? Gunnar Ingvi Thorisson

21 July 1999

00:35 Tool for generating entity relation diagrams. GrooveRipper
01:29 Re: [SQL] Bad update performance? tjk@tksoft.com
06:49 RE: Tool for generating entity relation diagrams. Ansley, Michael
07:58 how to add users in group Jonathan davis
08:16 Re: [SQL] Can I prevent my sequence to increment if an insert is rejected? Herouth Maoz
08:38 Re: [SQL] Can I prevent my sequence to increment if an insert isrejected? Chris Bitmead
08:45 Re: [SQL] Can I prevent my sequence to increment if an insert isrejected? Herouth Maoz
08:46 pb with pg_group Jonathan davis
08:52 Re: [SQL] Bad update performance? Herouth Maoz
12:22 inheritance Chris Bitmead
12:29 I dont't receive any messages Karin Probost
12:40 Re: [SQL] Bad update performance? Tom Lane
14:01 Re: [HACKERS] inheritance Tom Lane
14:11 Re: [SQL] bad select performance fixed by forbidding hash joins George Young
15:17 Re: [HACKERS] inheritance Hannu Krosing
16:21 Re: [SQL] bad select performance fixed by forbidding hash joins Tom Lane
16:59 Re: [GENERAL] Re: [SQL] bad select performance fixed by forbidding hash joins Bruce Momjian

22 July 1999

03:22 how to determine table? Don Yury
03:43 Re: [SQL] how to determine table? Chris Bitmead
07:18 Buffer Size Michael Yeung
08:29 [SQL] "quoting" column names Patrik Kudo
09:17 Problem with large objects root
10:48 (no subject) root
11:48 database design SQL prob. Frederic.De.Leersnijder@pandora.be
11:58 Re: [SQL] calculating percentages D'Arcy" "J.M." Cain
13:24 Problem with large binary objects and Delphi Ramón Yago
13:36 Problem with Rules Peter Eisentraut
15:56 Re: [SQL] Problem with Rules wieck@debis.com (Jan Wieck)
20:19 ... Hub.Org News Admin

23 July 1999

05:58 copy text file into a table World Data Service
06:07 Delphi, Postgres and Large binary objects Hijos de Ramón Puche S.L.
06:20 about stuck spinlock of postgresq-l6.4.2 Yann-Ju Chu
08:16 Re: [SQL] database design SQL prob. Stuart Rison
12:11 Re: [SQL] offtopic: odbc C frontend for linux? wieck@debis.com (Jan Wieck)
18:57 Select/Insert operations with arrays Ravi Mukkamala
19:15 Select/insert with C-type arrays Ravi Mukkamala
19:43 lo_read and lo_write Ravi Mukkamala
19:45 ERROR: DefineQueryRewrite: rule plan string too big. John M. Flinchbaugh
21:54 ... Hub.Org News Admin

24 July 1999

02:34 Wayne Piekarski
02:52 Postgres 6.5 Is Fantastic! Wayne Piekarski
08:49 inserts/updates problem under stressing ! Oleg Bartunov
10:50 Re: [SQL] database design SQL prob. D'Arcy" "J.M." Cain
14:13 Expr Abbreviations/Functions? Kenneth Jacker
15:31 Re: [SQL] inserts/updates problem under stressing ! Tom Lane
16:05 Re: [SQL] inserts/updates problem under stressing ! Oleg Bartunov
16:29 Re: [HACKERS] Re: [SQL] inserts/updates problem under stressing ! Oleg Bartunov
17:28 Views Readonly Still? Zot O'Connor
17:36 Coverting mysql keys Zot O'Connor
17:39 Goos SQL refernce Zot O'Connor
22:13 Re: [SQL] Expr Abbreviations/Functions? tjk@tksoft.com
22:36 Questions about Postgresql and other databases Hector M Banda
22:39 Re: [SQL] Views Readonly Still? Tom Lane
23:18 Re: [HACKERS] Re: [SQL] inserts/updates problem under stressing ! Philip Warner

25 July 1999

11:40 Re: [SQL] database design SQL prob. Herouth Maoz
11:48 Re: [SQL] Expr Abbreviations/Functions? Herouth Maoz
11:54 Re: [SQL] ERROR: DefineQueryRewrite: rule plan string too big. Herouth Maoz
15:04 Re: [SQL] ERROR: DefineQueryRewrite: rule plan string too big. Tom Lane

26 July 1999

01:40 Re: [SQL] inserts/updates problem under stressing ! Vadim Mikheev
01:43 Re: [SQL] inserts/updates problem under stressing ! Vadim Mikheev
01:51 Re: [HACKERS] Re: [SQL] inserts/updates problem understressing ! Vadim Mikheev
03:09 (no subject) Martin Jackson
03:17 Re: [SQL] database design SQL prob. Don Yury
03:53 Re: [SQL] Expr Abbreviations/Functions? tjk@tksoft.com
05:20 Re: [SQL] inserts/updates problem under stressing ! Oleg Bartunov
05:27 Re: [SQL] inserts/updates problem under stressing ! Vadim Mikheev
05:29 LEFT JOIN and ODBC Molnar Laszlo
05:51 Re: [SQL] inserts/updates problem under stressing ! Oleg Bartunov
08:09 NOT IN clause performing badly Christian Rudow
08:26 Re: [SQL] ERROR: DefineQueryRewrite: rule plan string too big. wieck@debis.com (Jan Wieck)
09:27 Re: [SQL] Expr Abbreviations/Functions? Herouth Maoz
09:31 Re: [SQL] database design SQL prob. D'Arcy" "J.M." Cain
10:12 Re: [SQL] NOT IN clause performing badly Herouth Maoz
10:34 Re: [SQL] RE: Tool for generating entity relation diagrams. John Reynolds
11:39 Re: [GENERAL] escaping wildcard chars Herouth Maoz
12:38 Re: [SQL] database design SQL prob. Bruce Momjian
13:19 Re: [SQL] RewriteDefine.c : Rule size Jim Rowan
22:01 timespan arithmetic David Rose
22:16 RE: [SQL] timespan arithmetic Jackson, DeJuan

27 July 1999

03:23 Re: [GENERAL] escaping wildcard chars Dan Wilson
03:23 Re: [GENERAL] escaping wildcard chars Dan Wilson
04:52 RE: [SQL] timespan arithmetic David Rose
12:26 Re: [SQL] Good Optimization wieck@debis.com (Jan Wieck)
12:30 Re: [SQL] Good Optimization Patrik Kudo
12:38 outer joins Don Yury
12:39 SELECT .. WHERE field IN (SELECT .. ) Predrag Lesic
13:36 Re: [INTERFACES] How can I work thru this key problem? Herouth Maoz
22:15 Outer Joins, Foreign keys, subselects Jens Glaser
23:00 WHERE parent IN (0,-1) Drew Whittle
23:10 Re: [SQL] WHERE parent IN (0,-1) Bruce Momjian
23:13 Re: [SQL] Outer Joins, Foreign keys, subselects Bruce Momjian

28 July 1999

08:30 Re: [SQL] ERROR: DefineQueryRewrite: rule plan string too big. John M. Flinchbaugh
08:48 How to limit number of processes Remigiusz Sokolowski
12:50 Re: [SQL] WHERE parent IN (0,-1) Tom Lane
13:49 Re: [SQL] WHERE parent IN (0,-1) Thomas Lockhart
16:49 Re: [SQL] WHERE parent IN (0,-1) Tom Lane
17:06 Join with blank records. Matthew Hagerty
19:15 Re: [SQL] Join with blank records. Peter Eisentraut
20:47 Re: [SQL] Join with blank records. Matthew Hagerty
22:17 COALESCE() bug? Jens Glaser
23:16 Re: [SQL] COALESCE() bug? Tom Lane
23:30 Re: [SQL] COALESCE() bug? Bruce Momjian

29 July 1999

01:27 Form making with psql and php.cgi Inform(ñËÕÔÓËÜÎÅÒÇÏ)
02:28 Re: [SQL] WHERE parent IN (0,-1) Thomas Lockhart
02:51 Re: [SQL] COALESCE() bug? Tom Lane
03:05 Re: Subject: Form making with psql and php.cgi Zot O'Connor
05:50 test, please ignore Remigiusz Sokolowski
15:58 Formatting the output G. Anthony Reina
16:34 Re: [SQL] Formatting the output Bill Brandt
16:58 Re: [SQL] Formatting the output Bruce Momjian
16:58 Re: [SQL] Formatting the output Bruce Momjian
17:33 Re: [SQL] Formatting the output G. Anthony Reina
23:31 Re: [SQL] Formatting the output Thomas Lockhart
23:44 Re: [SQL] Formatting the output Bruce Momjian

30 July 1999

01:19 stuck spinlock in postgresql-6.5.1 Yann-Ju Chu
09:07 Related tables Franco Cazzaro
10:38 Error when inserting Esteban Chiner Sanz
12:33 Re: [SQL] Error when inserting Darrin Crook
14:19 unsuscribe Carlos
14:56 date_arithmetic revisited Thomas Good
19:11 MVCC and concurrent clients Tom Lane

31 July 1999

10:31 Re: [SQL] Outer Joins, Foreign keys, subselects Jens Glaser
15:02 Re: [SQL] Outer Joins, Foreign keys, subselects Tom Lane
21:14 Tr: UNIQUE Stéphane FILLON
21:15 Tr: DUMP database for sample Stéphane FILLON
22:06 Re: [SQL] MVCC and concurrent clients Ross J. Reedstrom