pgsql-sql since 1999-07-16 00:00

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

July 16, 1999

Thread Author Time
query length limits [email protected] 01:17
RE: query length limits Ansley, Michael 07:06
Re: [HACKERS] Counting bool flags in a complex query Michael Richards 08:37
RE: [HACKERS] Counting bool flags in a complex query Ansley, Michael 09:18
RE: [HACKERS] Counting bool flags in a complex query Ansley, Michael 10:01
Stored Procedures and other stuffs Ademir Mazer Jr 13:13
Re: [HACKERS] Counting bool flags in a complex query Tom Lane 14:35
Re: [HACKERS] Counting bool flags in a complex query Michael Richards 21:19
Re: [SQL] Re: [HACKERS] Counting bool flags in a complex query Tom Lane 21:56
user defined function speeds [email protected] 22:24

July 17, 1999

Thread Author Time
Fix up for BTP_CHAIN problems Wayne Piekarski 03:40

July 18, 1999

Thread Author Time
Re: [SQL] Stored Procedures and other stuffs Stephen Boyle 07:37

July 19, 1999

Thread Author Time
Re: [HACKERS] Fix up for BTP_CHAIN problems Vadim Mikheev 01:56
Re: [SQL] SELECT using arrays Herouth Maoz 11:48
Re: [SQL] Re: [HACKERS] Counting bool flags in a complex query Herouth Maoz 12:11
Re: [SQL] Good Optimization secret 14:02
Re: [SQL] Good Optimization secret 14:15
Re: [SQL] Good Optimization Bruce Momjian 14:37
Large text novikov 14:47
Re: [SQL] Re: [HACKERS] Counting bool flags in a complex query Tom Lane 14:48
Re: [SQL] Good Optimization Tom Lane 15:14
RE: pgsql-sql-digest V1 #281 Dionisio Barrantes 17:16

July 20, 1999

Thread Author Time
Re: [SQL] how to determine table? Chris Bitmead 02:41
[No subject] Vikrant Rathore 04:30
bad select performance for where (x=1 or x=3) George Young 14:02
Re: [SQL] bad select performance for where (x=1 or x=3) Tom Lane 14:53
Can I prevent my sequence to increment if an insert is rejected? Frederic De Leersnijder 16:54
Re: [SQL] Can I prevent my sequence to increment if an insert is rejected? [email protected] 19:01
Bad update performance? Gunnar Ingvi Thorisson 23:06

July 21, 1999

Thread Author Time
Tool for generating entity relation diagrams. GrooveRipper 01:36
Re: [SQL] Bad update performance? [email protected] 02:28
RE: Tool for generating entity relation diagrams. Ansley, Michael 07:44
how to add users in group Jonathan davis 08:57
Re: [SQL] Can I prevent my sequence to increment if an insert is rejected? Herouth Maoz 09:15
Re: [SQL] Can I prevent my sequence to increment if an insert isrejected? Chris Bitmead 09:36
Re: [SQL] Can I prevent my sequence to increment if an insert isrejected? Herouth Maoz 09:45
pb with pg_group Jonathan davis 09:46
Re: [SQL] Bad update performance? Herouth Maoz 09:52
inheritance Chris Bitmead 13:21
I dont't receive any messages Karin Probost 13:27
Re: [SQL] Bad update performance? Tom Lane 13:38
Re: [HACKERS] inheritance Tom Lane 14:59
Re: [SQL] bad select performance fixed by forbidding hash joins George Young 15:07
Re: [HACKERS] inheritance Hannu Krosing 16:26
Re: [SQL] bad select performance fixed by forbidding hash joins Tom Lane 17:20
Re: [GENERAL] Re: [SQL] bad select performance fixed by forbidding hash joins Bruce Momjian 17:57
Re: [GENERAL] Re: [SQL] bad select performance fixed by forbidding hash joins Leon 18:40

July 22, 1999

Thread Author Time
how to determine table? Don Yury 04:21
Buffer Size Michael Yeung 08:19
Problem with large objects root 10:17
database design SQL prob. Frederic.De.Leersnijder 12:47
Problem with large binary objects and Delphi Ramn Yago 14:22
Problem with Rules Peter Eisentraut 14:35
Re: [SQL] Problem with Rules Jan Wieck 16:58
(no subject) root 18:49
[No subject] Hub.Org News Admin 21:19

July 23, 1999

Thread Author Time
Delphi, Postgres and Large binary objects Hijos de Ramn Puche S.L. 07:05
copy text file into a table World Data Service 07:05
about stuck spinlock of postgresq-l6.4.2 Yann-Ju Chu 07:18
Re: [SQL] database design SQL prob. Stuart Rison 09:12
Select/Insert operations with arrays Ravi Mukkamala 19:57
Select/insert with C-type arrays Ravi Mukkamala 20:15
lo_read and lo_write Ravi Mukkamala 20:43
ERROR: DefineQueryRewrite: rule plan string too big. John M. Flinchbaugh 20:45
[No subject] Hub.Org News Admin 22:53

July 24, 1999

