Discussion for users on SQL related matters.
| Thread | Author | Time |
|---|---|---|
| Re: Get the last inserted id | Scott Marlowe | 17:41 |
| Re: Get the last inserted id | Nacef LABIDI | 17:43 |
| Re: Get the last inserted id | A. Kretschmer | 17:48 |
| Re: Get the last inserted id | Andrew Sullivan | 17:57 |
| Thread | Author | Time |
|---|---|---|
| export CSV file through Java JDBC | Emi Lu | 13:41 |
| rule for update view that updates/inserts into 2 tables | Chad Showalter | 16:47 |
| Thread | Author | Time |
|---|---|---|
| Re: rule for update view that updates/inserts into 2 tables | Robins Tharakan | 00:33 |
| Re: rule for update view that updates/inserts into 2 tables | Chad Showalter | 15:27 |
| Re: [SQL] rule for update view that updates/inserts into 2 tables | Martijn van Oosterhout | 15:41 |
| Re: export CSV file through Java JDBC | Steve Midgley | 17:13 |
| Thread | Author | Time |
|---|---|---|
| How to find double entries | Andreas | 03:15 |
| Re: How to find double entries | Tom Lane | 03:23 |
| Re: How to find double entries | Craig Ringer | 04:22 |
| Re: How to find double entries | Tena Sakai | 05:05 |
| Re: How to find double entries | Volkan YAZICI | 06:15 |
| Multiple databases | Sumaya | 06:59 |
| Re: Multiple databases | A. Kretschmer | 07:24 |
| Index on elements of an array | Florian Weimer | 08:49 |
| Re: Multiple databases | Gerardo Herzig | 12:01 |
| Data Comparison Single Table Question | Bryan Emrys | 13:34 |
| Re: How to find double entries | Vivek Khera | 14:27 |
| Re: Data Comparison Single Table Question | Osvaldo Rosario Kussama | 15:09 |
| Re: How to find double entries | Craig Ringer | 15:49 |
| SQL/XML Multi table join question | Mina R Waheeb | 18:34 |
| using string functions on plpgsql | Marcelo Edgardo Paniagua Lizarraga | 21:50 |
| Thread | Author | Time |
|---|---|---|
| Re: using string functions on plpgsql | Tom Lane | 00:08 |
| Re: using string functions on plpgsql | Craig Ringer | 01:47 |
| Re: using string functions on plpgsql | Craig Ringer | 01:51 |
| What does mod - in "mod statement" - stand for? | Daniel CAUNE | 03:01 |
| Re: What does mod - in "mod statement" - stand for? | Craig Ringer | 04:27 |
| Re: using string functions on plpgsql | Tom Lane | 04:42 |
| error codes | Marcin Krawczyk | 08:23 |
| Desc Commnad in pgsql? | VG | 08:47 |
| Re: Desc Commnad in pgsql? | A. Kretschmer | 08:53 |
| Re: Desc Commnad in pgsql? | Richard Huxton | 08:59 |
| Error in restore the Database in Postgres | dipesh | 10:38 |
| Re: error codes | Craig Ringer | 10:43 |
| Re: error codes | Craig Ringer | 10:51 |
| Re: Error in restore the Database in Postgres | Richard Huxton | 11:01 |
| Thread | Author | Time |
|---|---|---|
| triggers order | Marcin Krawczyk | 09:44 |
| Re: triggers order | A. Kretschmer | 09:49 |
| Re: triggers order | Marcin Krawczyk | 09:55 |
| Thread | Author | Time |
|---|---|---|
| Re: Desc Commnad in pgsql? | Christopher Browne | 16:55 |
| Thread | Author | Time |
|---|---|---|
| Re: How to find double entries | Jean-David Beyer | 01:54 |
| Thread | Author | Time |
|---|---|---|
| Re: Desc Commnad in pgsql? | TJ O'Donnell | 00:14 |
| Re: Desc Commnad in pgsql? | Alvaro Herrera | 13:36 |
| Having a mental block with (self) outer joins | Thomas Kellerer | 13:48 |
| Re: Having a mental block with (self) outer joins | hubert depesz lubaczewski | 14:05 |
| Re: Having a mental block with (self) outer joins | Thomas Kellerer | 14:15 |
| Re: Error: could not find pathkey item to sort | Tom Lane | 14:23 |
| Thread | Author | Time |
|---|---|---|
| Re: extracting words | A. Kretschmer | 05:18 |
| Re: extracting words | Alvaro Herrera | 13:13 |
| Re: extracting words | Tarlika Elisabeth Schmitz | 14:57 |
| Thread | Author | Time |
|---|---|---|
| trim(both) problem? | Emi Lu | 20:33 |
| Re: trim(both) problem? | Tom Lane | 20:44 |
| Re: trim(both) problem? | Stephan Szabo | 20:45 |
| Re: trim(both) problem? | Fernando Hevia | 21:03 |
| Re: trim(both) problem? | Tom Lane | 21:26 |
| Re: trim(both) problem? | chester c young | 21:48 |
| Thread | Author | Time |
|---|---|---|
| Protection from SQL injection | Thomas Mueller | 16:32 |
| Re: Protection from SQL injection | Tom Lane | 17:05 |
| Re: Protection from SQL injection | Jaime Casanova | 18:16 |
| Fwd: Protection from SQL injection | Thomas Mueller | 18:16 |
| Re: Protection from SQL injection | Thomas Mueller | 18:19 |
| Re: Protection from SQL injection | Jaime Casanova | 21:31 |
| Re: Protection from SQL injection | Thomas Kellerer | 21:32 |
| Thread | Author | Time |
|---|---|---|
| Re: psql: no schema info | Alvaro Herrera | 00:05 |
| Re: psql: no schema info | Richard Huxton | 07:30 |
| Re: trim(both) problem? | Emi Lu | 13:19 |
| Re: psql: no schema info | chester c young | 17:01 |
| information_schema.referential_constraints permissions | Lodewijk Voege | 21:47 |
| currval of sequence "my_seq" is not yet defined in this session | Nacef LABIDI | 22:33 |
| Truncate table at a certain size. | Dana Huggard - Navarik | 22:35 |
| Re: information_schema.referential_constraints permissions | Tom Lane | 23:14 |
| Thread | Author | Time |
|---|---|---|
| Re: Truncate table at a certain size. | Gurjeet Singh | 01:24 |
| Re: currval of sequence "my_seq" is not yet defined in this session | Scott Marlowe | 02:22 |
| Re: Truncate table at a certain size. | Scott Marlowe | 03:31 |
| Field Alias Alternative | Bart Degryse | 07:20 |
| Reg:-How to make relationship more one table in PgSQL | venkat | 11:10 |
| Re: Reg:-How to make relationship more one table in PgSQL | kapil.munish | 11:21 |
| Re: Reg:-How to make relationship more one table in PgSQL | Mag Gam | 17:24 |
| Thread | Author | Time |
|---|---|---|
| Re: Curious about wide tables. | Jean-David Beyer | 14:25 |
| columns for count histograms of values | Alexy Khrabrov | 21:01 |
| Re: columns for count histograms of values | chester c young | 23:12 |
| Thread | Author | Time |
|---|---|---|
| Re: columns for count histograms of values | Mag Gam | 01:32 |
| Re: columns for count histograms of values | Alexy Khrabrov | 08:35 |
| Thread | Author | Time |
|---|---|---|
| numbering rows on import from file | Alexy Khrabrov | 21:26 |
| Re: numbering rows on import from file | chester c young | 22:33 |
| Re: numbering rows on import from file | Scott Marlowe | 23:00 |
| Thread | Author | Time |
|---|---|---|
| Re: numbering rows on import from file | Steve Crawford | 00:18 |
| update with multiple fields as aggregates | Alexy Khrabrov | 08:05 |
| Re: update with multiple fields as aggregates | Volkan YAZICI | 14:36 |
| 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 |