pgsql-sql - May 2000

Discussion for users on SQL related matters.

Search the Archives

(enter a message-id to go directly to that message)

Advanced Search

Browse Archives

Prev | Next

May 15, 2000

Thread	Author	Time
sanity check fails	Johann Spies	12:55
translation from ORACLE	Richard NAGY	17:09

May 16, 2000

Thread	Author	Time
is multiple insert possible with posgress?	sidster	03:39
Re: is multiple insert possible with posgress?	Tom Lane	03:58
Re: sanity check fails	Tom Lane	04:49
Re: is multiple insert possible with posgress?	Erol Oz	06:57
Re: pattern matching operator	omid omoomi	08:28
Re: sanity check fails	Johann Spies	08:51
Using substr with user defined types	D'Arcy J.M. Cain	11:37
pattern matching operator	Wallingford, Ted	13:45
Question about databases in alternate locations...	Richard J Kuhns	15:25
Index not used in functions in 7.0? 📎	Kyle Bateman	15:26
Re: Question about databases in alternate locations...	Jeff Hoffmann	15:47
Re: Index not used in functions in 7.0?	Tom Lane	15:50
Re: pattern matching operator	mig	15:54
Re: pattern matching operator	Joseph Shraibman	16:23
Re: Index not used in functions in 7.0?	Tom Lane	16:36
doc links broken	Clayton Cottingham aka DrFrog	17:18
Re: What is the difference between NULL and "undef"	Michael A. Mayo	17:18
Re: Index not used in functions in 7.0?	mig	18:00
Re: Index not used in functions in 7.0? 📎	Kyle Bateman	18:13
Re: Index not used in functions in 7.0?	Tom Lane	19:11

May 17, 2000

Thread	Author	Time
question on update/delete rules on views 📎	Kyle Bateman	00:17
Re: Question about databases in alternate locations...	Thomas Lockhart	05:38
AW: What is the difference between NULL and "undef"	Rudolph, Michael	06:11
lower() for varchar data by creating an index	Alex Guryanow	07:51
Storing binary data in a column	Yamini Sharma	12:43
Re: Question about databases in alternate locations...	Richard J Kuhns	13:50
Re: question on update/delete rules on views	Brook Milligan	13:52
Re: lower() for varchar data by creating an index	Mitch Vincent	14:31
Re: question on update/delete rules on views 📎	Kyle Bateman	15:15
Re: Storing binary data in a column	Tom Lane	15:22
Re: Question about databases in alternate locations...	Thomas Lockhart	15:27
Re: Question about databases in alternate locations...	Tom Lane	16:35
pg_dump return failed sanity check	Patrick Robin	17:13
Re: Index not used in functions in 7.0?	Peter Eisentraut	17:18
line type	mikeo	17:41
Re: question on update/delete rules on views	Brook Milligan	17:51
remove line type?	mikeo	18:43
Re: remove line type?	Bruce Momjian	18:51
Re: remove line type?	Bruce Momjian	19:04
Re: remove line type?	mikeo	19:09
Re: question on update/delete rules on views	Richard Huxton	19:45
Re: question on update/delete rules on views 📎	Kyle Bateman	20:47
Re: question on update/delete rules on views	Brook Milligan	21:01
Re: question on update/delete rules on views	Tom Lane	21:47

May 18, 2000

Thread	Author	Time
Automatic index numbers	Daniel Mendyke	00:52
Re: Using substr with user defined types	Tom Lane	02:52
Re: pg_dump return failed sanity check	Tom Lane	03:18
Antw: Automatic index numbers	Gerhard Dieringer	06:52
Translaye from Oracle	christine	09:21
strange ORDER BY implementation	Alex Guryanow	09:26
translate from oracle	christine	09:35
Re: Using substr with user defined types	D'Arcy J.M. Cain	10:54
Foreign keys and access privileges	mkresse	10:57
Re[2]: lower() for varchar data by creating an index	Alex Guryanow	11:34
Re: translate from oracle	Tom Lane	14:44
Re: Using substr with user defined types	Tom Lane	14:52
Re: Foreign keys and access privileges	Tom Lane	14:54
Re: Re[2]: lower() for varchar data by creating an index	Tom Lane	15:00
Re: Using substr with user defined types	Bruce Momjian	15:20
Re: Re[2]: lower() for varchar data by creating an index	Bruce Momjian	15:28
Re: Re[2]: lower() for varchar data by creating an index	Tom Lane	15:41
Re: Re[2]: lower() for varchar data by creating an index	Bruce Momjian	15:44
LIKE and regex	Mitch Vincent	15:49
indecies are not used by '<=' operator on varchar fields	Alex Guryanow	16:22
Re: LIKE and regex	Tom Lane	16:35
Pre-toast toast to toast 📎	Kyle Bateman	16:53
Re: LIKE and regex	Mitch Vincent	17:25
Novice Help Needed	Brian C. Doyle	18:01
Re: What is the difference between NULL and "undef"	Michael A. Mayo	18:32
SQL command speed	Kate Collins	19:11
Re: Novice Help Needed	Robert B. Easter	19:27
Re: SQL command speed	mig	19:38
Re: SQL command speed	Kate Collins	20:19
Re: SQL command speed	mig	20:27
Re: SQL command speed	Ross J. Reedstrom	20:39
Re: SQL command speed	Kate Collins	20:46
Re: What is the difference between NULL and "undef"	Michael A. Mayo	21:09
Re: Re[2]: lower() for varchar data by creating an index	Christopher Sawtell	21:18
Re: SQL command speed	Tom Lane	21:47
Re: SQL command speed	Stephan Szabo	22:02
Library sort order (was Re: SQL command speed)	Ross J. Reedstrom	22:03
Re: Foreign keys and access privileges	mkresse	22:19
Re: Foreign keys breaks tables permissions	Tom Lane	23:17
Re: Question about databases in alternate locations...	Peter Eisentraut	23:50

