Discussion for users on SQL related matters.
| Thread | Author | Time |
|---|---|---|
| Against legal disclaimers in email | Tom Lane | 18:33 |
| Re: ignoring primary key violations in COPY command | Paul Lambert | 22:29 |
| Re: ignoring primary key violations in COPY command | chester c young | 23:58 |
| Thread | Author | Time |
|---|---|---|
| Re: doubt | John DeSoi | 01:01 |
| Thread | Author | Time |
|---|---|---|
| system table storing sequence attributes | Sabin Coanda | 07:03 |
| Re: system table storing sequence attributes | Marcin Stępnicki | 07:43 |
| Re: system table storing sequence attributes | Sabin Coanda | 12:23 |
| Re: system table storing sequence attributes | A. Kretschmer | 12:38 |
| Re: system table storing sequence attributes | Marcin Stępnicki | 12:41 |
| Re: system table storing sequence attributes | Sabin Coanda | 13:12 |
| Re: system table storing sequence attributes | A. Kretschmer | 13:22 |
| Re: system table storing sequence attributes | Sabin Coanda | 13:47 |
| Re: system table storing sequence attributes | Milen A. Radev | 14:01 |
| Thread | Author | Time |
|---|---|---|
| FATAL: cache lookup failed for function 1003 | John Summerfield | 13:41 |
| Re: FATAL: cache lookup failed for function 1003 | Alvaro Herrera | 20:37 |
| Re: FATAL: cache lookup failed for function 1003 | John Summerfield | 23:01 |
| Re: FATAL: cache lookup failed for function 1003 | Alvaro Herrera | 23:10 |
| Re: FATAL: cache lookup failed for function 1003 | Tom Lane | 23:16 |
| Thread | Author | Time |
|---|---|---|
| Potential bug in postgres 8.2.4 | Tomas Doran | 11:20 |
| Re: Potential bug in postgres 8.2.4 | Marcin Stępnicki | 11:34 |
| Re: Potential bug in postgres 8.2.4 | Peter Eisentraut | 11:51 |
| Re: Potential bug in postgres 8.2.4 | Tomas Doran | 11:54 |
| Re: Potential bug in postgres 8.2.4 | Richard Huxton | 12:19 |
| Re: Potential bug in postgres 8.2.4 | Marcin Stępnicki | 12:30 |
| Re: Potential bug in postgres 8.2.4 | Tomas Doran | 12:34 |
| Re: Potential bug in postgres 8.2.4 | Tom Lane | 14:51 |
| Re: Potential bug in postgres 8.2.4 | Tomas Doran | 15:19 |
| off topic | chester c young | 18:15 |
| Re: off topic | Rodrigo De León | 18:23 |
| group by day | Edward W. Rouse | 18:49 |
| Re: group by day | A. Kretschmer | 19:42 |
| Re: group by day | Rodrigo De León | 19:45 |
| Thread | Author | Time |
|---|---|---|
| Re: group by day | Richard Huxton | 08:08 |
| Thread | Author | Time |
|---|---|---|
| aggregate query | Raj A | 04:32 |
| Re: aggregate query | Andrew Kroeger | 08:04 |
| Re: aggregate query | Gregory Stark | 10:50 |
| Re: aggregate query | Raj A | 12:32 |
| Recursively traversing a partially ordered set | Jason Grout | 14:06 |
| Re: Recursively traversing a partially ordered set | Gregory Stark | 15:47 |
| problems with SELECT query results | Joshua | 15:47 |
| Re: problems with SELECT query results | Richard Huxton | 16:36 |
| Re: problems with SELECT query results | Joshua | 17:46 |
| Re: problems with SELECT query results | Lew | 19:33 |
| Re: problems with SELECT query results | Richard Broersma Jr | 20:35 |
| Thread | Author | Time |
|---|---|---|
| spi and error messages | Bart Degryse | 07:33 |
| logging amount rows retrieved? | Gerardo Herzig | 13:44 |
| Re: spi and error messages | Michael Fuhr | 14:13 |
| slow query execution | Trigve Siver | 15:56 |
| Re: slow query execution | Andrew Sullivan | 16:45 |
| Re: slow query execution | Trigve Siver | 17:03 |
| Re: slow query execution | Rodrigo De León | 17:28 |
| Re: slow query execution | Trigve Siver | 17:30 |
| Re: slow query execution | Andrew Sullivan | 17:39 |
| Re: slow query execution | Trigve Siver | 18:08 |
| Re: slow query execution | Andrew Sullivan | 18:30 |
| Re: slow query execution | Trigve Siver | 18:55 |
| Re: slow query execution | Richard Huxton | 19:05 |
| Re: slow query execution | Trigve Siver | 19:11 |
| Thread | Author | Time |
|---|---|---|
| Re: slow query execution | Bart Degryse | 07:24 |
| Re: slow query execution | Trigve Siver | 07:46 |
| ASK about SQL | ali nas | 07:56 |
| Re: ASK about SQL | Phillip Smith | 08:02 |
| Re: slow query execution | Bart Degryse | 08:11 |
| Re: slow query execution | Trigve Siver | 08:42 |
| Re: ASK about SQL | Phillip Smith | 09:17 |
| Re: slow query execution | Richard Huxton | 10:22 |
| Thread | Author | Time |
|---|---|---|
| Versionning (was: Whole-row comparison) | christian.roche.ext | 17:07 |
| Re: Versionning (was: Whole-row comparison) | Andrew Sullivan | 17:47 |
| Re: Versionning (was: Whole-row comparison) | christian.roche.ext | 18:07 |
| schema propagation | chester c young | 18:16 |
| Re: Versionning (was: Whole-row comparison) | Andrew Sullivan | 18:51 |
| Thread | Author | Time |
|---|---|---|
| Re: Encrypted column | Tino Wildenhain | 07:51 |
| JOIN | Loredana Curugiu | 08:11 |
| the right time to vacuum database? | Charles.Hou | 10:33 |
| Re: JOIN | Loredana Curugiu | 11:26 |
| Re: JOIN | Richard Huxton | 12:13 |
| Re: [SQL] JOIN | Loredana Curugiu | 12:18 |
| Re: JOIN | Richard Huxton | 12:39 |
| Re: JOIN | Gregory Stark | 12:45 |
| Re: [SQL] JOIN | Loredana Curugiu | 12:59 |
| CREATE RULE with WHERE clause | Ranieri Mazili | 13:11 |
| Re: the right time to vacuum database? | Chander Ganesan | 13:12 |
| Re: the right time to vacuum database? | Brad Nicholson | 13:12 |
| Re: [SQL] JOIN | Oliveiros Cristina | 13:19 |
| Re: JOIN 📎 | Richard Huxton | 13:21 |
| Re: Encrypted column | Ron Johnson | 13:22 |
| Re: the right time to vacuum database? | Andrew Sullivan | 13:25 |
| Re: Encrypted column | Brian Mathis | 13:31 |
| Re: JOIN | Sean Davis | 13:42 |
| Re: Encrypted column | Alvaro Herrera | 13:59 |
| Re: CREATE RULE with WHERE clause | Richard Broersma Jr | 14:07 |
| Re: [SQL] JOIN | Loredana Curugiu | 14:08 |
| Re: Encrypted column | Marko Kreen | 14:12 |
| Re: [SQL] JOIN | Loredana Curugiu | 14:15 |
| Re: Encrypted column | Brian Mathis | 14:26 |
| Re: Encrypted column | Ron Johnson | 14:28 |
| Re: [SQL] JOIN | Oliveiros Cristina | 14:30 |
| Re: Encrypted column | Marko Kreen | 14:39 |
| Re: CREATE RULE with WHERE clause | Michael Glaesemann | 14:40 |
| Re: [SQL] JOIN | Loredana Curugiu | 14:46 |
| Re: [SQL] JOIN | Oliveiros Cristina | 14:52 |
| Re: [SQL] JOIN | Loredana Curugiu | 14:57 |
| Re: [SQL] JOIN | Oliveiros Cristina | 15:00 |
| Re: Encrypted column | Marko Kreen | 15:09 |
| Re: Encrypted column | Brian Mathis | 15:22 |
| Re: Encrypted column | Andrew Sullivan | 15:27 |
| Re: Encrypted column | Steve Atkins | 15:39 |
| Re: Encrypted column | Tino Wildenhain | 16:16 |
| Re: Encrypted column | Marko Kreen | 16:35 |
| Re: current_date / datetime stuff | Gerardo Herzig | 18:01 |
| Re: the right time to vacuum database? | Charles.Hou | 23:59 |
| Thread | Author | Time |
|---|---|---|
| Re: the right time to vacuum database? | Charles.Hou | 00:28 |
| Re: current_date / datetime stuff | Rodrigo De León | 01:11 |
| Re: Encrypted column | Joe Conway | 03:34 |
| How to find missing values across multiple OUTER JOINs | Drew | 06:55 |
| Re: [SQL] JOIN | Loredana Curugiu | 08:26 |
| Re: How to find missing values across multiple OUTER JOINs | Richard Huxton | 08:31 |
| Re: How to find missing values across multiple OUTER JOINs | Ragnar | 08:45 |
| Re: How to find missing values across multiple OUTER JOINs | Drew | 08:46 |
| Re: schema propagation | Markus Schiltknecht | 12:12 |
| Re: JOIN | Loredana Curugiu | 12:46 |
| Re: JOIN 📎 | Loredana Curugiu | 12:47 |
| Re: the right time to vacuum database? | Brad Nicholson | 13:57 |
| Re: current_date / datetime stuff | Osvaldo Rosario Kussama | 15:54 |
| Re: current_date / datetime stuff | Kristo Kaiv | 15:56 |
| Re: the right time to vacuum database? | Andrew Sullivan | 19:51 |
| Thread | Author | Time |
|---|---|---|
| Re: [ADMIN] the right time to vacuum database? | osmar della paschoa jr | 00:59 |
| Re: [SQL] subtract a day from the NOW function | Kevin Hunter | 03:31 |
| Re: [SQL] subtract a day from the NOW function | Tom Lane | 04:12 |
| Re: [SQL] subtract a day from the NOW function | John Meyer | 04:45 |
| Re: the right time to vacuum database? | Charles.Hou | 13:29 |
| Re: subtract a day from the NOW function | Campbell, Lance | 14:15 |
| Re: the right time to vacuum database? | Andrew Sullivan | 14:20 |
| Re: the right time to vacuum database? | Charles.Hou | 15:20 |
| show index from [table] | Stefan Zweig | 15:25 |
| Re: the right time to vacuum database? | Andrew Sullivan | 15:34 |
| Re: show index from [table] | Andreas Kretschmer | 15:47 |
| Re: show index from [table] | Ireneusz Pluta | 19:13 |
| Thread | Author | Time |
|---|---|---|
| search path within trigger | chester c young | 16:56 |
| Re: search path within trigger | Shoaib Mir | 17:21 |
| Thread | Author | Time |
|---|---|---|
| Re: show index from [table] | Kristo Kaiv | 06:28 |
| cluster index on primary key | Sabin Coanda | 14:31 |
| Re: cluster index on primary key | Rodrigo De León | 14:44 |
| Thread | Author | Time |
|---|---|---|
| Using INET types in prepared statements | LITTLE Nelson | 02:03 |
| Re: Using INET types in prepared statements | Tom Lane | 02:45 |
| sql server to postgreSQL | Ashish Karalkar | 08:49 |
| setof or array as input parameter to postgresql 8.2 functions | Jyoti Seth | 11:57 |
| Re: [SQL] setof or array as input parameter to postgresql 8.2 functions | Pavel Stehule | 12:55 |
| Re: setof or array as input parameter to postgresql 8.2 functions | Albe Laurenz | 13:09 |
| join problem | A. R. Van Hook | 13:19 |
| Re: join problem | Guillaume Lelarge | 13:44 |
| Re: join problem | Ales Vojacek | 13:47 |
| Re: join problem | Ales Vojacek | 13:52 |
| Re: join problem | Michael Glaesemann | 13:58 |
| calculate time diffs across rows with single timestamp | Bob Singleton | 16:17 |
| Re: calculate time diffs across rows with single timestamp | Rodrigo De León | 16:51 |
| Re: calculate time diffs across rows with single timestamp 📎 | Bob Singleton | 18:48 |
| Thread | Author | Time |
|---|---|---|
| Re: [SQL] setof or array as input parameter to postgresql 8.2 functions | Jyoti Seth | 05:47 |
| Re: [SQL] setof or array as input parameter to postgresql 8.2 functions | Pavel Stehule | 05:57 |
| Re: [SQL] setof or array as input parameter to postgresql 8.2 functions | Jyoti Seth | 06:04 |
| function to find difference between in days between two dates | Ashish Karalkar | 06:26 |
| Re: [SQL] function to find difference between in days between two dates | Pavel Stehule | 07:00 |