Home > mailing lists

Mailing lists [pgsql-sql]

1 June 1999

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

2 June 1999

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

3 June 1999

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

4 June 1999

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

5 June 1999

16:57 internal tables stevew

6 June 1999

02:43 Stats on Postgres Zot O'Connor
09:59 Re: [SQL] Slashdot Query Chris Bitmead
11:05 Re: [SQL] OUTER JOINs in PostgreSQL Herouth Maoz
11:25 Re: [SQL] Howto convert floats to text? Herouth Maoz
11:30 Re: [SQL] Getting primary key from insert statement Herouth Maoz
14:16 Re: [SQL] Slashdot Query Tom Lane
18:31 function returning arrays? stevew

7 June 1999

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

8 June 1999

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

9 June 1999

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

10 June 1999

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

11 June 1999

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

12 June 1999

00:31 Re: [SQL] Searching Text Fields Bruce Momjian
07:12 Full-Text-Indexing Alexander Schneider
16:01 Re: [SQL] Full-Text-Indexing Tom Lane
19:17 Re: [SQL] Select like when searching for whole word and optimizing it Oleg Bartunov
21:36 Re: [SQL] Updating non atomic values Tom Lane

13 June 1999

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

14 June 1999

06:06 [SQL] DISTINCT not working Brett W. McCoy
14:21 Mail about typecast Vikrant Rathore
18:03 RE: [GENERAL] Two variable passed to PL/Function and on is NULL Michael J Davis
19:50 Re: [SQL] OUTER JOINs in PostgreSQL Fomichev Michael
20:37 Re: [SQL] RE: [GENERAL] Two variable passed to PL/Function and on is NULL Tom Lane

15 June 1999

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

16 June 1999

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

17 June 1999

11:23 Re: [HACKERS] Postgres mailing lists The Hermit Hacker
23:30 Join operations Tim Holloway

18 June 1999

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

20 June 1999

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

21 June 1999

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

22 June 1999

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

23 June 1999

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

24 June 1999

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

25 June 1999

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

26 June 1999

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

27 June 1999

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

28 June 1999

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

29 June 1999

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

30 June 1999

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