Home > mailing lists

Mailing lists [pgsql-sql]

1 June 1999

02:30 Re: [SQL] Column name's length Zalman Stern
02:37 Re: [SQL] Column name's length Bruce Momjian
02:45 Re: [SQL] indexes Remigiusz Sokolowski
03:07 Can I modify a field size in a table? Robert Chalmers
03:34 Re: [SQL] Column name's length Zalman Stern
03:50 Re: [SQL] indexes Vadim Mikheev
04:02 Re: [SQL] indexes Remigiusz Sokolowski
04:16 problem in running plpgsql functions vineet w.singh
09:09 RE: [SQL] Column name's length Pham, Thinh
09:52 Re: [SQL] 'denormalising' with a select Herouth Maoz
09:57 Outer Join Two Tables ZHENG, PHILLIP
10:06 Re: [SQL] indexes Tom Lane
10:31 Re: [SQL] Column name's length Bruce Momjian
10:46 Data recovery Bob Kruger
11:01 Re: [SQL] Column name's length Bruce Momjian
11:29 RE: [SQL] Column name's length Pham, Thinh
11:36 Re: [SQL] Data recovery Tom Lane
12:28 Re: [SQL] Column name's length Tom Lane
12:42 RE: [SQL] Column name's length Pham, Thinh
13:17 Re: [ADMIN] Re: [SQL] Data recovery wieck@debis.com (Jan Wieck)
13:28 Re: [ADMIN] Re: [SQL] Data recovery Bruce Momjian
15:05 Re: [ADMIN] Re: [SQL] Data recovery wieck@debis.com (Jan Wieck)
15:18 Re: [ADMIN] Re: [SQL] Data recovery Bruce Momjian
16:09 datetime function Pham, Thinh
17:32 Re: [SQL] Column name's length Tom Lane
17:42 Standard SQL commands - are they in 6.5? Robert Chalmers
17:49 RE: [SQL] Column name's length Pham, Thinh
18:19 help??? Now I can't drop a renamed column.... Robert Chalmers
20:16 Re: [SQL] Column name's length Zalman Stern
22:08 Order by Michael Yeung

2 June 1999

04:39 Re: [SQL] Order by wieck@debis.com (Jan Wieck)
05:34 Re: [SQL] Order by Herouth Maoz
05:35 RE: [SQL] Column name's length Herbert Ambos
06:48 Re: [SQL] Order by wieck@debis.com (Jan Wieck)
10:06 Re: [SQL] Order by Herouth Maoz
10:52 Re: [SQL] Order by wieck@debis.com (Jan Wieck)
11:07 Re: [SQL] Order by Herouth Maoz
11:18 RE: [GENERAL][SQL] 'denormalising' with a select Stuart Rison
11:22 RE: [SQL] Column name's length Pham, Thinh
14:34 OUTER JOINS in PostgreSQL ant9000@c0a111.science.unitn.it
15:12 how to delete access rights from non-existent user ? David Sauer
15:15 Did version 6.5 make foreign keys functional? Tiffany Renee' Davis
16:48 OUTER JOINs in PostgreSQL Ant9000
17:09 Re: [SQL] OUTER JOINs in PostgreSQL Jason Earl
17:30 Getting primary key from insert statement Pham, Thinh
18:18 Are PL/pgSQL calls atomic? Mark Wright
18:54 Re: [SQL] Getting primary key from insert statement D'Arcy" "J.M." Cain
21:25 Re: [SQL] Are PL/pgSQL calls atomic? Vadim Mikheev

3 June 1999

04:15 VARCHAR & INDEXES. Context search. Need help. Sergey Zeleniy
06:26 Re: [SQL] Are PL/pgSQL calls atomic? wieck@debis.com (Jan Wieck)
09:35 [SQL] Geometric, getting x and y co-ordinates from point data type/ Stuart Rison
10:47 Re: [SQL] Are PL/pgSQL calls atomic? Mark Wright
10:58 rule plan too big Phil DiCorpo
11:25 RE: [SQL] Column name's length - found out the problem Pham, Thinh
11:52 rule plan too big (fwd) Phil DiCorpo
12:26 Re: [SQL] rule plan too big (fwd) wieck@debis.com (Jan Wieck)
13:03 Re: [SQL] rule plan too big (fwd) Bruce Momjian
16:40 I'm causing deadlocks! Mark Wright
21:53 Group By Dilemma Tim Perdue
23:19 Slashdot Query Chris Bitmead

4 June 1999

