Home > mailing lists

Mailing lists [pgsql-sql]

1 January 2000

18:49 timespan problem Tulassay Zsolt
21:59 Re: [SQL] timespan problem Tom Lane

2 January 2000

13:36 unsubscribe lyman1@mindspring.com

3 January 2000

05:33 Re: [SQL] timespan problem Thomas Lockhart
13:05 Re: [SQL] timespan problem Tom Lane
13:39 Re: [SQL] timespan problem Thomas Lockhart
15:02 restriction clause selectivity bad value Wallingford, Ted
15:14 Re: [ADMIN] restriction clause selectivity bad value Marcio Macedo
15:20 Re: [ADMIN] restriction clause selectivity bad value Bruce Momjian
15:21 Re: [ADMIN] restriction clause selectivity bad valueu Bruce Momjian

4 January 2000

12:48 datetime fields have '60' in seconds field Werner Fraga
13:01 Triggers Mitch Vincent
13:55 Re: [SQL] Triggers Tom Lane
14:18 Re: [SQL] Triggers Mitch Vincent
16:44 Re: [SQL] Triggers Jan Wieck
17:29 Re: [SQL] Triggers Matthew Hagerty
22:10 Calculation dependencies in views Rick Delaney
23:07 Re: [SQL] Calculation dependencies in views Jan Wieck

5 January 2000

03:35 Re: [SQL] Calculation dependencies in views Tom Lane
06:39 Re: [SQL] datetime fields have '60' in seconds field omid omoomi
11:55 plpgsql bug(?) Kovacs Zoltan
13:11 Re: [SQL] plpgsql bug(?) Jan Wieck
13:33 Re: [SQL] datetime fields have '60' in seconds field Tom Lane
18:11 Re: [SQL] Calculation dependencies in views Rick Delaney
18:16 Re: [SQL] Calculation dependencies in views Rick Delaney
19:52 Re: [SQL] Calculation dependencies in views Jan Wieck
21:09 Re: [SQL] Calculation dependencies in views Rick Delaney
22:13 Re: [SQL] Calculation dependencies in views Jan Wieck
22:59 Autonumber column Bron Till
23:34 Re: [SQL] Autonumber column Bruce Momjian
23:47 Re: [SQL] Calculation dependencies in views Tom Lane

6 January 2000

06:25 Re: [SQL] Autonumber column Vladimir Terziev
17:43 Re: [SQL] Calculation dependencies in views Rick Delaney

7 January 2000

00:36 Serial field starting at 100 ? Richard Walker
13:57 Re: [SQL] Serial field starting at 100 ? Vladimir Terziev
15:00 Is there something wrong with datatype float8 ??? Ana Roizen
17:17 Re: [SQL] datetime fields have '60' in seconds field Werner Fraga

8 January 2000

04:09 createdb -D xxxx not working Chris Griffin
04:49 Re: [SQL] createdb -D xxxx not working Tom Lane
05:04 Could this be done better...? The Hermit Hacker

9 January 2000

21:03 Re: [SQL] Serial field starting at 100 ? Richard Walker

10 January 2000

00:35 can't seem to use index admin
11:16 query to do a backward 'skip', possible with (index) optimization ? Albert Loo
13:18 Re: [SQL] query to do a backward 'skip', possible with (index) optimization ? Tom Lane
13:23 Simmultanous Connections Jude Weaver
17:14 Re: [SQL] query to do a backward 'skip', possible with (index) optimization ? Alain TESIO
19:26 problems creating functions, triggers, and rules Werner Fraga
20:32 problems creating functions and triggers Werner Fraga
22:41 Re: [SQL] problems creating functions and triggers Tom Lane

11 January 2000

11:27 Re: [SQL] createdb -D xxxx not working Peter Eisentraut
13:14 Re: [SQL] createdb -D xxxx not working Tom Lane
13:21 best strategy doing a large copy and using indexes Dirk Lutzebaeck
13:55 Re: [HACKERS] Re: [SQL] createdb -D xxxx not working Thomas Lockhart
14:15 Re: [SQL] best strategy doing a large copy and using indexes Tom Lane
18:39 Problem with array syntax Web Manager
19:13 Problem with array syntax Web Manager

12 January 2000

