Home > mailing lists

Mailing lists [pgsql-sql]

1 May 1999

06:26 linux scripting Ryan Bennetts
20:01 Re: [INTERFACES] Some needed features in postgresql Peter Garner

2 May 1999

01:38 Update problem I cannot work out M Simms
02:10 INSERT and UPDATE with non-atomic values Martin Jackson
02:17 RE: [SQL] Update problem I cannot work out Michael J Davis
08:02 Re: [SQL] INSERT and UPDATE with non-atomic values Chris Bitmead
11:40 Re: [SQL] Update problem I cannot work out M Simms
15:37 Re: [SQL] Update problem I cannot work out Tom Lane

3 May 1999

07:03 CASE vernichon eric
07:59 (no subject) Thomas Malkus
08:41 Re: [SQL] Index on date_trunc Herouth Maoz
11:45 Re: [SQL] CASE José Soares
12:09 Slow Inserts Again Frank Morton
12:23 No DIVIDE Operator Joerg Fischer
12:29 Re: [SQL] Slow Inserts Again Vadim Mikheev
12:37 Re: [SQL] Slow Inserts Again Frank Morton
12:49 Re: [SQL] Slow Inserts Again jwieck@debis.com (Jan Wieck)
12:49 Re: [SQL] Slow Inserts Again Herouth Maoz
12:56 Re: [SQL] Index on date_trunc Tom Lane
12:57 Re: [SQL] Slow Inserts Again Frank Morton
13:00 Re: [SQL] Slow Inserts Again pierre@desertmoon.com
13:16 Re: [SQL] No DIVIDE Operator Chris Bitmead
13:19 Re: [SQL] Slow Inserts Again Chris Bitmead
13:26 Re: [SQL] Slow Inserts Again Herouth Maoz
13:31 Re: [SQL] Index on date_trunc Herouth Maoz
13:33 Re: [SQL] No DIVIDE Operator Joerg Fischer
13:44 Re: [SQL] Slow Inserts Again Tom Lane
14:02 Re: [SQL] No DIVIDE Operator Chris Bitmead
14:21 Re: [SQL] Slow Inserts Again Frank Morton
14:31 convert text to varchar JT Kirkpatrick
14:39 RE: [SQL] convert text to varchar Michael J Davis
14:48 Re: [SQL] Slow Inserts Again Tom Lane
15:01 Re: [SQL] convert text to varchar Herouth Maoz
15:19 Re: [SQL] No DIVIDE Operator Bruce Momjian
15:22 Re: [SQL] Slow Inserts Again Bruce Momjian
16:01 pg_dump bug (was Re: [SQL] Slow Inserts Again) Ross J. Reedstrom
16:36 RE: [SQL] convert text to varchar JT Kirkpatrick
20:59 Re: [SQL] Slow Inserts Again Rudy Gireyev
22:47 Re: [SQL] Slow Inserts Again Frank Morton
22:58 Re: [SQL] Slow Inserts Again Tom Lane
23:03 Granting select on ALL tables at once G. Anthony Reina

4 May 1999

04:57 RE: [SQL] Granting select on ALL tables at once Michael J Davis
08:30 INSERT/UPDATE waiting Dirk Lutzebaeck
12:28 inheritance Ingrith Andrea Correa Vargas
12:55 Re: [HACKERS] pg_dump bug (was Re: [SQL] Slow Inserts Again) Thomas Lockhart
16:03 Re: [HACKERS] pg_dump bug (was Re: [SQL] Slow Inserts Again) Bruce Momjian
16:43 How to find SQL Functions G. Anthony Reina
17:06 Re: [SQL] How to find SQL Functions Ross J. Reedstrom
19:42 how to get "autonumber" when using INSERT INTO Richard Chrenko
19:45 Selecting with a large number of foreign keys Matt Behrens
20:08 Re: [SQL] Selecting with a large number of foreign keys Ross J. Reedstrom
20:32 Help me please !!!! Carlos Peralta Ramirez
22:34 Re: [SQL] Selecting with a large number of foreign keys Tom Lane
22:51 Re: [SQL] How to find SQL Functions Tom Lane