01:13 Embedded SQL in 'C' nathan@khmere.com
03:42 Re: [SQL] Group By Dilemma Oliver Elphick
03:58 Mail about select Vikrant Rathore
06:45 Howto convert floats to text? Martin Leja
08:25 SQL Problem: ERROR: ExecEvalExpr: unknown expression type 108 Michael Klemme
08:55 Re: [SQL] Howto convert floats to text? José Soares
09:07 A little problem updating data with views Jorge Herrera Piñero
09:17 RV: A little problem updating data with views Jorge Herrera Piñero
09:25 Re: [SQL] RV: A little problem updating data with views Chris Bitmead
11:27 Re: [SQL] RV: A little problem updating data with views Tom Lane
11:27 Re: [SQL] datetime function José Soares
11:30 Re: [SQL] Mail about select Tom Lane
11:30 Re: [SQL] Slashdot Query Tom Lane
12:10 Re: [SQL] Slashdot Query Chris Bitmead
12:24 RE: [SQL] RV: A little problem updating data with views Michael J Davis
13:21 Re: [SQL] Howto convert floats to text? Martin Leja
19:31 Re: [SQL] RV: A little problem updating data with views wieck@debis.com (Jan Wieck)

5 June 1999

13:57 internal tables stevew
23:43 Stats on Postgres Zot O'Connor

6 June 1999

06:59 Re: [SQL] Slashdot Query Chris Bitmead
08:05 Re: [SQL] OUTER JOINs in PostgreSQL Herouth Maoz
08:25 Re: [SQL] Howto convert floats to text? Herouth Maoz
08:30 Re: [SQL] Getting primary key from insert statement Herouth Maoz
11:16 Re: [SQL] Slashdot Query Tom Lane
15:31 function returning arrays? stevew
22:30 Mail about duplicate rows Vikrant Rathore

7 June 1999

01:16 Re: [SQL] Mail about duplicate rows Fomichev Michael
01:34 Re: [SQL] Mail about duplicate rows Vikrant Rathore
02:48 Re: [SQL] Getting primary key from insert statement Emils Klotins
03:28 Re: [SQL] Getting primary key from insert statement Herouth Maoz
16:09 RE: [SQL] Getting primary key from insert statement Michael J Davis
17:29 RE: [SQL] Slashdot Query Jackson, DeJuan
17:38 RE: [SQL] Mail about duplicate rows Jackson, DeJuan
18:35 RE: [SQL] Getting primary key from insert statement Jackson, DeJuan
19:13 RE: [SQL] Getting primary key from insert statement Michael J Davis
19:30 RE: [SQL] Getting primary key from insert statement Jackson, DeJuan
19:36 RE: [SQL] Getting primary key from insert statement Michael J Davis
22:40 Re: [SQL] Mail about duplicate rows Vikrant Rathore

8 June 1999

03:13 Re: [SQL] Slashdot Query Chris Bitmead
04:25 RE: [SQL] Getting primary key from insert statement Herouth Maoz
09:18 Re: [SQL] Standard SQL commands - are they in 6.5? José Soares
12:06 RE: [SQL] Mail about duplicate rows Jackson, DeJuan
12:22 RE: [SQL] Getting primary key from insert statement Michael J Davis
12:39 RE: [SQL] Getting primary key from insert statement Herouth Maoz
13:27 RE: [SQL] Getting primary key from insert statement Michael J Davis
13:30 Updating non atomic values Bob Kruger
15:57 ... Hub.Org News Admin

9 June 1999

04:26 SQL Problem: ERROR: ExecEvalExpr: unknown expression type 108 Michael Klemme
04:43 Select like when searching for whole word and optimizing it Michal Samek
08:09 automatic incrementation Nuchanard Chiannilkulchai
09:10 Cursors and waiting users Szcząchor Tomasz
09:17 Re: [SQL] automatic incrementation José Soares
09:49 Re: [SQL] Cursors and waiting users Herouth Maoz
10:13 ... Ingrith Andrea Correa Vargas
10:44 Re: [SQL] Select like when searching for whole word and optimizing it Tom Lane
11:44 fields with float[48] type question Sergey S. Rakitin
11:45 Re: [SQL] automatic incrementation Nikolay Mijaylov

10 June 1999

