Discussion for users on SQL related matters.
| Thread | Author | Time |
|---|---|---|
| LEFT OUTER JOIN question | seiliki | 16:28 |
| Re: LEFT OUTER JOIN question | Craig Ringer | 16:40 |
| Re: LEFT OUTER JOIN question | Aaron Bono | 16:46 |
| Re: LEFT OUTER JOIN question | Frank Bax | 16:54 |
| Thread | Author | Time |
|---|---|---|
| Working with dates before 4713 BC | Ryan Wallace | 00:22 |
| Re: Working with dates before 4713 BC | Tom Lane | 01:17 |
| Re: Working with dates before 4713 BC | Phillip Smith | 01:28 |
| Database normalization | Sid 'Neko Tamashii' | 11:06 |
| Re: Database normalization | Richard Huxton | 12:28 |
| Re: Database normalization | Sid 'Neko Tamashii' | 12:33 |
| Thread | Author | Time |
|---|---|---|
| dbmirror - migration to 8.3 from 7.4 | Achilleas Mantzios | 11:42 |
| Re: dbmirror - migration to 8.3 from 7.4 | Claus Guttesen | 11:49 |
| Re: dbmirror - migration to 8.3 from 7.4 | Claus Guttesen | 11:51 |
| Re: dbmirror - migration to 8.3 from 7.4 | Achilleas Mantzios | 11:52 |
| Insert with pl/pgsql trigger | Woody Woodring | 14:36 |
| Re: how to check if a point is contained in a polygon ? | Richard Huxton | 14:38 |
| Re: how to check if a point is contained in a polygon ? | Tom Lane | 15:12 |
| Re: Insert with pl/pgsql trigger | Tom Lane | 15:24 |
| how to check if a point is contained in a polygon ? | Julien Cigar | 16:25 |
| Re: how to check if a point is contained in a polygon ? | Julien Cigar | 17:00 |
| Thread | Author | Time |
|---|---|---|
| Joining with result of a plpgsql function | Matthew T. O'Connor | 03:28 |
| Re: Joining with result of a plpgsql function | Stephan Szabo | 04:07 |
| Re: Joining with result of a plpgsql function | Matthew T. O'Connor | 05:21 |
| Index to enforce non-overlapping ranges? | James Robinson | 13:27 |
| Re: Index to enforce non-overlapping ranges? | Chris Browne | 14:31 |
| Re: Index to enforce non-overlapping ranges? | Tom Lane | 14:54 |
| Thread | Author | Time |
|---|---|---|
| execute plpgsl like "normal" sql | Christian Kindler | 10:00 |
| Re: execute plpgsl like "normal" sql | Christian Kindler | 15:00 |
| Thread | Author | Time |
|---|---|---|
| Difference in columns | Mag Gam | 17:37 |
| Re: Difference in columns | chester c young | 17:54 |
| Re: Difference in columns | Gurjeet Singh | 17:55 |
| Re: Difference in columns | hubert depesz lubaczewski | 18:11 |
| Re: Difference in columns | Craig Ringer | 18:17 |
| Re: Difference in columns | Gurjeet Singh | 18:36 |
| Re: Difference in columns | Tom Lane | 18:58 |
| Re: Difference in columns | Craig Ringer | 19:58 |
| Thread | Author | Time |
|---|---|---|
| Re: Difference in columns | Mag Gam | 00:58 |
| merge timestamps to intervals | Patrick Scharrenberg | 05:38 |
| Re: merge timestamps to intervals | Craig Ringer | 06:33 |
| Re: merge timestamps to intervals | Andreas Kretschmer | 06:56 |
| Thread | Author | Time |
|---|---|---|
| Auto-formatting timestamps? | Peter Koczan | 15:58 |
| Re: Auto-formatting timestamps? | Mag Gam | 22:54 |
| Add a ROWCOUNT to the output of a select. | Gavin 'Beau' Baumanis | 23:54 |
| Thread | Author | Time |
|---|---|---|
| Re: Add a ROWCOUNT to the output of a select. | Gurjeet Singh | 00:33 |
| Re: Add a ROWCOUNT to the output of a select. | Robins Tharakan | 01:18 |
| Re: Add a ROWCOUNT to the output of a select. | Marcin Stępnicki | 08:34 |
| Re: Add a ROWCOUNT to the output of a select. | Harald Fuchs | 08:40 |
| Re: Add a ROWCOUNT to the output of a select. | Marcin Stępnicki | 08:48 |
| Re: Add a ROWCOUNT to the output of a select. | Robins Tharakan | 10:01 |
| Re: Auto-formatting timestamps? | Peter Koczan | 15:46 |
| Re: Auto-formatting timestamps? | Alvaro Herrera | 15:59 |
| Thread | Author | Time |
|---|---|---|
| Re: Auto-formatting timestamps? | Mag Gam | 02:46 |
| Query tuning | kapil.munish | 06:00 |
| xpath_table | Thomas Kellerer | 11:37 |
| Thread | Author | Time |
|---|---|---|
| Re: Query tuning | Moiz Kothari | 11:50 |
| Find all instances of a column in the entire database. | Gavin 'Beau' Baumanis | 13:51 |
| Re: Find all instances of a column in the entire database. | hubert depesz lubaczewski | 13:56 |
| Re: Find all instances of a column in the entire database. | Gavin 'Beau' Baumanis | 14:04 |
| Re: Find all instances of a column in the entire database. | A. Kretschmer | 14:27 |
| Re: Query tuning | Scott Marlowe | 15:21 |
| Re: Query tuning | Simon Riggs | 16:13 |
| Re: Find all instances of a column in the entire database. | Chris Browne | 16:21 |
| Thread | Author | Time |
|---|---|---|
| dblinks | sumaya | 22:58 |
| Re: dblinks | Jonah H. Harris | 23:31 |
| Thread | Author | Time |
|---|---|---|
| Re: dblinks | sumaya | 08:47 |
| Re: dblinks | sumaya | 09:25 |
| Re: dblinks | Jonah H. Harris | 12:02 |
| Thread | Author | Time |
|---|---|---|
| Re: dblinks | Ramasubramanian G | 03:06 |
| Re: dblinks | Dave Page | 08:22 |
| Supplying a default on read, if a column does not exist in DB | Bryce Nesbitt | 21:48 |
| Thread | Author | Time |
|---|---|---|
| SQL question.... | Karl Denninger | 18:14 |
| Re: SQL question.... | chester c young | 19:06 |
| Re: SQL question.... | Karl Denninger | 19:17 |
| Re: SQL question.... | Harold A. Giménez Ch. | 19:54 |
| Re: SQL question.... | Gurjeet Singh | 20:57 |
| Re: SQL question.... | Karl Denninger | 23:17 |
| Thread | Author | Time |
|---|---|---|
| Re: SQL question.... | Gurjeet Singh | 02:53 |
| Re: SQL question.... | Karl Denninger | 03:03 |
| Re: SQL question.... | Gurjeet Singh | 07:52 |
| Re: SQL question.... | Karl Denninger | 11:39 |
| Thread | Author | Time |
|---|---|---|
| Re: SQL question.... | Steve Midgley | 00:42 |
| Re: SQL question.... | Karl Denninger | 01:12 |
| Substract queries | Nacef LABIDI | 15:15 |
| Re: Substract queries | Robins Tharakan | 15:27 |
| Re: Substract queries | Craig Ringer | 15:35 |
| Re: Substract queries | Niklas Johansson | 15:36 |
| Re: Substract queries | Nacef LABIDI | 15:49 |
| Extremely Low performance with ODBC | Sebastian Rychter | 18:29 |
| Query question | Medi Montaseri | 21:28 |
| Re: Query question | Stephan Szabo | 21:50 |
| Re: Query question | Medi Montaseri | 22:23 |
| Thread | Author | Time |
|---|---|---|
| Re: Substract queries | Ramasubramanian G | 04:42 |
| Re: Extremely Low performance with ODBC | Steve Crawford | 05:42 |
| Re: Extremely Low performance with ODBC | Craig Ringer | 08:53 |
| Re: Extremely Low performance with ODBC | Richard Broersma | 16:03 |
| Re: Extremely Low performance with ODBC | Sebastian Rychter | 16:47 |
| Re: Extremely Low performance with ODBC | Richard Broersma | 20:26 |
| Re: Extremely Low performance with ODBC | Craig Ringer | 21:07 |
| Re: Extremely Low performance with ODBC | Richard Broersma | 21:33 |
| Re: Extremely Low performance with ODBC | Sebastian Rychter | 21:45 |
| Re: Extremely Low performance with ODBC | Richard Broersma | 22:00 |
| Thread | Author | Time |
|---|---|---|
| I invite you to join my Ziki Network ! 📎 | Nacef LABIDI | 21:51 |
| Thread | Author | Time |
|---|---|---|
| Re: Extremely Low performance with ODBC | Sebastian Rychter | 03:26 |
| Re: Extremely Low performance with ODBC | Richard Broersma | 04:13 |
| Re: Extremely Low performance with ODBC | Sebastian Rychter | 04:34 |
| Enumerated (enum) types | Michael Lourant | 14:29 |
| UPDATE with table join | Tarlika Elisabeth Schmitz | 15:53 |
| Re: Enumerated (enum) types | Harald Fuchs | 16:08 |
| Re: Extremely Low performance with ODBC | Richard Broersma | 16:29 |
| Re: Enumerated (enum) types | Tena Sakai | 16:51 |
| Thread | Author | Time |
|---|---|---|
| Re: Extremely Low performance with ODBC | Steve Midgley | 06:21 |
| Re: Extremely Low performance with ODBC | Steve Midgley | 06:29 |
| Re: Extremely Low performance with ODBC | Sebastian Rychter | 12:55 |
| Re: Extremely Low performance with ODBC | Bruce Momjian | 21:16 |
| Thread | Author | Time |
|---|---|---|
| How long - Vacumm full - 10 million to 90,000 | Emi Lu | 15:33 |
| Re: How long - Vacumm full - 10 million to 90,000 | Andrew Sullivan | 16:22 |
| Re: How long - Vacumm full - 10 million to 90,000 | Steve Crawford | 16:44 |
| Thread | Author | Time |
|---|---|---|
| String comparison problem. | Theerasak Maneeneim | 03:45 |
| Re: String comparison problem. | Scott Marlowe | 04:41 |
| Weeks elapsed to Months elapsed conversion | Allan Kamau | 09:21 |
| Re: Weeks elapsed to Months elapsed conversion | Bart Degryse | 14:56 |
| Re: Weeks elapsed to Months elapsed conversion | Richard Huxton | 15:13 |
| Re: Weeks elapsed to Months elapsed conversion | Fernando Hevia | 16:22 |
| Re: Weeks elapsed to Months elapsed conversion | Rodrigo E. De León Plicet | 17:19 |
| Thread | Author | Time |
|---|---|---|
| bcp.exe Fix Triggers | yazicivo | 08:25 |
| Re: bcp.exe Fix Triggers | Joe | 12:36 |
| Re: bcp.exe Fix Triggers | Tom Lane | 13:52 |
| function returning result set of varying column | maria s | 20:40 |
| Thread | Author | Time |
|---|---|---|
| 3 SELECTs rolled into 1 ? | Tarlika Elisabeth Schmitz | 07:41 |
| Re: 3 SELECTs rolled into 1 ? | A. Kretschmer | 07:55 |
| months, intervals and integers | Gary Stainburn | 08:44 |
| Re: SOLVED - months, intervals and integers | Gary Stainburn | 10:06 |
| Problems with a Query between 7.3 and 8.2 | Holm Tiffe | 10:47 |
| Re: Problems with a Query between 7.3 and 8.2 | A. Kretschmer | 11:35 |
| Re: Problems with a Query between 7.3 and 8.2 | Holm Tiffe | 12:05 |
| Re: 3 SELECTs rolled into 1 ? | Tarlika Elisabeth Schmitz | 12:14 |
| Thread | Author | Time |
|---|---|---|
| Re: Problems with a Query between 7.3 and 8.2 | sathiya moorthy | 05:31 |
| design resource | Edward W. Rouse | 14:14 |
| Re: design resource | Craig Ringer | 17:30 |
| Re: Problems with a Query between 7.3 and 8.2 | Holm Tiffe | 17:46 |
| Thread | Author | Time |
|---|---|---|
| Trouble with exception | samantha mahindrakar | 14:29 |
| Re: design resource | Steve Midgley | 14:57 |
| crosstab functions in postgres 8.1 | Chris Preston | 18:33 |
| Re: design resource | Craig Ringer | 19:17 |
| Re: Trouble with exception | Craig Ringer | 19:46 |
| Thread | Author | Time |
|---|---|---|
| Re: crosstab functions in postgres 8.1 | Tom Lane | 00:12 |
| Need some magic with alternative rows | Andreas | 03:04 |
| Thread | Author | Time |
|---|---|---|
| Re: Need some magic with alternative rows | Niklas Johansson | 09:59 |
| Thread | Author | Time |
|---|---|---|
| Parallel updates on multiple cores | Andrei | 08:29 |
| Re: Parallel updates on multiple cores | Shane Ambler | 10:29 |
| Re: Parallel updates on multiple cores | Simon Riggs | 14:25 |
| Unable to create function which takes no arguments | Michael Eshom | 16:05 |
| Re: Unable to create function which takes no arguments | Mark Roberts | 16:46 |
| Re: Unable to create function which takes no arguments | Pavel Stehule | 16:48 |
| Re: Unable to create function which takes no arguments | hubert depesz lubaczewski | 16:49 |
| Thread | Author | Time |
|---|---|---|
| Update and trigger | Medi Montaseri | 01:45 |
| Re: Update and trigger | A. Kretschmer | 05:21 |
| Re: Update and trigger | Craig Ringer | 05:35 |