Home > mailing lists

Mailing lists [pgsql-sql]

1 February 2000

00:13 Re: [SQL] now() returning int4 Tom Lane
01:15 Re: [SQL] GROUP BY: v6.1 vs. v6.5.2 Tom Lane
15:08 Re: [SQL] GROUP BY: v6.1 vs. v6.5.2 Ray Plante

2 February 2000

12:10 Hello sir. a kj
12:22 A question Julie
23:34 Proposed Changes to PostgreSQL Chris Bitmead

3 February 2000

00:31 Re: [GENERAL] Proposed Changes to PostgreSQL Bruce Momjian
00:49 Re: [GENERAL] Proposed Changes to PostgreSQL Chris Bitmead
00:56 Re: [SQL] Proposed Changes to PostgreSQL Tom Lane
00:58 Re: [GENERAL] Proposed Changes to PostgreSQL Bruce Momjian
01:42 Re: [HACKERS] Re: [SQL] Proposed Changes to PostgreSQL The Hermit Hacker
01:45 Re: [SQL] Proposed Changes to PostgreSQL Chris Bitmead
01:52 Re: [GENERAL] Proposed Changes to PostgreSQL Chris Bitmead
02:04 Re: [HACKERS] Re: [SQL] Proposed Changes to PostgreSQL Chris Bitmead
02:04 Re: [GENERAL] Proposed Changes to PostgreSQL Bruce Momjian
02:06 Re: [SQL] Proposed Changes to PostgreSQL Bruce Momjian
02:14 Re: [SQL] Proposed Changes to PostgreSQL Chris Bitmead
02:23 SQL Query help needed Scott Chapman
02:23 Re: [HACKERS] Re: [SQL] Proposed Changes to PostgreSQL Bruce Momjian
02:32 SQL Query help needed - newbie question Scott Chapman
02:50 Re: [SQL] SQL Query help needed - newbie question Chris Bitmead
03:14 Re: [HACKERS] Re: [SQL] Proposed Changes to PostgreSQL Don Baccus
03:40 Re: [HACKERS] Re: [SQL] Proposed Changes to PostgreSQL Chris Bitmead
04:11 Re: [HACKERS] Re: [SQL] Proposed Changes to PostgreSQL Chris Bitmead
04:27 Re: [SQL] Re: [GENERAL] Proposed Changes to PostgreSQL Mathijs Brands
04:35 Re: [SQL] Re: [GENERAL] Proposed Changes to PostgreSQL Chris Bitmead
05:00 Re: [HACKERS] Re: [SQL] Proposed Changes to PostgreSQL Tom Lane
07:18 Re: [HACKERS] Re: [SQL] Proposed Changes to PostgreSQL Chris
07:53 Re: [HACKERS] Re: [SQL] Proposed Changes to PostgreSQL Hannu Krosing
07:59 Re: [HACKERS] Re: [GENERAL] Proposed Changes to PostgreSQL Hannu Krosing
08:04 Re: [HACKERS] Re: [GENERAL] Proposed Changes to PostgreSQL Hannu Krosing
08:24 Re: [HACKERS] Re: [SQL] Proposed Changes to PostgreSQL Hannu Krosing
08:49 Re: [HACKERS] Re: [SQL] Proposed Changes to PostgreSQL Chris
10:21 Re: [HACKERS] Re: [SQL] Proposed Changes to PostgreSQL Bruce Momjian
10:22 Re: [HACKERS] Re: [SQL] Proposed Changes to PostgreSQL Bruce Momjian
10:31 Re: [HACKERS] Re: [SQL] Proposed Changes to PostgreSQL Chris
11:03 Re: [HACKERS] Re: [SQL] Proposed Changes to PostgreSQL Bruce Momjian
11:08 Re: [HACKERS] Re: [SQL] Proposed Changes to PostgreSQL Chris
11:32 Re: [HACKERS] Re: [SQL] Proposed Changes to PostgreSQL Bruce Momjian
11:39 Re: [HACKERS] Re: [SQL] Proposed Changes to PostgreSQL Mark Hollomon
12:35 Question about SELECT and ORDER BY Vladimir Terziev
13:23 Re: [SQL] Question about SELECT and ORDER BY Mark Volpe
13:25 AW: [HACKERS] Re: [SQL] Proposed Changes to PostgreSQL Zeugswetter Andreas SB
13:52 Re: [HACKERS] Re: [SQL] Proposed Changes to PostgreSQL Don Baccus
13:52 Re: [HACKERS] Re: [SQL] Proposed Changes to PostgreSQL Don Baccus
14:21 INSTALL doc correction ... Frank Bax
14:27 Re: [HACKERS] Re: [SQL] Proposed Changes to PostgreSQL Tom Lane
14:27 Re: [HACKERS] Proposed Changes to PostgreSQL Peter Eisentraut
14:44 Re: [SQL] INSTALL doc correction ... Peter Eisentraut
14:52 Re: [HACKERS] Re: [SQL] Proposed Changes to PostgreSQL Taral
14:53 RE: [HACKERS] Re: [SQL] Proposed Changes to PostgreSQL Peter Mount
14:55 Re: [HACKERS] Re: [SQL] Proposed Changes to PostgreSQL Tom Lane
15:35 Re: [HACKERS] Re: [SQL] Proposed Changes to PostgreSQL Tom Lane
15:45 sql statements David Warren
15:48 Re: [SQL] Question about SELECT and ORDER BY Tom Lane
16:04 Re: [SQL] sql statements Tom Lane
16:39 Install: Undefined symbol `_TAS' Frank Bax
20:31 Re: [HACKERS] Re: [SQL] Proposed Changes to PostgreSQL Hannu Krosing
20:46 Re: [HACKERS] Re: [SQL] Proposed Changes to PostgreSQL Chris Bitmead
20:52 Re: [HACKERS] Re: [SQL] Proposed Changes to PostgreSQL Hannu Krosing
20:57 Re: [HACKERS] Re: [SQL] Proposed Changes to PostgreSQL Chris Bitmead
21:07 Re: [HACKERS] Proposed Changes to PostgreSQL Chris Bitmead
21:31 Re: [HACKERS] Re: [SQL] Proposed Changes to PostgreSQL Chris Bitmead
21:59 Re: [HACKERS] Re: [SQL] Proposed Changes to PostgreSQL Chris Bitmead
22:12 relhasindex(was RE: [HACKERS] Proposed Changes to PostgreSQL) Hiroshi Inoue
22:29 Re: [HACKERS] Re: [SQL] Proposed Changes to PostgreSQL Ross J. Reedstrom

4 February 2000

01:07 Re: [HACKERS] Re: [SQL] Proposed Changes to PostgreSQL Marten Feldtmann
01:45 Re: [HACKERS] Re: [SQL] Proposed Changes to PostgreSQL Chris Bitmead
04:48 Re: [SQL] Install: Undefined symbol `_TAS' Tom Lane
09:33 Concurrency problem Taral
10:21 Re: [SQL] Concurrency problem wieck@debis.com (Jan Wieck)
10:53 Re: [SQL] Concurrency problem Gerhard Dieringer
11:40 expensive query Postgres SQL
11:52 Re: [SQL] Install: Undefined symbol `_TAS' Vince Gonzalez
11:55 Re: [SQL] Concurrency problem wieck@debis.com (Jan Wieck)
13:07 Re: [SQL] Install: Undefined symbol `_TAS' Tom Lane
13:13 ... avcbase
13:44 Re: [SQL] expensive query Tom Lane
14:33 Re: [HACKERS] Re: [SQL] Proposed Changes to PostgreSQL Don Baccus
16:24 Re: [SQL] Re: [HACKERS] Proposed Changes to PostgreSQL Marten Feldtmann
17:32 Re: [SQL] Concurrency problem Taral
17:55 Re: [SQL] Concurrency problem wieck@debis.com (Jan Wieck)
20:30 Re: [HACKERS] Re: [SQL] Proposed Changes to PostgreSQL Hannu Krosing
23:44 Re: [HACKERS] Re: [SQL] Proposed Changes to PostgreSQL Chris
23:52 Re: [SQL] Re: [HACKERS] Proposed Changes to PostgreSQL Chris