May 19, 2000

Thread	Author	Time
Re: [SQL] Foreign keys breaks tables permissions	Stephan Szabo	02:58
Re: [SQL] Foreign keys breaks tables permissions	Tom Lane	03:38
AW: What is the difference between NULL and "undef"	Rudolph, Michael	08:34
Re: Re: [SQL] Foreign keys breaks tables permissions	Hiroshi Inoue	11:28
Re: SQL command speed	Kate Collins	13:20
Re: Question about databases in alternate locations...	Thomas Lockhart	13:43
Re: Re: [SQL] Foreign keys breaks tables permissions	Hannu Krosing	14:05
Creating Tables in Functions	Scott Wood	14:28
bogus number 📎	Kyle Bateman	14:57
Re: Re: [SQL] Foreign keys breaks tables permissions	Hannu Krosing	15:15
Re: bogus number	Tom Lane	15:36
Re: SQL command speed	Tom Lane	16:06
[HACKERS] Re: Question about databases in alternate locations...	Richard J. Kuhns	16:25
Re: Foreign keys breaks tables permissions	Peter Eisentraut	17:39
Re: Re[2]: lower() for varchar data by creating an index	Peter Eisentraut	17:39
Re: Foreign keys breaks tables permissions	Tom Lane	17:44
Re: Re[2]: lower() for varchar data by creating an index	Tom Lane	17:48
Re: SQL command speed	Kate Collins	19:34
Re: Creating Tables in Functions	Tom Lane	19:48
Re: SQL command speed	Tom Lane	21:39

May 20, 2000

Thread	Author	Time
Re: Question about databases in alternate locations...	Peter Eisentraut	13:35
Adding many rows to a table.	Stuart Grimshaw	21:53

May 21, 2000

Thread	Author	Time
Re: Adding many rows to a table.	Tom Lane	04:54
Re: Foreign keys breaks tables permissions	Peter Eisentraut	16:45
Full text indexing (and errors!)	Mitch Vincent	16:59
Re: Foreign keys breaks tables permissions	Tom Lane	17:12
Re: Full text indexing (and errors!)	Tom Lane	17:58
Re: Full text indexing (and errors!)	Mitch Vincent	18:17
Re: Full text indexing (and errors!)	Tom Lane	18:28
Re: Full text indexing (and errors!)	Mitch Vincent	19:15
Re: Full text indexing (and errors!)	Tom Lane	19:44

May 22, 2000

Thread	Author	Time
duplicate key	Patrick Coulombe	04:50
re: duplicate key	Patrick Coulombe	06:53
Re: re: duplicate key	Oliver Elphick	20:57

May 23, 2000

Thread	Author	Time
Re: OID	Erol Oz	08:10
OID	christine	08:12
Re: pg_hba.conf Help	Poul L. Christiansen	15:34
pg_hba.conf Help	Brian C. Doyle	15:51
Re: pg_hba.conf Help	Nikolay Mijaylov	16:26
Re: pg_hba.conf Help	Brian C. Doyle	16:48
Functions and Variables.	Steffers	21:16
two fields in subselect	Joseph Shraibman	22:53
Re: two fields in subselect	Tom Lane	23:32
Re: two fields in subselect	Joseph Shraibman	23:46

May 24, 2000