05:56 mdopen: couldn't open Prakash
07:35 Not Allowing Users to Create Tables Neil Cameron
08:09 simple question Thomas Leavitt
08:28 function parameters/output values Thomas Leavitt
10:53 Re: [SQL] query to do a backward 'skip' ...thanks, it's working. Albert Loo
11:51 help. Alexandr Listopad
15:13 stats on select admin
15:53 Rules, triggers, ??? - What is the best way to enforce data-valid ation tests? Greg Youngblood
21:23 Re: [SQL] function parameters/output values Peter Eisentraut
22:40 RE: [SQL] function parameters/output values Thomas Leavitt

13 January 2000

00:26 Getting environment variables? mpg4@duluoz.net
09:14 foreign key implementation Pausas Fuentes, Jaume
19:23 Re: [SQL] foreign key implementation Oliver Elphick

14 January 2000

06:10 key set delete query Michael McCarthy
06:41 Optimizing ORDER BY with indexes? Dirk Lutzebaeck
07:31 Re: [SQL] Optimizing ORDER BY with indexes? Dirk Lutzebaeck
07:34 Re: [SQL] Optimizing ORDER BY with indexes? Dirk Lutzebaeck
13:03 Re: [SQL] key set delete query Tom Lane
13:19 Re: [SQL] Optimizing ORDER BY with indexes? Tom Lane
14:53 Re: [SQL] Optimizing ORDER BY with indexes? Bruce Momjian
14:54 numeric question.. Mitch Vincent
19:15 Aggregates and Views Mark Volpe
19:17 Re: Aggregates & Views Mark Volpe
19:28 Re: [SQL] numeric question.. Tom Lane
19:36 Re: [SQL] numeric question.. Mitch Vincent
20:27 Re: [SQL] Aggregates and Views Tom Lane
21:10 Re: [SQL] numeric question.. Tom Lane

15 January 2000

09:21 (no subject) Michal Frajt
23:08 Patches for various NUMERIC bugs posted on pgsql-patches Tom Lane

16 January 2000

10:55 ... Egon Rothenberger
15:07 Re: [SQL] Getting environment variables? Peter Eisentraut
15:08 Re: [SQL] numeric question.. Peter Eisentraut
15:35 Re: [SQL] numeric question.. Tom Lane
16:21 attribute level rules not supported? Marc Tardif

17 January 2000

06:18 Antw: [SQL] attribute level rules not supported? Gerhard Dieringer
18:03 index usage ... strange !? Marten Feldtmann
20:28 Re: [SQL] index usage ... strange !? Tom Lane

18 January 2000

02:15 ordering operator for bytea Michael McCarthy
03:07 Re: [SQL] ordering operator for bytea Tom Lane
15:20 Ordering a date_part() query ... The Hermit Hacker
15:44 Re: [SQL] Ordering a date_part() query ... Mark Volpe
16:29 Re: [SQL] Ordering a date_part() query ... Bruce Momjian
16:29 Re: [SQL] Ordering a date_part() query ... Bruce Momjian
16:48 Re: [SQL] Ordering a date_part() query ... Mark Volpe
16:49 Re: [SQL] Ordering a date_part() query ... omid omoomi
16:49 Re: [SQL] Ordering a date_part() query ... omid omoomi
17:06 char(19) to varchar(32) Marc Tardif
17:07 Re: [SQL] Ordering a date_part() query ... Bruce Momjian
17:17 Re: [SQL] Ordering a date_part() query ... The Hermit Hacker
17:46 Re: [SQL] Ordering a date_part() query ... Tom Lane
19:08 Re: [SQL] Ordering a date_part() query ... The Hermit Hacker
20:27 Re: [SQL] Ordering a date_part() query ... Tom Lane
20:44 Re: [SQL] Ordering a date_part() query ... The Hermit Hacker

19 January 2000

01:09 Re: [SQL] index usage ... strange !? Marten Feldtmann
10:29 Bug in CEIL? Mark Alliban
11:26 Bug in CEIL? Mark Alliban
11:59 Re: [SQL] char(19) to varchar(32) Jose Soares
13:02 Re: [SQL] Bug in CEIL? Tom Lane
13:42 Re: [SQL] char(19) to varchar(32) Tom Lane
13:57 Re: [SQL] char(19) to varchar(32) Marc Tardif
14:28 (no subject) Sevo Stille
15:25 Re: [SQL] char(19) to varchar(32) Tom Lane
15:50 Re: [SQL] index usage ... strange !? Marten Feldtmann
16:07 Re: [SQL] index usage ... strange !? Tom Lane
16:12 Re: [SQL] char(19) to varchar(32) Tom Lane
17:13 Foreign Keys, Triggers and such Daniel Spratlen
18:42 Re: [SQL] Foreign Keys, Triggers and such Marc Tardif
22:57 null and integer field Hamid Khoshnevis