5 May 1999

04:03 RE: [SQL] inheritance Michael J Davis
04:10 Re: [SQL] inheritance Chris Bitmead
04:32 Re: [SQL] No DIVIDE Operator Joerg Fischer
05:40 Re: [HACKERS] pg_dump bug (was Re: [SQL] Slow Inserts Again) Thomas Lockhart
05:52 SQL-Query error with PGSQL 6.5beta1 Joerg Fischer
13:58 User and Groups Greg Frith
14:31 Authentication Eduardo J. Gargiulo
15:31 unsubscribe problems Michael J Davis
15:44 RE: [SQL] User and Groups Michael J Davis
18:45 which guru know this ?? Carlos Peralta Ramirez
18:57 RE: [GENERAL] which guru know this ?? Michael J Davis

6 May 1999

02:31 Re: INSERT/UPDATE waiting (another example) Wayne Piekarski
09:05 Re: [SQL] User and Groups Greg Frith
13:05 Re: [HACKERS] Re: INSERT/UPDATE waiting (another example) Tom Lane
14:12 RE: [SQL] User and Groups Michael J Davis

7 May 1999

00:30 the today question !!! Carlos Peralta Ramirez

8 May 1999

00:57 Functions for arrays !!!! Carlos Peralta Ramirez
13:50 Re: [SQL] Functions for arrays !!!! Tom Lane
16:00 TRANSLATE() Henrik Steffen

9 May 1999

07:09 Re: [HACKERS] Re: INSERT/UPDATE waiting (another example) Wayne Piekarski
10:32 Re: [SQL] Re: [HACKERS] Re: INSERT/UPDATE waiting (another example) Bruce Momjian
11:02 Re: [SQL] keeping OID's when copying table Bruce Momjian
13:38 Re: [SQL] TRANSLATE() Herouth Maoz
15:59 Re: [HACKERS] Re: INSERT/UPDATE waiting (another example) Tom Lane
16:12 Re: [SQL] keeping OID's when copying table Tom Lane
23:49 Re: [SQL] How match percent sign in SELECT using LIKE? Bruce Momjian

10 May 1999

03:32 Re: [SQL] Simple Optimization Problem Bruce Momjian
09:40 Re: [SQL] Re: [HACKERS] Re: INSERT/UPDATE waiting (another example) Wayne Piekarski
11:32 Re: [HACKERS] Re: INSERT/UPDATE waiting (another example) Wayne Piekarski
11:44 Having problem retrieving huge? table Ana Roizen
12:04 Slow Inserts Leads To Unable To Dump Frank Morton
14:28 Retrieving column names and table names of a database Matthias Seiferth
15:26 Re: [SQL] Confusion about DISTINCT. Bruce Momjian
15:30 Re: [SQL] Simple Optimization Problem Tom Lane
15:34 Re: [SQL] Strange behavior Bruce Momjian
15:35 Re: [SQL] Strange behavior Bruce Momjian
15:59 Re: [SQL] Slow Inserts Leads To Unable To Dump Tom Lane
17:30 Trigger question Adam H. Pendleton
17:40 RE: [SQL] Trigger question Michael J Davis
19:32 plpgsql error Adam H. Pendleton
19:45 RE: [SQL] plpgsql error Michael J Davis
20:05 Re: [SQL] plpgsql error Andy Lewis
20:35 Re: [SQL] plpgsql error Tom Lane

11 May 1999

06:37 Re: [SQL] plpgsql error jwieck@debis.com (Jan Wieck)
12:28 listo of larde objects Richard Bouska
13:22 RE: [SQL] plpgsql error Michael J Davis
13:29 Re: [SQL] plpgsql error Tom Lane
13:30 Re: [SQL] plpgsql error jwieck@debis.com (Jan Wieck)
13:57 Re: [SQL] plpgsql error Bruce Momjian
16:26 RE: [SQL] plpgsql error Dr. Nisai Wanakule
16:46 Re: [SQL] plpgsql error jwieck@debis.com (Jan Wieck)
21:22 More problems with arrays !!!!! Carlos Peralta Ramirez