Thread	Author	Time
Clarified Question	Stef telford	01:36
Decimal ??	Tubagus Nizomi	02:55
Re: Decimal ??	Jason Earl	04:43
Re: Decimal ??	Tom Lane	04:44
Unable to identify a right operator '>=' for type 'bpchar'	Michael Ma	15:21
[No subject]	gomathi raju	15:37
Re: Unable to identify a right operator '>=' for type 'bpchar'	Tom Lane	16:33
Why is PostgreSQL 7.0 SQL semantics different from Oracle's?	Thomas Holmgren	17:08
Re: Unable to identify a right operator '>=' for type 'bpchar' (solved)	Michael Ma	17:21
Why is PostgreSQL 7.0 SQL semantics different from Oracle's?	Thomas Holmgren	17:58
Re: Automatic index numbers	Kees Kuip	19:38
Re: Why is PostgreSQL 7.0 SQL semantics different from Oracle's?	Jan Wieck	21:04
possible bug with group by?	Joseph Shraibman	22:30
Re: [HACKERS]	Patrick Welche	22:40
Clarified Question 📎	Kyle Bateman	22:44
Re: possible bug with group by?	Ross J. Reedstrom	23:03
Re: possible bug with group by?	Julie Hunt	23:05
Use of index in 7.0 vs 6.5	Ryan Bradetich	23:05
Re: possible bug with group by?	Tom Lane	23:07
Re: possible bug with group by?	Stephan Szabo	23:16
Re: possible bug with group by?	Joseph Shraibman	23:18
Re: possible bug with group by?	Joseph Shraibman	23:21

May 25, 2000

Thread	Author	Time
Re: [HACKERS]	Chris Bitmead	00:02
Re: possible bug with group by?	Tom Lane	02:59
Re: Use of index in 7.0 vs 6.5	Tom Lane	03:12
Re: Use of index in 7.0 vs 6.5	Ryan Bradetich	03:57
Re: [SQL]	Michael A. Mayo	04:54
Re: Use of index in 7.0 vs 6.5	Tom Lane	06:14
RE: Use of index in 7.0 vs 6.5	Hiroshi Inoue	07:19
RE: Use of index in 7.0 vs 6.5	Mikheev, Vadim	14:29
Re: Use of index in 7.0 vs 6.5	Tom Lane	14:39
Re: Use of index in 7.0 vs 6.5	Bruce Momjian	15:11
Re: Use of index in 7.0 vs 6.5	Jeff Hoffmann	15:30
Re: Use of index in 7.0 vs 6.5	Tom Lane	16:03
Re: Use of index in 7.0 vs 6.5	Tom Lane	16:08
Re: Use of index in 7.0 vs 6.5	Bruce Momjian	16:08
RE: Use of index in 7.0 vs 6.5	Mikheev, Vadim	16:12
RE: Use of index in 7.0 vs 6.5	Mikheev, Vadim	17:17
Re: Use of index in 7.0 vs 6.5	Ryan Bradetich	23:40

May 26, 2000

Thread	Author	Time
RE: Use of index in 7.0 vs 6.5	Hiroshi Inoue	00:02
Re: Use of index in 7.0 vs 6.5	Tom Lane	00:03
aliases break my query	Joseph Shraibman	03:11
Re: aliases break my query	Tom Lane	04:35
PG/DBI: 'NOTICE: UserAbortTransactionBlock and not in in-progress state'	Markus Wagner	06:21
Antw: aliases break my query	Gerhard Dieringer	06:54
A Question	Sherril Mathew	10:53
Re: A Question	Peter Eisentraut	12:48
Re: aliases break my query	Peter Eisentraut	13:02
Re: PG/DBI: 'NOTICE: UserAbortTransactionBlock and not in in-progress state'	Ed Loehr	13:42
date() indexing error..	Mitch Vincent	14:31
Re: date() indexing error..	Tom Lane	15:52
POSTGRESQL and PERL?	Peter Landis	15:58
RE: POSTGRESQL and PERL? 📎	Wallingford, Ted	16:14
Re: PG/DBI: 'NOTICE: UserAbortTransactionBlock and not in in-progress state'	Tom Lane	16:19
Re: aliases break my query	Tom Lane	16:26
Re: POSTGRESQL and PERL?	Ed Loehr	16:35
Re: POSTGRESQL and PERL?	Richard Huxton	17:41
Re: aliases break my query	Joseph Shraibman	17:47
Re: aliases break my query	Joseph Shraibman	18:13
Re: Re: [SQL] aliases break my query	Zeugswetter Andreas	19:47
New Type	Olivier PRENANT	20:03
is limit a reserved keyword?	Gabriel Russell	21:24
Re: Re: [SQL] aliases break my query	Tom Lane	21:34
Re: Re: [SQL] aliases break my query	Peter Eisentraut	22:30
Re: Re: [SQL] aliases break my query	Tom Lane	22:42
Re: [SQL] is limit a reserved keyword?	Tom Lane	22:48
Re: Re: [SQL] aliases break my query	Bruce Momjian	23:43

May 27, 2000

Thread	Author	Time
Re: Re: [SQL] aliases break my query	Mike Mascari	01:45
Re: Re: [SQL] aliases break my query	Tom Lane	04:06
Re: New Type	selkovjr	07:22

Browse Archives

Prev | Next