Discussion for users on SQL related matters.
| 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: Organization of tables | operationsengineer1 | 16:42 |
| Thread | Author | Time |
|---|---|---|
| trigger firing order | chester c young | 02:08 |
| Re: trigger firing order | Gregory Stark | 03:03 |
| Re: trigger firing order | chester c young | 05:43 |
| Re: inner join problem with temporary tables | Rodrigo De León | 09:12 |
| Thread | Author | Time |
|---|---|---|
| joining a table whose name is stored in the primary record | John Gunther | 08:39 |
| Re: joining a table whose name is stored in the primary record | Andreas Kretschmer | 12:06 |
| Re: joining a table whose name is stored in the primary record | Andrew Sullivan | 15:54 |
| Thread | Author | Time |
|---|---|---|
| separating improperly grouped page views | Jeff Frost | 05:16 |
| Re: separating improperly grouped page views | Tom Lane | 05:54 |
| Re: separating improperly grouped page views | Jeff Frost | 06:11 |
| Re: array_to_string | Sabin Coanda | 07:17 |
| Exec a text variable as select | Ranieri Mazili | 13:14 |
| Re: Exec a text variable as select | A. Kretschmer | 13:19 |
| Setting variable | Ranieri Mazili | 14:29 |
| Setting Variable - (Correct) | Ranieri Mazili | 14:34 |
| Re: [SQL] Setting variable | Michael Glaesemann | 14:43 |
| Re: Setting Variable - (Correct) | Michael Glaesemann | 15:17 |
| Re: Setting Variable - (Correct) | Michael Glaesemann | 16:15 |