5 February 2000

00:07 Re: [HACKERS] Re: [SQL] Proposed Changes to PostgreSQL Don Baccus
09:54 Re: [SQL] Re: [HACKERS] Proposed Changes to PostgreSQL Hannu Krosing
10:13 Re: [SQL] Re: [HACKERS] Proposed Changes to PostgreSQL Hannu Krosing

7 February 2000

03:23 Re: [SQL] Re: [HACKERS] Proposed Changes to PostgreSQL
22:55 SubSelect as a column Lars

8 February 2000

01:03 Re: [SQL] Re: [HACKERS] Proposed Changes to PostgreSQL Marten Feldtmann
01:34 Re: [SQL] SubSelect as a column Tom Lane
06:43 Re: [SQL] SubSelect as a column Patrick JACQUOT
09:33 Efficiency Radhesh Mohandas
11:47 Problem with PL/pgSQL Vladimir Terziev
12:10 Re: [SQL] Problem with PL/pgSQL Vince Gonzalez
12:48 Re: [SQL] Problem with PL/pgSQL Vladimir Terziev
13:59 Re: [SQL] Problem with PL/pgSQL Tom Lane
14:15 Re: [SQL] Problem with PL/pgSQL wieck@debis.com (Jan Wieck)
17:08 Re: [SQL] SubSelect as a column Lars
23:00 POR FIN DINERO REAL SIN TRAMPAS Javi Piñol