20 January 2000

00:20 Re: [SQL] null and integer field Tom Lane
01:16 round() and || Graeme Merrall
04:35 Re: [SQL] round() and || Tom Lane
06:17 inserting values into arrays T.I.P.
07:20 [SQL] inserting values into arrays T.I.P.
07:27 inserting values into arrays Kovacs Zoltan
09:41 crypt in Postgres? Emils Klotins
09:55 Help for performance dLux
09:59 Re: [SQL] crypt in Postgres? Peter Eisentraut
10:35 inserting values into arrays Kovacs Zoltan
10:35 inserting values into arrays Kovacs Zoltan
10:57 sql performance help needed dLux
11:08 inserting values into arrays T.I.P.
11:37 insert values into arrays Kovacs Zoltan Sandor
11:41 insert values into arrays Kovacs Zoltan Sandor
11:53 Geometric types in SELECT? mpg4@duluoz.net
11:54 Re: [SQL] crypt in Postgres? darcy@druid.net (D'Arcy J.M. Cain)
12:42 Re: [SQL] crypt in Postgres? Peter Mount
13:16 inserting values into arrays Thomas Lockhart
19:49 Re: [SQL] insert values into arrays Peter Eisentraut
23:22 Re: [SQL] Geometric types in SELECT? Tom Lane

21 January 2000

10:26 (no subject) david tzuriel
11:46 ... Laszlo, Tibor
13:06 Problem with large tuples. Patrik Kudo
13:09 Duplicate tuples with unique index Patrik Kudo
13:38 Re: [SQL] Problem with large tuples. Dirk Lutzebaeck
14:23 Re: [SQL] Duplicate tuples with unique index Tom Lane
15:00 DISTINCT and aggregates Brook Milligan
15:30 SQL Things Neil Cameron
15:52 psql - odbc - bde Tibor Laszlo
15:56 ... Tibor Laszlo
16:38 Re: [SQL] DISTINCT and aggregates Tom Lane
21:45 Re: [SQL] SQL Things De Moudt Walter

22 January 2000

15:21 More efficient DELETE ... ? The Hermit Hacker
16:05 Re: [SQL] More efficient DELETE ... ? Bruce Momjian
16:05 geo_distance radius question Mark Stosberg
16:09 Re: [SQL] More efficient DELETE ... ? Tom Lane
16:30 Repost: restore from dump problem - query buffer full Web Manager
17:40 Re: [SQL] More efficient DELETE ... ? Bruce Momjian
19:14 how many inserts in one transaction? gav
19:44 Re: [SQL] More efficient DELETE ... ? Tom Lane
21:20 Re: [SQL] More efficient DELETE ... ? The Hermit Hacker
23:23 Re: [SQL] SQL Things Peter Eisentraut

23 January 2000

05:25 Re: [SQL] how many inserts in one transaction? Christopher Sawtell
06:52 (no subject) Dmitry A. Alyekhin
11:42 pqReadData... gav
14:19 Re: [SQL] pqReadData... Tom Lane
15:40 Join-Question Dorthe Luebbert
20:39 Re: [SQL] Join-Question
22:35 can I index a field of type "point"? Mark Stosberg
23:16 Re: [SQL] can I index a field of type "point"? Gene Selkov, Jr.

24 January 2000

02:16 Question about COPY command Mercury He
08:01 Re: [SQL] Duplicate tuples with unique index Patrik Kudo
12:50 Blobs Neil Cameron
13:55 Re: [SQL] Blobs Mathijs Brands
14:10 Fwd: Re: [SQL] Blobs Compte utilisateur Sultan-advl
14:14 Backend crash Mark Volpe
14:24 Backend crash Mark Volpe
15:17 Re: [SQL] Backend crash Tom Lane
15:18 Re: [SQL] Backend crash Bruce Momjian
16:58 Re: [SQL] Backend crash Mark Volpe
17:09 Re: [SQL] Backend crash Bruce Momjian
18:04 Re: [SQL] Join-Question De Moudt Walter
19:05 Re: [SQL] Backend crash Alain TESIO
20:32 Re: [SQL] Backend crash Bruce Momjian
21:42 Re: [SQL] Blobs Peter Eisentraut
23:50 DISTINCT ON: speak now or forever hold your peace Tom Lane
23:52 JDK1.2 Driver to Postgresql 6.5.3 - connection problem Tom Donaldson

25 January 2000

00:44 Re: [HACKERS] DISTINCT ON: speak now or forever hold your peace Chris Bitmead
00:55 Re: [HACKERS] DISTINCT ON: speak now or forever hold your peace Mike Mascari
01:04 Re: [HACKERS] DISTINCT ON: speak now or forever hold your peace Philip Warner
01:12 Re: [HACKERS] DISTINCT ON: speak now or forever hold your peace Chris Bitmead
01:13 Re: [HACKERS] DISTINCT ON: speak now or forever hold your peace Bruce Momjian
01:46 Re: [HACKERS] DISTINCT ON: speak now or forever hold your peace Tom Lane
01:57 Re: [HACKERS] DISTINCT ON: speak now or forever hold your peace Bruce Momjian
02:06 Cannot flush block 9782 Chairudin Sentosa Harjo
05:16 Re: [HACKERS] DISTINCT ON: speak now or forever hold your peace Adriaan Joubert
05:45 Re: [HACKERS] DISTINCT ON: speak now or forever hold your peace Tom Lane
06:30 Re: [SQL] DISTINCT ON: speak now or forever hold your peace Julian Scarfe
08:30 Re: [SQL] Re: [HACKERS] DISTINCT ON: speak now or forever hold your peace Peter Eisentraut
08:59 Re: [SQL] DISTINCT ON: speak now or forever hold your peace Peter Eisentraut
09:29 Re: [SQL] Problem with large tuples. Palle Girgensohn
11:31 Re: [SQL] DISTINCT ON: speak now or forever hold your peace Julian Scarfe
14:03 Re: [SQL] Duplicate tuples with unique index Palle Girgensohn
14:26 Re: [SQL] Duplicate tuples with unique index Tom Lane
15:17 Re: [SQL] DISTINCT ON: speak now or forever hold your peace Tom Lane
15:18 Re: [SQL] Problem with large tuples. Tom Lane
18:32 Re: [SQL] Duplicate tuples with unique index Bruce Momjian
20:44 Re: [HACKERS] Re: [SQL] DISTINCT ON: speak now or forever hold your peace Bruce Momjian
21:53 rachel.jpg sej@isa.dknet.dk
22:28 Re: [SQL] Problem with large tuples. Palle Girgensohn
22:33 Re: [SQL] Duplicate tuples with unique index Palle Girgensohn
22:39 Re: [SQL] Duplicate tuples with unique index Palle Girgensohn
22:48 Re: [SQL] Duplicate tuples with unique index Bruce Momjian

26 January 2000

03:40 Re: [SQL] Duplicate tuples with unique index Tom Lane
03:46 Re: [SQL] Duplicate tuples with unique index Bruce Momjian
05:12 Re: [SQL] Question about COPY command Christopher Sawtell
09:05 dumping groups and users Kovacs Zoltan Sandor
10:59 Re: [SQL] dumping groups and users Kovacs Zoltan Sandor
13:08 Re: [SQL] Duplicate tuples with unique index Palle Girgensohn
16:29 Re: [HACKERS] DISTINCT ON: speak now or forever hold your peace Peter Eisentraut
16:30 Re: [HACKERS] DISTINCT ON: speak now or forever hold your peace Peter Eisentraut
16:41 Re: [HACKERS] DISTINCT ON: speak now or forever hold your peace Tom Lane
18:29 Help understanding how indexes are used by the query optimizer Peter Bojanic
20:24 Re: [HACKERS] DISTINCT ON: speak now or forever hold your peace Philip Warner
20:57 Re: [HACKERS] Re: [SQL] DISTINCT ON: speak now or forever hold your peace Chris Bitmead
21:02 RE: [SQL] Duplicate tuples with unique index Iain.Mott@CMIS.CSIRO.AU
21:06 Re: [HACKERS] Re: [SQL] DISTINCT ON: speak now or forever hold your peace Tom Lane
21:33 Re: [HACKERS] Re: [SQL] DISTINCT ON: speak now or forever hold your peace Bruce Momjian

27 January 2000

03:44 Ars Digita and PostgreSQL Chris Bitmead
11:07 Problem with SELECT on large negative INT4 Nicolas Huillard
14:30 RE: [GENERAL] Problem with SELECT on large negative INT4 Hiroshi Inoue
14:39 Re: [SQL] RE: [GENERAL] Problem with SELECT on large negative INT4 Bruce Momjian
14:46 Re: [HACKERS] Ars Digita and PostgreSQL Don Baccus
15:29 18 yr. old blonde 5963 uihtot@myhome.net
15:38 Re: [SQL] Rules, triggers, ??? - What is the best way to enforce data-valid ation tests?? wieck@debis.com (Jan Wieck)
15:39 Re: [SQL] foreign key implementation wieck@debis.com (Jan Wieck)
15:53 Re: [SQL] RE: [GENERAL] Problem with SELECT on large negative INT4 Tom Lane
15:53 RE: [GENERAL] Problem with SELECT on large negative INT4 Nicolas Huillard
16:00 Re: [SQL] RE: [GENERAL] Problem with SELECT on large negative INT4 Bruce Momjian
16:08 Problems with create temporary table and select ... into Gabriel Fernandez
16:21 Someone can help please? SELECT problems moreno
16:34 Re: [SQL] DISTINCT ON: speak now or forever hold your peace Tom Lane
18:30 transaction aborted Mark Wilson
20:22 Re: [HACKERS] DISTINCT ON: speak now or forever hold your peace Peter Eisentraut
21:06 User-defined error messages Vince Gonzalez
21:14 User-defined error messages/codes Vince Gonzalez
21:43 Re: [SQL] User-defined error messages/codes Vince Gonzalez
21:55 RE: [SQL] RE: [GENERAL] Problem with SELECT on large negative INT4 Hiroshi Inoue
23:22 Re: [HACKERS] DISTINCT ON: speak now or forever hold your peace Philip Warner

28 January 2000

01:13 Re: [SQL] Problems with create temporary table and select ... into Chairudin Sentosa Harjo
01:54 Re: [GENERAL] Problem with SELECT on large negative INT4 John Brothers
01:57 Re: [SQL] RE: [GENERAL] Problem with SELECT on large negative INT4 John Brothers
02:35 RE: [SQL] RE: [GENERAL] Problem with SELECT on large negative INT4 Hiroshi Inoue
02:49 Re: [SQL] RE: [GENERAL] Problem with SELECT on large negative INT4 Tom Lane
03:35 Re: [SQL] RE: [GENERAL] Problem with SELECT on large negative INT4 Bruce Momjian
04:00 Re: [SQL] RE: [GENERAL] Problem with SELECT on large negative INT4 Tom Lane
05:00 RE: [SQL] RE: [GENERAL] Problem with SELECT on large negative INT4 Hiroshi Inoue
15:21 Re: [SQL] RE: [GENERAL] Problem with SELECT on large negative INT4 Bruce Momjian
15:24 Re: [SQL] RE: [GENERAL] Problem with SELECT on large negative INT4 Bruce Momjian
19:42 RE: [SQL] RE: [GENERAL] Problem with SELECT on large negative INT4 Nicolas Huillard
20:32 RE: [SQL] RE: [GENERAL] Problem with SELECT on large negative INT4 Nicolas Huillard

29 January 2000

02:23 Help with pl/pgsql, triggers, and foreign keys Roland Roberts
04:01 Re: [HACKERS] Help with pl/pgsql, triggers, and foreign keys Don Baccus
06:36 Re: [HACKERS] Help with pl/pgsql, triggers, and foreign keys Ed Loehr
09:07 Re: [SQL] transaction aborted Peter Eisentraut
16:56 inet/cidr - can this be done? Mark Volpe

30 January 2000

01:04 Re: [SQL] transaction aborted root
02:01 Where is `COMMENT ON' syntex documented Roland Roberts
02:15 Re: [SQL] Where is `COMMENT ON' syntex documented Bruce Momjian
19:03 "Group by" and "index". Vlad Marchenko
19:25 "Group by" and "index". Vlad Marchenko
20:30 Re: [SQL] "Group by" and "index". Tom Lane

31 January 2000

08:01 Re: [HACKERS] Help with pl/pgsql, triggers, and foreign keys wieck@debis.com (Jan Wieck)
10:21 Re: [SQL] inet/cidr - can this be done? Peter Eisentraut
20:00 now() returning int4 Marc Tardif
20:28 Re: [SQL] now() returning int4 Ross J. Reedstrom
21:02 GROUP BY: v6.1 vs. v6.5.2 Ray Plante