04:37 Re: [SQL] Select like when searching for whole word and optimizing it -- regexp? Emils Klotins
04:58 Re: [SQL] fields with float[48] type question Stuart Rison
05:57 DataStyle Remigiusz Sokolowski
07:11 Re: [SQL] DataStyle Emils Klotins
08:23 Re: [SQL] fields with float[48] type question Sergey S. Rakitin
09:22 Re: [SQL] DataStyle José Soares
16:36 unmatched Brett W. McCoy
17:32 Re: [SQL] unmatched Ross J. Reedstrom
18:39 Re: [SQL] OUTER JOINs in PostgreSQL Ant9000
19:15 Re: [SQL] SQL Problem: ERROR: ExecEvalExpr: unknown expression type 108 Tom Lane
20:02 Re: [SQL] unmatched Chris Bitmead
23:18 ... Hub.Org News Admin

11 June 1999

00:05 Apache authentication & PostgreSQL Fomichev Michael
02:14 Re: [SQL] Apache authentication & PostgreSQL Remigiusz Sokolowski
03:32 RE: [SQL] Apache authentication & PostgreSQL Volker Hess
05:55 Re: [ADMIN] Apache authentication & PostgreSQL Giuseppe Tanzilli
06:00 Re: [ADMIN] Apache authentication & PostgreSQL wieck@debis.com (Jan Wieck)
11:56 nodeREAD error ZioBudda
12:32 RE: [SQL] nodeREAD error ZioBudda
12:39 Re: [SQL] unmatched José Soares
14:18 Searching Text Fields Henrik Steffen
14:33 Mail for error in tuples Vikrant Rathore
15:08 RE: [SQL] Mail for error in tuples Jackson, DeJuan
15:30 Re: [SQL] Mail for error in tuples Vikrant Rathore
18:07 RE: [SQL] Mail for error in tuples Jackson, DeJuan
21:31 Re: [SQL] Searching Text Fields Bruce Momjian

12 June 1999

04:12 Full-Text-Indexing Alexander Schneider
13:01 Re: [SQL] Full-Text-Indexing Tom Lane
16:17 Re: [SQL] Select like when searching for whole word and optimizing it Oleg Bartunov
18:36 Re: [SQL] Updating non atomic values Tom Lane

13 June 1999

13:25 DISTINCT not working Brett W. McCoy
13:51 Re: [SQL] DISTINCT not working Brett W. McCoy
18:20 backing up a db, jdbc, SQL syntax, etc... Georg Ritter

14 June 1999

03:06 [SQL] DISTINCT not working Brett W. McCoy
11:21 Mail about typecast Vikrant Rathore
15:03 RE: [GENERAL] Two variable passed to PL/Function and on is NULL Michael J Davis
16:50 Re: [SQL] OUTER JOINs in PostgreSQL Fomichev Michael
17:37 Re: [SQL] RE: [GENERAL] Two variable passed to PL/Function and on is NULL Tom Lane
23:52 Re: [ADMIN] Apache authentication & PostgreSQL Fomichev Michael
23:53 Mail about typecast Vikrant Rathore

15 June 1999

01:24 example of trigger to track DB changes Michael Olivier
07:04 FullTextIndex Problems on Update Alexander Schneider
08:10 Re: [SQL] Full-Text-Indexing Maarten Boekhold
08:21 FullTextIndex Problems on Update Alexander Schneider
08:35 help with function security Steve Waterworth
08:44 Re: [SQL] Mail about typecast José Soares
09:41 Re: [SQL] Mail about typecast Tom Lane
09:51 Re: [SQL] Mail about typecast Herouth Maoz
10:10 Re: [SQL] Mail about typecast Tom Lane
10:33 subscribe pgsql-sql Arendt, Volker
12:52 optimizer woes ? Howie
13:06 Function security? stevew
13:33 Re: [SQL] optimizer woes ? Bruce Momjian
13:35 RE: [SQL] Function security? Jackson, DeJuan
14:00 ... Collin F. Lynch
14:07 Maybe a bug with SQL processor Charles
15:12 Re: [SQL] example of trigger to track DB changes Brook Milligan
15:20 pg_dump Dipankar Chakrabarti
15:26 Re: [SQL] pg_dump Bruce Momjian
15:51 replication Fabio Silvestri
15:57 Re: [SQL] optimizer woes ? Tom Lane
16:10 Re: [SQL] optimizer woes ? Bruce Momjian
19:16 Re: [SQL] Maybe a bug with SQL processor Tom Lane
19:19 subscribe pgsql-sql news.postgres.sql@charmed.demon.co.uk
22:59 DISTINCT count(*), possible? Matthew Hagerty

16 June 1999