12 May 1999

12:40 Function error Adam H. Pendleton
12:54 question about money type Marcio Macedo
14:14 Re: [SQL] question about money type D'Arcy" "J.M." Cain
15:21 Re: [SQL] question about money type jwieck@debis.com (Jan Wieck)
20:22 JOIN index/sequential select problem gjerde@icebox.org
21:57 Re: [SQL] JOIN index/sequential select problem Tom Lane
22:13 Re: [SQL] JOIN index/sequential select problem gjerde@icebox.org
23:40 Re: [SQL] JOIN index/sequential select problem Tom Lane

13 May 1999

04:00 Re: [SQL] JOIN index/sequential select problem gjerde@icebox.org
04:24 Re: [SQL] JOIN index/sequential select problem Bruce Momjian
06:41 Re: [SQL] JOIN index/sequential select problem Ole Gjerde
08:09 TEXT, VARCHAR(50) or CHAR(50)? Henrik Steffen
08:10 VARCHAR(50), CHAR(50) or TEXT ? Henrik Steffen
10:16 Re: [SQL] VARCHAR(50), CHAR(50) or TEXT ? Henrik Steffen
11:01 Re: [SQL] VARCHAR(50), CHAR(50) or TEXT ? Brett W. McCoy
13:12 Re: [SQL] VARCHAR(50), CHAR(50) or TEXT ? Tom Lane
15:09 Re: [SQL] VARCHAR(50), CHAR(50) or TEXT ? Bruce Momjian
23:15 Re: [SQL] JOIN index/sequential select problem Tom Lane

14 May 1999

15:57 Oddities with NULL and GROUP BY secret
16:35 Create Rule problems Doug Younger
16:49 Create Rule problems Doug Younger
17:10 RE: [SQL] Oddities with NULL and GROUP BY Jackson, DeJuan
17:17 Re: [SQL] JOIN index/sequential select problem Ole Gjerde
17:28 Re: pgsql-sql-digest V1 #225 Steven M. Wheeler
20:10 Re: [SQL] JOIN index/sequential select problem Tom Lane
20:39 Re: [SQL] Re: pgsql-sql-digest V1 #225 Tom Lane

15 May 1999

02:51 RE: [SQL] Re: pgsql-sql-digest V1 #225 Jackson, DeJuan

16 May 1999

19:39 offtopic: db-processing speedup in C Engard Ferenc
19:40 Re: [SQL] Slow Inserts Leads To Unable To Dump Engard Ferenc

17 May 1999

08:57 Re: [SQL] Create Rule problems jwieck@debis.com (Jan Wieck)
11:21 creating a new table with data from other tables Willian Jakobs
12:14 Re: [SQL] Oddities with NULL and GROUP BY secret
12:49 Re: [SQL] Oddities with NULL and GROUP BY secret
13:56 delete with and Mario Olimpio de Menezes
14:10 Delete with AND Mario Olimpio de Menezes
14:38 Re: [SQL] Oddities with NULL and GROUP BY José Soares
14:52 is there any docs for new LOCK TABLE statement ? David Sauer
16:04 Re: [SQL] Create Rule problems Doug Younger
17:00 Encriptacion en Bases de Datos Israel Zavalza Bahena
17:04 RE: [SQL] Delete with AND Jackson, DeJuan
23:54 Re: [SQL] is there any docs for new LOCK TABLE statement ? Vadim Mikheev

18 May 1999

00:00 Re: Re: [SQL] is there any docs for new LOCK TABLE statement ? Vadim Mikheev
04:26 (no subject) Ivanko Alexandr
09:09 querying arrays Heiko Wilms
11:59 Re: Retrieving column names and table names of a database nourry@ensinfo.univ-nantes.fr (Frederic Nourry)
13:41 Updating and null values. Ana Roizen
14:13 Re: [SQL] Updating and null values. Tom Lane
15:25 Function and trigger problem Adam H. Pendleton
15:52 RE: [SQL] Function and trigger problem Michael J Davis
16:29 Re: [SQL] Function and trigger problem Adam H. Pendleton