Thread Author Time
[No subject] Wayne Piekarski 03:34
Postgres 6.5 Is Fantastic! Wayne Piekarski 03:52
inserts/updates problem under stressing ! Oleg Bartunov 09:48
Re: [SQL] database design SQL prob. D'Arcy J.M. Cain 11:49
Expr Abbreviations/Functions? Kenneth Jacker 15:13
Re: [SQL] inserts/updates problem under stressing ! Tom Lane 16:29
Re: [SQL] inserts/updates problem under stressing ! Oleg Bartunov 17:00
Re: [HACKERS] Re: [SQL] inserts/updates problem under stressing ! Oleg Bartunov 17:23
Views Readonly Still? Zot O'Connor 18:53
Coverting mysql keys Zot O'Connor 19:02
Goos SQL refernce Zot O'Connor 19:04
Re: [SQL] Expr Abbreviations/Functions? [email protected] 23:11
Questions about Postgresql and other databases Hector M Banda 23:35
Re: [SQL] Views Readonly Still? Tom Lane 23:38

July 25, 1999

Thread Author Time
Re: [HACKERS] Re: [SQL] inserts/updates problem under stressing ! Philip Warner 00:18
Re: [SQL] database design SQL prob. Herouth Maoz 12:40
Re: [SQL] Expr Abbreviations/Functions? Herouth Maoz 12:47
Re: [SQL] ERROR: DefineQueryRewrite: rule plan string too big. Herouth Maoz 12:54
Re: [SQL] ERROR: DefineQueryRewrite: rule plan string too big. Tom Lane 16:00

July 26, 1999

Thread Author Time
Re: [SQL] inserts/updates problem under stressing ! Vadim Mikheev 02:39
Re: [SQL] inserts/updates problem under stressing ! Vadim Mikheev 02:43
Re: [HACKERS] Re: [SQL] inserts/updates problem understressing ! Vadim Mikheev 02:50
(no subject) Martin Jackson 04:04
Re: [SQL] database design SQL prob. Don Yury 04:16
Re: [SQL] Expr Abbreviations/Functions? [email protected] 04:52
escaping wildcard chars Dan Wilson 05:16
Re: [SQL] inserts/updates problem under stressing ! Oleg Bartunov 06:13
Re: [SQL] inserts/updates problem under stressing ! Vadim Mikheev 06:26
LEFT JOIN and ODBC Molnar Laszlo 06:28
Re: [HACKERS] Re: [SQL] inserts/updates problem understressing ! Oleg Bartunov 06:28
Re: [SQL] inserts/updates problem under stressing ! Oleg Bartunov 06:49
Re: [HACKERS] Re: [SQL] inserts/updates problem under stressing ! Adriaan Joubert 06:57
NOT IN clause performing badly Christian Rudow 09:09
Re: [SQL] ERROR: DefineQueryRewrite: rule plan string too big. Jan Wieck 09:28
Re: [SQL] Expr Abbreviations/Functions? Herouth Maoz 10:27
Re: [SQL] database design SQL prob. D'Arcy J.M. Cain 10:30
Re: [SQL] NOT IN clause performing badly Herouth Maoz 11:12
Re: [SQL] RE: Tool for generating entity relation diagrams. John Reynolds 11:23
Re: [GENERAL] escaping wildcard chars Herouth Maoz 12:39
Re: [SQL] database design SQL prob. Bruce Momjian 13:37
Re: [GENERAL] escaping wildcard chars Dan Wilson 13:48
Re: [GENERAL] escaping wildcard chars Dan Wilson 13:52
Re: [INTERFACES] How can I work thru this key problem? Jeffrey Lyon 17:39
How can I work thru this key problem? marc rassbach 17:50
timespan arithmetic David Rose 23:00
RE: [SQL] timespan arithmetic Jackson, DeJuan 23:16

July 27, 1999

Thread Author Time
RE: [SQL] timespan arithmetic David Rose 05:51
SELECT .. WHERE field IN (SELECT .. ) Predrag Lesic 09:21
outer joins Don Yury 10:24
Re: [INTERFACES] How can I work thru this key problem? Herouth Maoz 14:36
WHERE parent IN (0,-1) Drew Whittle 23:51

July 28, 1999

Thread Author Time
Re: [SQL] WHERE parent IN (0,-1) Bruce Momjian 00:09
Re: [SQL] Outer Joins, Foreign keys, subselects Bruce Momjian 00:10
Outer Joins, Foreign keys, subselects Jens Glaser 01:19
Re: [SQL] ERROR: DefineQueryRewrite: rule plan string too big. John M. Flinchbaugh 09:29
How to limit number of processes Remigiusz Sokolowski 09:47
Re: [SQL] WHERE parent IN (0,-1) Tom Lane 13:47
Re: [SQL] WHERE parent IN (0,-1) Thomas Lockhart 14:47
Re: [SQL] WHERE parent IN (0,-1) Tom Lane 17:47
Join with blank records. Matthew Hagerty 18:05
Re: [SQL] Join with blank records. Peter Eisentraut 20:14
Re: [SQL] Join with blank records. Matthew Hagerty 21:46