00:03 Re: [SQL] DISTINCT count(*), possible? Chris Bitmead
00:16 Postgres mailing lists Chris Bitmead
00:43 Re: [HACKERS] Postgres mailing lists Don Baccus
00:46 Re: [HACKERS] Postgres mailing lists The Hermit Hacker
02:11 Re: [HACKERS] Postgres mailing lists Chris Bitmead
04:58 Re: [SQL] DISTINCT count(*), possible? Stuart Rison
05:32 converting from number to text Remigiusz Sokolowski
06:15 Re: [HACKERS] Postgres mailing lists Bruce Momjian
06:15 Re: [HACKERS] Postgres mailing lists Bruce Momjian
06:31 Re: [SQL] DISTINCT count(*), possible? Herouth Maoz
06:48 Re: [HACKERS] Postgres mailing lists Vince Vielhaber
06:56 Re: [SQL] example of trigger to track DB changes wieck@debis.com (Jan Wieck)
07:11 database select support Michal Klacan
07:23 Re: [SQL] converting from number to text Herouth Maoz
07:38 Re: [SQL] converting from number to text tolik@icomm.ru (Anatoly K. Lasareff)
07:52 Re: [SQL] converting from number to text Remigiusz Sokolowski
07:57 Re: [SQL] Function security? wieck@debis.com (Jan Wieck)
08:01 Re: [HACKERS] Postgres mailing lists D'Arcy" "J.M." Cain
09:18 Re: [HACKERS] Postgres mailing lists The Hermit Hacker
10:25 Re: [SQL] DISTINCT count(*), possible? Tom Lane
10:36 date Roland_DUBOULOZ
11:01 Query Question Bob Kruger
11:13 Re: [SQL] Query Question Tom Lane
11:18 Re: [SQL] Query Question Herouth Maoz
11:54 ExecAgg: Bad Agg->Target for Agg 0 Malcolm Beattie
11:57 Re: [SQL] date José Soares
13:06 Updating Bob Kruger
13:26 help needed Ravneet Mann
14:35 Update with two tables?? Mark
15:45 Little Help is needed. Hector M Banda
16:07 Re: [SQL] DISTINCT count(*), possible? Rudy Gireyev
16:36 RE: [SQL] Little Help is needed. Jackson, DeJuan
17:14 Re: [SQL] Update with two tables?? Fomichev Michael
17:14 Re: [SQL] Updating Fomichev Michael
19:26 Re: [HACKERS] Postgres mailing lists Henry B. Hotz
20:42 [SQL] Optimizing query inside a function Oh Hyun-Su

17 June 1999

08:23 Re: [HACKERS] Postgres mailing lists The Hermit Hacker
20:30 Join operations Tim Holloway
21:11 ... Hub.Org News Admin

18 June 1999

08:39 Trouble with insert into. Darren Greer
10:20 RE: [SQL] Trouble with insert into. Mathew White
11:17 RE: [SQL] Join operations Jackson, DeJuan
17:50 trigger to insert on update to non-existing row? Doug Younger
18:03 Re: [SQL] Re: [ADMIN] Apache authentication & PostgreSQL Christophe Labouisse
19:14 Where in the world is pgsql-sql@postgresql.org?? adrian@ezymail.com

20 June 1999

07:39 Re: [SQL] DISTINCT count(*), possible? Herouth Maoz
11:52 Re: [SQL] DISTINCT count(*), possible? Thomas Good
14:54 Letting a function work on NULL Anton de Wet

21 June 1999

06:56 Re: [SQL] Letting a function work on NULL Herouth Maoz
08:53 Re: [SQL] Letting a function work on NULL José Soares
12:27 problems working with refint functions Donald Jackson
16:15 Re: [BUGS] General Bug Report: CREATE TABLE AS doesn't work Fomichev Michael
17:52 Trouble with massive select statement. Darren Greer
19:30 Re: [SQL] Trouble with massive select statement. Tom Lane
20:12 ODBC SQL question Hostmaster - Internet au Virtuel Inc.

22 June 1999

01:21 Create table doesn't always respect atomicity of transactions. Zalman Stern
03:48 Re: [SQL] ODBC SQL question José Soares
09:05 Re: [SQL] Trouble with massive select statement. Darren Greer
09:14 Sharing a user defined type Luiz Renuncio
09:31 create new table Tamas Kohegyi
09:32 create new table tkohegyi@gw.cdk.bme.hu
10:15 Sharing a user defined type Luiz Renuncio
10:48 Re: [SQL] Create table doesn't always respect atomicity of transactions. Bruce Momjian
11:26 Re: [SQL] Trouble with massive select statement. Tom Lane
11:29 RE: [SQL] ODBC SQL question Michael J Davis
11:46 Re: [SQL] Trouble with massive select statement. Herouth Maoz
13:52 Sharing a user defined type Luiz Renuncio
14:23 Max () of an empty table... I need it to return 0 any ideas? Deva Vejay

