Discussion for users on SQL related matters.
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| Thread | Author | Time |
|---|---|---|
| unsuscribe | Dionisio Barrantes | 16:16 |
| Question about arrays | David Ouellet | 18:18 |
| RE: [SQL] Question about arrays | Jackson, DeJuan | 20:25 |
| 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 |