Discussion for users on SQL related matters.
| 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 |
| quest:text search optimizing ala glimpse | Clayton Cottingham | 22:45 |
| 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 |
| 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 |
| 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 |
| Thread | Author | Time |
|---|---|---|
| err: select f() from i where (f()) in (select f() from x group by j); | Chad Miller | 00:13 |
| Anyone recognise this error from PL/pgSQL? | Mark Dalphin | 01:05 |
| Re: [SQL] Anyone recognise this error from PL/pgSQL? | Howie | 03:07 |
| new.oid not working inside rule [repost] | Michael Olivier | 04:05 |
| full text index | Clayton Cottingham | 05:28 |
| index on more-than-one columns? | Engard Ferenc | 14:51 |
| functions for... | Clayton Cottingham | 15:17 |
| Thread | Author | Time |
|---|---|---|
| select [for update]?? | Matthew Hagerty | 05:51 |
| Re: [SQL] Intentionally inserting duplicates without aborting | Herouth Maoz | 13:06 |
| Re: [SQL] Multiple values for a field | Herouth Maoz | 13:26 |
| Re: [SQL] err: select f() from i where (f()) in (select f() from x group by j); | Herouth Maoz | 13:40 |
| Agregate Problem? | Len Morgan | 14:01 |
| Re: [SQL] Agregate Problem? | Herouth Maoz | 14:27 |
| Re: [SQL] Multiple values for a field | Ross J. Reedstrom | 15:36 |
| Re: [SQL] Agregate Problem? | Tom Lane | 15:48 |
| Thread | Author | Time |
|---|---|---|
| defragmentation 📎 | Stanley Morgan | 00:19 |
| Re: [SQL] example of a simple function] | Bruce Momjian | 00:23 |
| RE: [SQL] defragmentation | Michael J Davis | 00:41 |
| Re: [SQL] defragmentation 📎 | Stanley Morgan | 02:56 |
| (no subject) 📎 | Stanley Morgan | 02:58 |
| Random function ? | Zsolt Varga | 05:55 |
| Re: [SQL] datediff function | Herouth Maoz | 11:05 |
| Re: [SQL] Stepping through a table. | Herouth Maoz | 11:13 |
| RE: [SQL] datediff function | Pham, Thinh | 13:18 |
| RE: [SQL] datediff function | Herouth Maoz | 13:28 |
| Re: [SQL] datediff function | Tom Lane | 13:34 |
| RE: [SQL] datediff function | Pham, Thinh | 14:37 |
| RE: [SQL] datediff function | Herouth Maoz | 15:24 |
| RE: [SQL] datediff function | John Ridout | 15:45 |
| Re: [SQL] index on more-than-one columns? | Tom Lane | 21:04 |
| CASE statement causes unknown node type 723 | Nathan Angelacos | 23:36 |
| Thread | Author | Time |
|---|---|---|
| Using intersect in subquery | Hamid Khoshnevis | 00:48 |
| Using intersect in subquery | Hamid Khoshnevis | 01:55 |
| Re: [SQL] Using intersect in subquery | Bruce Momjian | 02:38 |
| Re: [SQL] index on more-than-one columns? | Oleg Bartunov | 05:06 |
| Re: [SQL] CASE statement causes unknown node type 723 | Tom Lane | 13:43 |
| Re: [SQL] Using intersect in subquery | Tom Lane | 13:51 |
| Re: [SQL] Using intersect in subquery | Herouth Maoz | 14:21 |
| Re: [SQL] Using intersect in subquery | Bruce Momjian | 15:10 |
| Counting the number of distinct rows returned | Drew Whittle | 23:59 |
| Thread | Author | Time |
|---|---|---|
| Problems using count() with a join | Doug Younger | 02:10 |
| Re: [SQL] Counting the number of distinct rows returned | [email protected] | 05:20 |
| What JDBC datatype can be used for DATETIME ? | Jon Bundesen | 11:23 |
| Re: [SQL] Problems using count() with a join | Tom Lane | 13:16 |
| does LIMIT save time? | Dirk Lutzebaeck | 13:17 |
| Re: [SQL] Counting the number of distinct rows returned | Tom Lane | 13:18 |
| Re: [SQL] Counting the number of distinct rows returned | Sejin Oh | 13:56 |
| (pas d'objet) | KOUL Christian | 14:01 |
| selecting newer rows | Carlos Henrique Righetto Moreira | 14:30 |
| What JDBC datatype can be used for DATETIME ? | Jon Windfeld Bundesen | 15:42 |
| searching time arrays | Nathan Gelbard | 18:37 |
| Re: [SQL] searching time arrays | Tom Lane | 19:17 |
| multiple keyword search | Mike Field | 21:11 |
| Re: [SQL] does LIMIT save time? | Jan Wieck | 21:24 |
| RE: [SQL] Using intersect in subquery | Hamid Khoshnevis | 21:28 |
| Thread | Author | Time |
|---|---|---|
| Re: [SQL] What JDBC datatype can be used for DATETIME ? | Esteban Chiner Sanz | 06:47 |
| Re: [SQL] does LIMIT save time? | Dirk Lutzebaeck | 08:13 |
| generate random unique object id | Eric Enockson | 14:01 |
| Re: BOUNCE [email protected]: Non-member submission from [Eric Enockson <[email protected]>] | Eric Enockson | 16:13 |
| generate random unique object id | Eric Enockson | 16:23 |
| Missing PL/pgSQL library | Nicolas Cadou | 17:00 |
| OID and PL/pgSQL trigger :-( | Alke | 20:51 |
| Array-fields and many-to-many relations | Alke | 21:28 |
| is this possible, maybe a todo ? function related | Clayton Cottingham | 23:07 |
| Re: [SQL] is this possible, maybe a todo ? function related | Roderick A. Anderson | 23:13 |
| 2 million+ entries | Matthew Hixson | 23:59 |
| Thread | Author | Time |
|---|---|---|
| Re: [SQL] is this possible, maybe a todo ? function related | Zalman Stern | 00:05 |
| Question about comments | Gordon Clarke | 00:58 |
| Re: [SQL] Missing PL/pgSQL library | Nicolas Cadou | 01:10 |
| Re: [SQL] Question about comments | Tom Lane | 03:34 |
| Re: [SQL] is this possible, maybe a todo ? function related | Clayton Cottingham | 05:10 |
| permissions lost: | Clayton Cottingham | 05:29 |
| can i send without being a member | Eric Enockson | 10:17 |
| Re: [SQL] UNIQUE constraint | Mihai Barbos | 15:01 |
| Thread | Author | Time |
|---|---|---|
| Re: [SQL] What JDBC datatype can be used for DATETIME ? | Herouth Maoz | 12:22 |
| Re: [SQL] Counting the number of distinct rows returned | Herouth Maoz | 12:44 |
| Thread | Author | Time |
|---|---|---|
| Re: [SQL] selecting newer rows | José Soares | 13:15 |
| Re: [SQL] is this possible, maybe a todo ? function related | Dr. Nisai Wanakule | 13:27 |
| Expression with aggregate | Albert REINER | 13:42 |
| Re: [SQL] UNIQUE constraint | Tom Lane | 14:01 |
| Re: [HACKERS] RE: [SQL] datediff function | José Soares | 14:02 |
| PostgreSQL locking problem (II) | Steffen E. Thorkildsen | 15:06 |
| Re: [SQL] Expression with aggregate | Scott Barron | 22:28 |
| Thread | Author | Time |
|---|---|---|
| Re: [SQL] Question about comments | Bruce Momjian | 04:07 |
| Re: [SQL] Expression with aggregate | Bruce Momjian | 04:24 |
| bytea 📎 | Stanley Morgan | 05:34 |
| Re: [SQL] 2 million+ entries | Michael Richards | 06:30 |
| Re: [SQL] 2 million+ entries | Matthew Hixson | 07:28 |
| Re: [SQL] 2 million+ entries | Moray McConnachie | 08:06 |
| Re: [SQL] 2 million+ entries | Rudy Gireyev | 08:24 |
| Accessing to a granted table. 📎 | Roberto Perez Lita | 09:17 |
| out of memory error on dumping over 1,000,000 to file | Clayton Cottingham | 10:00 |
| Remove | Drinks, Ivan - ITD | 11:51 |
| Re: [SQL] Expression with aggregate | José Soares | 13:37 |
| RE: [SQL] Accessing to a granted table. | Greg Youngblood | 15:38 |
| Dumping Oracle tables into Postgres | Esteban Chiner Sanz | 16:34 |
| Thread | Author | Time |
|---|---|---|
| Re: [SQL] 2 million+ entries | Michael Richards | 01:25 |
| (no subject) 📎 | Stanley Morgan | 05:54 |
| PgSQL 6.5.1 and Group BY pb | Giampiero Raschetti | 11:08 |
| Re: [SQL] PgSQL 6.5.1 and Group BY pb | Herouth Maoz | 12:58 |
| Re: [SQL] Dumping Oracle tables into Postgres | Howie | 13:29 |
| Re: [SQL] PgSQL 6.5.1 and Group BY pb | Tom Lane | 14:07 |