9 February 2000

07:08 Re: Bug#57466: select ... except fails when there are nulls in second clause Oliver Elphick
13:46 Problem with the connection using.odbc.ini Bjorn Segers (dig)
13:49 Re: [SQL] Re: Bug#57466: select ... except fails when there are nulls in second clause Tom Lane

10 February 2000

16:00 How to quietly increment a SEQUENCE? Martin Kresse
16:29 Re: [SQL] How to quietly increment a SEQUENCE? Bruce Momjian

11 February 2000

20:01 Techniques for quickly finding words in a phrase... Saltsgaver, Scott
21:10 Re: [SQL] Techniques for quickly finding words in a phrase... Tom Lane
23:52 Type casting bool as int4? phil@Stimpy.netroedge.com

12 February 2000

00:15 subscribe phil@Stimpy.netroedge.com
02:28 Type casting bool? phil@Stimpy.netroedge.com
06:39 Re: [SQL] Techniques for quickly finding words in a phrase... om
21:59 text -> char Peter Stamfest
22:36 Re: [SQL] Type casting bool? tjk@tksoft.com

13 February 2000

04:37 Re: [SQL] Type casting bool? Tom Lane
04:53 text -> char Peter Stamfest
19:47 subscribe pgsql-sql-digest Donald Bauer

14 February 2000

14:07 ... A LITTLE IDEA TO OPTIMIZE SELECT STATEMENT Nicola Cisternino
16:14 bug in translate(text,from,to) ? Wim Kerkhoff
16:37 "Permission denied" on public view Martin Kresse
17:00 Re: [SQL] "Permission denied" on public view wieck@debis.com (Jan Wieck)
18:13 check_foreign_key with OIDs Mark Volpe
19:22 pg_group system table Gordon Clarke
22:34 is there a mysql to postgresql sql converter? Clay

15 February 2000

10:18 Re: [SQL] is there a mysql to postgresql sql converter? Peter Eisentraut
13:03 Re: [SQL] "Permission denied" on public view Martin Kresse
15:06 Techniques for quickly finding words in a phrase... Carl Flansbaum

16 February 2000

07:35 How to set up a simple relational database James Macken
08:05 Re: [SQL] How to set up a simple relational database Chris
08:34 Re: [SQL] How to set up a simple relational database Moray McConnachie
09:05 Auto increment field when updating? Robin Keech
10:55 Re: pgsql-sql-digest V1 #499 sszabo@bigpanda.com
11:09 Re: [SQL] How to set up a simple relational database Kovacs Zoltan Sandor
12:07 Re: BSC Vladimir Terziev
12:41 Re: [SQL] Auto increment field when updating? Tom Lane
14:04 Re: [SQL] Re: BSC Kovacs Zoltan Sandor
14:17 Re: [SQL] Re: BSC Peter Eisentraut
14:36 Postgres backend crash on alpha Mark Volpe
14:59 Re: [SQL] Postgres backend crash on alpha Bruce Momjian
16:19 Re: [SQL] Postgres backend crash on alpha Mark Volpe
20:14 Multiple rule actions Mark Volpe
20:33 Re: [SQL] Multiple rule actions Mark Volpe

17 February 2000

06:18 Re: [SQL] Re: BSC omid omoomi
07:53 Question about PL/pgSQL Vladimir Terziev
10:28 Re: [SQL] Question about PL/pgSQL Kovacs Zoltan Sandor

18 February 2000