23 June 1999

00:19 Are int4/int8 ops defined? Min Qiu
00:40 insert on insert/update Haris Susanto
10:26 Re: [SQL] Are int4/int8 ops defined? Min Qiu
10:36 Re: [SQL] Are int4/int8 ops defined? José Soares
10:38 oidrand question Darren Greer
12:35 Re:Create table doesn't always respect atomicity of transactions Mark Dalphin
15:07 Date time insertion Bob Kruger
21:15 Re: [SQL] Re:Create table doesn't always respect atomicity of transactions Zalman Stern

24 June 1999

02:53 trouble creating log table with rules Jim Rowan
03:10 Best way to support many many users? Patrick Giagnocavo
06:25 problem with PL/pgSQL Tiberiu Craciun
07:53 Re: [SQL] problem with PL/pgSQL Eric BASIER
08:07 Error on Update: ExecCheckPerms-bogus RT relid? Alexander Schneider
08:12 Error on Update: ExecCheckPerms-bogus RT relid? Alexander Schneider
09:08 Re: [SQL] Re:Create table doesn't always respect atomicity of transactions José Soares
09:08 Re: [SQL] problem with PL/pgSQL José Soares
09:14 Re:Re: [SQL] problem with PL/pgSQL Tiberiu Craciun
09:31 Re: [SQL] Error on Update: ExecCheckPerms-bogus RT relid? Alexander Schneider
09:39 [SQL] PHP + PG Heiko Wilms
19:32 Is SELECT FROM multiple databases possible??? (USE db?) J Kinsley
19:40 Is SELECT FROM multiple databases possible??? (USE db?) J Kinsley

25 June 1999

02:52 Re: trouble creating log table with rules Wayne Piekarski
03:25 Re: [SQL] PHP + PG Rudy Gireyev
08:09 Re: [HACKERS] Re: trouble creating log table with rules wieck@debis.com (Jan Wieck)
16:48 Re: [HACKERS] Re: trouble creating log table with rules Jim Rowan
17:02 possible parser error Kyle Bateman

26 June 1999

00:28 trigger to insert on update to non-existing row? Doug Younger
14:03 JavaBlend and postgresql Daniel Wieselberg

27 June 1999

10:49 ... Hub.Org News Admin
13:29 ... Hub.Org News Admin

28 June 1999

03:04 using UPDATE Christian Rudow
04:39 Using Update Christian Rudow
05:12 Re: [SQL] Using Update Herouth Maoz
10:37 Re: [SQL] Using Update Ross J. Reedstrom
12:09 Temporary tables Tiberiu Craciun
15:04 Re: [SQL] Temporary tables Bruce Momjian
15:43 float4 JT Kirkpatrick
16:31 Re: [ADMIN] float4 Don Garrett
19:33 Re: [SQL] float4 Tom Lane

29 June 1999

16:00 User defined functions through ODBC Hostmaster - Internet au Virtuel Inc.
19:26 Escaping w/i regular expressions Peter Eisentraut

30 June 1999

00:11 begin/end/abort work for sequences? Kyle
03:27 RE: pgsql-sql-digest V1 #276 Ansley, Michael
04:37 Beginner's headache of joins webmaster
04:53 Oracle greatest() and nvl() equivalent? Petter Reinholdtsen
08:17 Re: [SQL] begin/end/abort work for sequences? José Soares
08:29 More fun with random selects Darren Greer
08:51 [SQL] Port? Dirk Drechsel
08:55 Re: [SQL] Port? Dirk Drechsel
09:25 String concat operator??? webmaster
09:52 Re: [SQL] Port? Jeff MacDonald
10:04 Re: [SQL] String concat operator??? Herouth Maoz
10:19 Re: [SQL] String concat operator??? Tom Lane
10:29 Re: [SQL] More fun with random selects Tom Lane
10:31 Re: [PORTS] Port Bug Report: parse error not detected onunterminated quote Kyle Bateman
10:45 Re: [SQL] Beginner's headache of joins Tom Lane
13:06 User defined functions through ODBC Hostmaster - Internet au Virtuel Inc.
14:07 Escaping w/i regular expressions Peter Eisentraut
22:13 Re: [SQL] Beginner's headache of joins Chris Bitmead
23:28 Re: [SQL] begin/end/abort work for sequences? Bruce Momjian
23:43 Re: [SQL] String concat operator??? Bruce Momjian