July 29, 1999

Thread Author Time
Re: [SQL] COALESCE() bug? Tom Lane 00:13
Re: [SQL] COALESCE() bug? Bruce Momjian 00:28
COALESCE() bug? Jens Glaser 01:29
Form making with psql and php.cgi Inform() 02:35
Re: [SQL] WHERE parent IN (0,-1) Thomas Lockhart 03:27
Re: [SQL] COALESCE() bug? Tom Lane 03:47
Re: Subject: Form making with psql and php.cgi Zot O'Connor 04:31
test, please ignore Remigiusz Sokolowski 06:50
Formatting the output G. Anthony Reina 17:02
Re: [SQL] Formatting the output Bill Brandt 17:34
Re: [SQL] Formatting the output Bruce Momjian 17:41
Re: [SQL] Formatting the output Bruce Momjian 17:43
Re: [SQL] Formatting the output G. Anthony Reina 18:37

July 30, 1999

Thread Author Time
Re: [SQL] Formatting the output Thomas Lockhart 00:30
Re: [SQL] Formatting the output Bruce Momjian 00:42
stuck spinlock in postgresql-6.5.1 Yann-Ju Chu 02:17
Related tables Franco Cazzaro 10:08
Error when inserting Esteban Chiner Sanz 11:36
Re: [SQL] Error when inserting Darrin Crook 13:32
date_arithmetic revisited Thomas Good 14:15
unsuscribe Carlos 14:50
MVCC and concurrent clients Tom Lane 20:10

July 31, 1999

Thread Author Time
Re: [SQL] Outer Joins, Foreign keys, subselects Jens Glaser 13:56
Re: [SQL] Outer Joins, Foreign keys, subselects Tom Lane 15:58
Tr: UNIQUE Stéphane FILLON 22:12
Tr: DUMP database for sample Stéphane FILLON 22:13
Re: [SQL] MVCC and concurrent clients Ross J. Reedstrom 23:05

Aug. 1, 1999

Thread Author Time
DOMAIN DEFINITION Stéphane FILLON 05:31
CHECK CONSTRAINT Stéphane FILLON 07:15
Re: [SQL] MVCC and concurrent clients Tom Lane 14:55
Re: [SQL] date_arithmetic revisited Herouth Maoz 16:57
Some questions about inheritance Martin Jackson 22:19
More on trigger inheritance Martin Jackson 23:25

Aug. 2, 1999

Thread Author Time
Using dates maxsbox 08:01
Re: [SQL] Using dates Herouth Maoz 09:09
Random order Jérome Knöbl 11:34
Re: [SQL] date_arithmetic revisited Thomas Good 12:54
Using Aliases in Select Christian Rudow 13:22
Re: [SQL] Using Aliases in Select Andy Lewis 13:39
Re: [SQL] Using Aliases in Select Tom Lane 14:06
Re: [SQL] Using Aliases in Select Christian Rudow 14:06
unsuscribe Carlos 20:31
Re: [SQL] MVCC and concurrent clients [email protected] 20:44
few questions about rules: timestamp, new.oid Michael Olivier 21:04

Aug. 3, 1999

Thread Author Time
Re: [SQL] Using dates maxsbox 06:16
Re: [SQL] few questions about rules: timestamp, new.oid Herouth Maoz 10:32
Re: bad select performance fixed by forbidding hash joins Tom Lane 15:12

Aug. 4, 1999

Thread Author Time
datetime sample code? Ramanika 01:36
referential integrity Ramanika 01:47
Cache lookup failed with FUNCTION + TRIGGER Stéphane FILLON 03:21
Re: [SQL] datetime sample code? Herouth Maoz 09:22
Re: [SQL] referential integrity Howie 11:08
sequences not reliable? astromonk 18:22
Re: [SQL] Cache lookup failed with FUNCTION + TRIGGER Tom Lane 22:07
Why is this sub-query select so slow? Kevin Sangalee 22:08

Aug. 5, 1999

Thread Author Time
unsuscribe DE VOLDER Fabrice 06:26
qurey plan and indices MESZAROS Attila 12:08
weird view failure Rob Casson 12:47
primary key view failure rob caSSon 13:52
Re: [SQL] qurey plan and indices Patrick Giagnocavo 14:18
Re: [SQL] primary key view failure Tom Lane 14:26
Re: [SQL] qurey plan and indices Tom Lane 14:39
Re: [SQL] qurey plan and indices MESZAROS Attila 14:51
Re: [SQL] qurey plan and indices MESZAROS Attila 14:59
Re: [SQL] primary key view failure rob caSSon 15:24
Re: [SQL] primary key view failure Tom Lane 15:47
Array of integer Olivier Ertz 15:48
Re: [SQL] primary key view failure rob caSSon 15:58
Array size Olivier Ertz 16:02
Re: [SQL] Array of integer Tom Lane 16:06
Re: [SQL] primary key view failure Ross J. Reedstrom 16:09
unsubscribe BOUARD, Fabrice 16:16
Re: [SQL] primary key view failure Tom Lane 16:29

Browse Archives

Prev | Next