11:34 Kindly stop sending please !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!1 Mohit Marwaha
15:53 Select & Tables X Select & Views Rodrigo Rezende
16:27 Re: [SQL] Select & Tables X Select & Views Ross J. Reedstrom

19 February 2000

05:31 Mohit Marwaha
05:36 Mohit Marwaha
08:33 Re: [SQL] Auto increment field when updating? Peter Vazsonyi
09:22 ...LIMIT CLAUSE Nicola Cisternino
15:16 Ray Messier
15:21 date formation problems Ray Messier
17:54 Outer Joins Charles Mott
18:15 Re: [SQL] Outer Joins Jens Glaser

20 February 2000

00:30 Re: [SQL] Auto increment field when updating? Gordon Clarke
12:22 Re: [SQL] Auto increment field when updating? Peter Eisentraut
17:55 pltcl and LDAP Joe Conway
20:34 group by date_part M.Mazurek@poznan.multinet.pl
22:40 it wont let me delete jdb371
23:06 Re: [SQL] group by date_part Tom Lane
23:08 Re: [SQL] group by date_part M.Mazurek@poznan.multinet.pl

21 February 2000

10:04 Re: [SQL] Select & Tables X Select & Views Rodrigo Rezende
12:33 rule plan string too big Rodrigo Rezende
20:28 Re: [SQL] Select & Tables X Select & Views Tom Lane
21:57 Re: [SQL] rule plan string too big Peter Eisentraut

22 February 2000

08:11 Procedure and Trigger managment. Perfomance Alexey V. Meledin
18:06 HOWTO create BLOB fields? Thomas Frei
18:44 select returning mysterious null rows webmaster@duluoz.net
19:51 pg_group system table Gordon Clarke
23:19 Re: [SQL] pg_group system table Peter Eisentraut

23 February 2000

04:33 SQL Script Question Carolyn Wong
08:10 RE: [SQL] SQL Script Question Andrzej Mazurkiewicz
10:39 Re: [SQL] SQL Script Question Kovacs Zoltan Sandor
11:33 problem with grant/revoke Jerome ALET
12:22 capturing microseconds & computing difference between two dates Robin Keech
12:36 Justin Long
15:13 Re: [SQL] capturing microseconds & computing difference between two dates Tom Lane

24 February 2000

06:06 create a database Rolf Staege
06:35 database rights? Engard Ferenc
09:07 PostgreSQL and PHP James Macken
09:30 Re: [SQL] PostgreSQL and PHP Stefano Brozzi
09:56 Re: [SQL] PostgreSQL and PHP Giampiero Raschetti
14:22 Re: [SQL] database rights? Peter Eisentraut
15:07 cache lookup failed Graham Vickrage
19:40 date_part, too many results? M.Mazurek@poznan.multinet.pl
20:15 Re: [SQL] cache lookup failed Tom Lane
20:30 how to create index on timestamp field in pre v7 database Alex Howansky
21:59 Re: [SQL] how to create index on timestamp field in pre v7 database Tom Lane
22:47 Re: [SQL] date_part, too many results? Tom Lane

25 February 2000

01:07 New Optimizer Behaviour In 7.0b1 Mark Kirkwood
02:49 Re: [INTERFACES] arrays of varchar and " Tom Lane
03:08 DELIVERY FAILURE: User laszlo_acs (laszlo_acs@cms.state.il.us) not listed in public Name & Address Book Postmaster@state.il.us
09:17 Re: [SQL] how to create index on timestamp field in pre v7 database Moray McConnachie
11:52 Problem - Postgres Running continously Nedu
12:00 INSERT w/o variable names for a SERIAL type? Emils Klotins
13:15 Re: [SQL] INSERT w/o variable names for a SERIAL type? Alessio Bragadini
13:56 Finding missing records... Matthew Hagerty
14:24 Re: [SQL] Finding missing records... wieck@debis.com (Jan Wieck)
14:30 Re: [SQL] how to create index on timestamp field in pre v7 database Tom Lane
14:39 Re: [SQL] Finding missing records... Sevo Stille
14:57 Re: [SQL] how to create index on timestamp field in pre v7 database Bruce Momjian

26 February 2000

02:03 Next Employee ID Herbert Rabago Ambos
05:00 New Optimizer Behaviour In 7.0b1 Mark Kirkwood
05:47 SQL query problem Vikrant Rathore
06:05 Re: [SQL] New Optimizer Behaviour In 7.0b1 Tom Lane
18:29 Re: [SQL] New Optimizer Behaviour In 7.0b1 Mark Kirkwood
19:27 Re: [SQL] text -> char Tom Lane
21:15 Re: [SQL] New Optimizer Behaviour In 7.0b1 Tom Lane