19 May 1999

03:28 (no subject) Robert Chalmers
03:48 Why wont this update work? Robert Chalmers
04:06 Re: [SQL] Why wont this update work? Chris Bitmead
06:02 query an array... Heiko Wilms
08:24 Test access Roberto Fichera
12:08 Re: [SQL] Why wont this update work? Jason Earl
12:27 Re: [SQL] query an array... Jason Earl
12:47 Re: [SQL] Oddities with NULL and GROUP BY secret
12:52 Re: [SQL] Oddities with NULL and GROUP BY Herouth Maoz
12:54 Re: [SQL] Why wont this update work? Tom Lane
13:21 Re: [SQL] Why wont this update work? José Soares
13:42 Re: [SQL] Oddities with NULL and GROUP BY José Soares
13:46 Re: [HACKERS] Re: [SQL] Oddities with NULL and GROUP BY Tom Lane
14:15 Re: [HACKERS] Re: [SQL] Oddities with NULL and GROUP BY Thomas Lockhart
14:29 Re: [HACKERS] Re: [SQL] Oddities with NULL and GROUP BY secret
14:31 Re: [HACKERS] Re: [SQL] Oddities with NULL and GROUP BY Herouth Maoz
14:44 Testing permissions Roberto Fichera
14:44 Re: [HACKERS] Re: [SQL] Oddities with NULL and GROUP BY Herouth Maoz

20 May 1999

10:02 deleting all tables in the list Willian Jakobs

21 May 1999

13:13 Regarding the connectivity chavali sridhar

22 May 1999

13:03 Problems with refint.so and 6.5 Beta Michael Scheuner
13:12 Problems with refint.so and 6.5 Beta Michael Scheuner
13:49 Re: [SQL] Problems with refint.so and 6.5 Beta Tom Lane

23 May 1999

00:00 Re: [SQL] Problems with refint.so and 6.5 Beta Bruce Momjian
18:59 Re: [SQL] Problems with refint.so and 6.5 Beta Michael Scheuner

24 May 1999

02:27 Undeliverable Message
16:40 ... Guillaume Marçais
17:54 RE: [SQL] Problems with refint.so and 6.5 Beta Jackson, DeJuan
18:11 Re: [SQL] Re: pgsql-sql-digest V1 #225 Steven M. Wheeler
18:21 Update of two tables in a trigger Christian Ullrich
18:47 Fatal process interaction Steven M. Wheeler
20:32 Re: [SQL] Re: pgsql-sql-digest V1 #225 Bruce Momjian
22:46 index on int8 in PG 6.4.2 Mirek Budzanowski
23:00 Re: [SQL] Re: pgsql-sql-digest V1 #225 Tom Lane
23:34 Re: [SQL] Fatal process interaction Tom Lane
23:39 Re: [SQL] index on int8 in PG 6.4.2 Tom Lane

25 May 1999

05:12 Undeliverable Message
16:10 Stupid SQl question on inserting items Zot O'Connor
16:27 Re: [SQL] Stupid SQl question on inserting items Gregory W Burnham
16:35 Re: [SQL] Stupid SQl question on inserting items Oleg Bartunov
17:54 Re: [SQL] Fatal process interaction Steven M. Wheeler
18:05 Re: [SQL] Fatal process interaction Tom Lane
18:20 Re: [SQL] Fatal process interaction Steven M. Wheeler
18:31 Re: [SQL] Stupid SQl question on inserting items D'Arcy" "J.M." Cain
19:11 using like JT Kirkpatrick
19:15 using like JT Kirkpatrick
19:21 Re: [SQL] using like Brett W. McCoy
19:23 Re: [SQL] using like Brett W. McCoy
19:31 Re: [SQL] Stupid SQl question on inserting items Oliver Elphick
19:36 RE: [SQL] using like JT Kirkpatrick

26 May 1999

