pgsql-sql since 1999-07-23 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 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
Query for duplicates. Matthew Hagerty 16:46
Re: [SQL] primary key view failure Ross J. Reedstrom 17:57
Re: [SQL] Query for duplicates. John M. Flinchbaugh 20:19
Re: [SQL] Query for duplicates. Matthew Hagerty 20:45
subscribe Richard Dice 21:28

Aug. 6, 1999

Thread Author Time
Re: [SQL] qurey plan and indices Vadim Mikheev 02:09
Re: [SQL] qurey plan and indices Bruce Momjian 02:33
Function, trigger problem with PL/pgSQL John Duperon 18:22

Aug. 7, 1999

Thread Author Time
[No subject] jpjansen 10:23
table aliasing problem with 6.5... Howie 13:06
Re: [SQL] table aliasing problem with 6.5... Tom Lane 14:04
Re: [SQL] table aliasing problem with 6.5... Bruce Momjian 15:15
[No subject] Hub.Org News Admin 19:48

Aug. 9, 1999

Thread Author Time
unsuscribe Dionisio Barrantes 16:16
Question about arrays David Ouellet 18:18
RE: [SQL] Question about arrays Jackson, DeJuan 20:25

Aug. 10, 1999

Thread Author Time
Postres falls down on "having" Paul Mamin 05:35
rpm 6.5 requires libcurses.so.4? Giovanni B. Stefanoni 14:21
Re: [SQL] Postres falls down on "having" Tom Lane 14:55
Re: [SQL] Question about arrays David Ouellet 15:16
PROPOSAL: Statement for one-sided joins Evan Simpson 17:19
quest:optimization with indexes Clayton Cottingham 22:42
quest:text search optimizing ala glimpse Clayton Cottingham 22:45

Aug. 11, 1999

Thread Author Time
Re: [SQL] quest:optimization with indexes Herouth Maoz 13:30
Re: [SQL] quest:optimization with indexes Ross J. Reedstrom 14:12
Re: [SQL] quest:optimization with indexes Clayton Cottingham 17:43
Re: [SQL] quest:optimization with indexes Tom Lane 22:35
Re: [SQL] quest:optimization with indexes Clayton Cottingham 23:38

Aug. 12, 1999

Thread Author Time
UNIQUE constraint Mihai Barbos 05:43
simultaneous access? 📎 KOUL Christian 06:45
shared tables? 📎 KOUL Christian 07:07
Problem with postgreSQL triggers Sbastien BOUTELOUP 11:39
converting text to float? Bart Ogryczak 12:32
What return type for an insertion function? Sbastien BOUTELOUP 13:05
Re: [SQL] UNIQUE constraint Tom Lane 13:23
Table size limit? Mike Field 13:58
Re: [SQL] Table size limit? Tom Lane 14:12
Re: [SQL] quest:optimization with indexes Tom Lane 14:34
Searching Text Fields - Case Sensitive? Mike Field 14:59
Re: [SQL] Problem with postgreSQL triggers Emils Klotins 15:20
Re: [SQL] Searching Text Fields - Case Sensitive? Bart Ogryczak 15:24
Select Maximum Question Frank Morton 15:51
Intentionally inserting duplicates without aborting disser 15:59
Re: [SQL] Select Maximum Question Tom Lane 23:01

Aug. 13, 1999

Thread Author Time
Re: [SQL] Searching Text Fields - Case Sensitive? Moray McConnachie 07:48
Re: [SQL] Searching Text Fields - Case Sensitive? Bart Ogryczak 09:07
Problems with default date and time Hutton, Rob 13:44
Re: [SQL] Problems with default date and time Patrik Kudo 14:04
RE: [SQL] Problems with default date and time Hutton, Rob 14:25
Re: [SQL] Searching Text Fields - Case Sensitive? Tom Lane 14:27
RE: [SQL] Problems with default date and time Hutton, Rob 14:36
Re: [SQL] Problems with default date and time Patrik Kudo 14:57
Re: [SQL] Problems with default date and time Tom Lane 15:02
Multiple values for a field Mike Field 15:11
RE: [SQL] Problems with default date and time Hutton, Rob 16:40

Aug. 14, 1999

Thread Author Time
err: select f() from i where (f()) in (select f() from x group by j); Chad Miller 00:13

Browse Archives

Prev | Next