27 February 2000

00:30 Nested BEGIN...COMMIT transactions mpg4@duluoz.net
05:40 Default sequence values Seth Banks
05:48 Re: [SQL] Default sequence values Tom Lane
13:16 Re: [SQL] INSERT w/o variable names for a SERIAL type? Peter Eisentraut
16:29 Re: [SQL] INSERT w/o variable names for a SERIAL type? Tom Lane
16:59 Re: [SQL] INSERT w/o variable names for a SERIAL type? Bruce Momjian
17:07 Re: [SQL] INSERT w/o variable names for a SERIAL type? Bruce Momjian
17:44 Re: [SQL] INSERT w/o variable names for a SERIAL type? Ross J. Reedstrom
20:44 Rule (which multiple actions) problem with history table..... maillist@remo.demon.co.uk
21:43 Re: [SQL] Rule (which multiple actions) problem with history table..... Tom Lane
21:53 Re: [SQL] Nested BEGIN...COMMIT transactions Peter Eisentraut
21:58 Re: [SQL] INSERT w/o variable names for a SERIAL type? Peter Eisentraut
22:00 Re: [SQL] New Optimizer Behaviour In 7.0b1 Mark Kirkwood
22:31 Re: [SQL] INSERT w/o variable names for a SERIAL type? Bruce Momjian
22:36 [SQL] 7.0beta1? Christopher Sawtell

28 February 2000

00:20 Re: [SQL] 7.0beta1? Bruce Momjian
01:29 Problems with create table continued... Seth Banks
01:49 SQL query problem Vikrant Rathore
02:29 Re: [SQL] Problems with create table continued... Tom Lane
02:36 Re: [SQL] Problems with create table continued... Ross J. Reedstrom
03:40 SQL query problem Vikrant Rathore
04:24 prob with aggregate and group by - returns multiples George Dau
05:38 Re: [SQL] SQL query problem Tom Lane
05:50 Re: [SQL] prob with aggregate and group by - returns multiples Tom Lane
14:58 importing data from a text file Abdul Karim
18:23 Re: [SQL] INSERT w/o variable names for a SERIAL type? Peter Eisentraut
19:59 RE: [SQL] prob with aggregate and group by - returns multiples George Dau
20:54 Re: [SQL] prob with aggregate and group by - returns multiples Tom Lane
21:17 Re: [SQL] prob with aggregate and group by - returns multiples Peter Eisentraut

29 February 2000

03:38 Re: [HACKERS] Re: [SQL] prob with aggregate and group by - returns multiples Thomas Lockhart
03:45 Re: [HACKERS] Re: [SQL] prob with aggregate and group by - returns multiples Tom Lane
04:00 Re: [HACKERS] Re: [SQL] prob with aggregate and group by - returns multiplesh Bruce Momjian
04:41 Re: [HACKERS] Re: [SQL] prob with aggregate and group by - returns multiplesh Thomas Lockhart
08:55 Re: [HACKERS] Re: [SQL] prob with aggregate and group by - returns multiples Peter Eisentraut
10:00 RE: [SQL] prob with aggregate and group by - returns multiples Peter Eisentraut
11:28 DATE formatting problem again Forgacs Tamas
12:31 Re: [HACKERS] Re: [SQL] prob with aggregate and group by - returnsmultiples Thomas Lockhart
13:02 Re: [HACKERS] Re: [SQL] prob with aggregate and group by - returns multiplesh Don Baccus
13:57 Re: [HACKERS] Re: [SQL] prob with aggregate and group by - returns multiplesh Tom Lane
14:11 Re: [HACKERS] Re: [SQL] prob with aggregate and group by - returns multiplesh Tom Lane
14:39 Re: [HACKERS] Re: [SQL] prob with aggregate and group by - returns multiplesh Peter Eisentraut
15:56 Re: [HACKERS] Re: [SQL] prob with aggregate and group by - returns multiplesh Bruce Momjian
15:56 Re: [HACKERS] Re: [SQL] prob with aggregate and group by - returns multiplesh Bruce Momjian
23:22 Need help on creating index for a query w/ 4 greater-than conditions Fan Chi Kam
23:38 Help Me!!!! Elsa Campos