11:24 about permissions Remigiusz Sokolowski
11:45 CASE WHEN / 6.4.2? + no doc in installed documentation Emils Klotins
12:43 Re: [SQL] about permissions wieck@debis.com (Jan Wieck)
12:51 Re: [SQL] about permissions wieck@debis.com (Jan Wieck)
13:05 Re: [SQL] about permissions Remigiusz Sokolowski
13:08 Re: [SQL] CASE WHEN / 6.4.2? + no doc in installed documentation Tom Lane
16:47 select nextval. . . JT Kirkpatrick
17:13 Re: [SQL] Re: pgsql-sql-digest V1 #225 Steven M. Wheeler
22:05 Re: [SQL] CASE WHEN / 6.4.2? + no doc in installed documentation Fomichev Michael

27 May 1999

00:18 pgsql and shopping carts - is there any development code out there? Robert Chalmers
03:37 Re: [SQL] pgsql and shopping carts - is there any development code out there? Mr. Poet
05:59 Re: [SQL] VARCHAR(50), CHAR(50) or TEXT ? Doo Suk Yang
06:08 Re: [SQL] VARCHAR(50), CHAR(50) or TEXT ? Chris Bitmead
11:56 Re: [SQL] about permissions Remigiusz Sokolowski
12:54 notifying Mirek Budzanowski
14:05 RE: [SQL] pgsql and shopping carts - is there any development cod e out there? Jackson, DeJuan
14:17 RE: [SQL] VARCHAR(50), CHAR(50) or TEXT ? Jackson, DeJuan
14:27 RE: [SQL] select nextval. . . Jackson, DeJuan
14:41 RE: [SQL] select nextval. . . JT Kirkpatrick
15:00 RE: [SQL] select nextval. . . Jackson, DeJuan
15:09 RE: [SQL] select nextval. . . JT Kirkpatrick
15:24 2 Table Select Andy Lewis
16:19 Re: [SQL] notifying Tom Lane
18:44 Re: [SQL] 2 Table Select Oliver Elphick
19:28 Buffered input for big numeric input files Guillaume Marçais
19:37 Re: [SQL] 2 Table Select Andy Lewis
22:12 How do I implement FIFO? Mark Wright
23:45 using variable in nextval George Wadsworth
23:59 Andrei de Oliveira Mosman

28 May 1999

00:03 Andrei de Oliveira Mosman
05:04 (no subject) Ivanko Alexandr
07:33 [?]Nobody hasn't add column? curry
07:59 Re: [SQL] [?]Nobody hasn't add column? Remigiusz Sokolowski
14:47 [SQL] 'denormalising' with a select Stuart Rison
23:33 Does PostgreSQL have an UPDATE Function like UNIFY? John J. Boris, Sr.

29 May 1999

11:29 Re: [SQL] Does PostgreSQL have an UPDATE Function like UNIFY? D'Arcy" "J.M." Cain
13:55 Re: [SQL] Does PostgreSQL have an UPDATE Function like UNIFY? Tom Lane

30 May 1999

10:24 Re: [SQL] 2 Table Select Herouth Maoz
12:13 Re: [SQL] Does PostgreSQL have an UPDATE Function like UNIFY? Herouth Maoz
14:30 Re: [SQL] Does PostgreSQL have an UPDATE Function like UNIFY? John J. Boris, Sr.
20:53 strftime or date_format like function? Zsolt Varga
21:16 Strftime or Date_format like function? Zsolt Varga
21:20 strftime or date_format like function? Zsolt Varga

31 May 1999

05:46 Database Design question Heiko Wilms
07:23 Re: [SQL] Database Design question Herouth Maoz
07:42 indexes Remigiusz Sokolowski
07:51 Re: [SQL] indexes Vadim Mikheev
08:36 Re: [SQL] indexes Remigiusz Sokolowski
10:55 Re: [SQL] indexes Vadim Mikheev
14:21 Re: [SQL] indexes Tom Lane
14:24 Re: [SQL] indexes Heiko Wilms
16:29 Re: [SQL] indexes Tom Lane
23:53 column name's length Pham, Thinh