Discussion for users on SQL related matters.
| Thread | Author | Time |
|---|---|---|
| Re: simple LEFT JOIN giving wrong results ... | Stephan Szabo | 00:47 |
| Skip dups on INSERT instead of generating an error ... | Marc G. Fournier | 20:53 |
| Re: Skip dups on INSERT instead of generating an error ... | scott.marlowe | 21:02 |
| Re: Skip dups on INSERT instead of generating an error ... | scott.marlowe | 21:03 |
| Re: Skip dups on INSERT instead of generating an error ... | Tomasz Myrta | 21:33 |
| Thread | Author | Time |
|---|---|---|
| Interest IN problem on 7.4 | pginfo | 07:10 |
| Re: Help converting Oracle instead of triggers to PostgreSQL | Robert Treat | 14:55 |
| Re: Interest IN problem on 7.4 | Stephan Szabo | 19:00 |
| INHERITS and Foreign keys | [email protected] | 19:43 |
| Re: INHERITS and Foreign keys | Stephan Szabo | 19:55 |
| Re: INHERITS and Foreign keys | [email protected] | 21:07 |
| Thread | Author | Time |
|---|---|---|
| arrays in pl/pgsql | Michael Shapiro | 09:52 |
| Thread | Author | Time |
|---|---|---|
| dump and schema | van Elsacker Frans | 15:33 |
| Re: Interest IN problem on 7.4 | pginfo | 15:53 |
| Re: dump and schema | Tom Lane | 16:22 |
| NOT-IN CLAUSE 📎 | Prashant Dalal | 17:14 |
| Re: NOT-IN CLAUSE | Bruno Wolff III | 19:28 |
| Thread | Author | Time |
|---|---|---|
| Re: arrays in pl/pgsql | Tom Lane | 03:55 |
| Re: dump and schema | Olivier Hubaut | 09:27 |
| failed to build any 5-way joins | Alessandro Depase | 11:46 |
| Re: dump and schema | Peter Eisentraut | 13:28 |
| Pgaccess problem | vijaykumar M | 13:29 |
| Re: failed to build any 5-way joins | Peter Eisentraut | 13:30 |
| Re: dump and schema | Tom Lane | 14:17 |
| Re: failed to build any 5-way joins | Tom Lane | 14:22 |
| Re: Pgaccess problem | Paul Thomas | 14:46 |
| Re: Pgaccess problem | Richard Huxton | 14:57 |
| Insert Row to ResultSet problem....java.sql.SQLException: No Primary Keys | Jason L. van Brackel | 15:24 |
| Re: failed to build any 5-way joins | Alessandro Depase | 15:34 |
| Re: failed to build any 5-way joins | Richard Huxton | 16:12 |
| Re: failed to build any 5-way joins | Alessandro Depase | 16:23 |
| Problem with functions. | Jonas Lindholm | 18:55 |
| Thread | Author | Time |
|---|---|---|
| SQL Optimization | Preeti Ambardar | 06:26 |
| Re: failed to build any 5-way joins | Tom Lane | 15:32 |
| Re: failed to build any 5-way joins | Alessandro Depase | 16:04 |
| migration between databases and versions | mohan | 18:58 |
| Thread | Author | Time |
|---|---|---|
| Re: migration between databases and versions | Iain | 01:30 |
| Re: migration between databases and versions | A.Bhuvaneswaran | 09:40 |
| how do i get differences between rows | teknokrat | 12:21 |
| Returning Setof Record Dynamically | A E | 18:20 |
| Thread | Author | Time |
|---|---|---|
| INDEX and NULL values | Matthew Rudolph | 00:23 |
| Crosstable query | Dok, D. van | 14:41 |
| how to preserve \n in select statement | Matt Van Mater | 15:06 |
| testing for null value in integer field? | Geoffrey | 16:07 |
| Re: testing for null value in integer field? | CoL | 16:08 |
| Re: testing for null value in integer field? | Wei Weng | 16:12 |
| Re: testing for null value in integer field? | Guy Fraser | 16:16 |
| Re: testing for null value in integer field? | Geoffrey | 16:22 |
| Re: how to preserve \n in select statement | Matt Van Mater | 18:29 |
| Re: how to preserve \n in select statement | Bruno Wolff III | 21:26 |
| Re: INHERITS and Foreign keys | Pedro | 23:51 |
| Thread | Author | Time |
|---|---|---|
| Re: how to preserve \n in select statement | Matt Van Mater | 04:23 |
| Re: how to preserve \n in select statement | Tom Lane | 04:45 |
| Re: how to preserve \n in select statement | Matt Van Mater | 17:58 |
| Re: how to preserve \n in select statement | Tom Lane | 18:35 |
| Thread | Author | Time |
|---|---|---|
| Get x from point? | Daniel Lau | 08:54 |
| Re: how to preserve \n in select statement | Richard Huxton | 09:04 |
| Re: how to preserve \n in select statement | Denis | 09:37 |
| [No subject] | sundaresan raman | 10:30 |
| Re: how to preserve \n in select statement | Richard Huxton | 10:48 |
| Re: Get x from point? | Michael Fuhr | 10:53 |
| restoring database | LAIN Lucas TECHTEL | 14:58 |
| restoring database | Lucas Lain | 14:58 |
| Re: restoring database | Theodore Petrosky | 16:43 |
| Re: restoring database | scott.marlowe | 17:53 |
| Re: Insert Row to ResultSet | Dave Cramer | 19:32 |
| Re: Crosstable query | Michael Glaesemann | 22:32 |
| Re: SQL Optimization | Tom Lane | 23:07 |
| Re: [JDBC] Insert Row to ResultSet problem....java.sql.SQLException: No Primary Keys | Paul Thomas | 23:50 |
| Thread | Author | Time |
|---|---|---|
| Re: | A.Bhuvaneswaran | 05:22 |
| Pgaccess problem on RedhatLinux9 | vijaykumar M | 05:49 |
| Re: Pgaccess problem on RedhatLinux9 | Richard Huxton | 09:22 |
| stored queries | Joop | 09:25 |
| Re: restoring database | Markus Bertheau | 10:18 |
| Re: INHERITS and Foreign keys | Chris Travers | 13:13 |
| Re: how do i get differences between rows | teknokrat | 13:23 |
| Historic Query using a view/function ? | Chris Gamache | 16:46 |
| Distributed keys | Michael Glaesemann | 21:42 |
| Re: Distributed keys | Tom Lane | 23:39 |
| Thread | Author | Time |
|---|---|---|
| Re: how do i get differences between rows | Bruno Wolff III | 03:31 |
| Re: how to preserve \n in select statement | Iain | 03:56 |
| MD5 encrypt | alvaro | 16:47 |
| Thread | Author | Time |
|---|---|---|
| Use of Setof Record Dynamically | A E | 00:17 |
| not in vs not exists - vastly diferent performance | Iain | 01:50 |
| Re: Distributed keys | Chris Travers | 02:45 |
| Point and function help | Andy Lewis | 07:05 |
| Re: not in vs not exists - vastly diferent performance | Tom Lane | 16:32 |
| Re: Point and function help | Tom Lane | 16:43 |
| Re: Point and function help | Andy Lewis | 18:39 |
| Thread | Author | Time |
|---|---|---|
| Multiple DB servers on a single machine | Kumar | 06:32 |
| Re: Multiple DB servers on a single machine | A.Bhuvaneswaran | 09:31 |
| Anti log in PostgreSQL | Sai Hertz And Control Systems | 22:12 |
| Re: Anti log in PostgreSQL | Martin Marques | 22:34 |
| Re: [SQL] Anti log in PostgreSQL | Sai Hertz And Control Systems | 22:46 |
| Re: Anti log in PostgreSQL | Wei Weng | 22:53 |
| Re: Anti log in PostgreSQL | Yasir Malik | 23:18 |
| Re: Anti log in PostgreSQL | Martin Marques | 23:20 |
| Re: Anti log in PostgreSQL | Sai Hertz And Control Systems | 23:25 |
| Re: Anti log in PostgreSQL | Tom Lane | 23:37 |
| Radius of a zip code | Andy Lewis | 23:42 |
| Thread | Author | Time |
|---|---|---|
| Stored Procedures | beyaRecords - The home Urban music | 01:57 |
| Re: Stored Procedures | Christopher Browne | 02:02 |
| Re: Stored Procedures | Michael Fuhr | 02:15 |
| Installing pgplsql on postgresql ver. 7.4 on os x 10.3 | beyaRecords - The home Urban music | 15:13 |
| Re: Installing pgplsql on postgresql ver. 7.4 on os x 10.3 | Michael Fuhr | 19:28 |
| 7.4.1 install problems on OS X 10.3 | beyaRecords - The home Urban music | 20:48 |
| Re: [SQL] 7.4.1 install problems on OS X 10.3 | Theodore Petrosky | 22:05 |
| Re: 7.4.1 install problems on OS X 10.3 | Tom Lane | 23:00 |
| Thread | Author | Time |
|---|---|---|
| Get x from path/polygon? | Daniel Lau | 06:49 |
| postgreSQL editors | beyaRecords - The home Urban music | 16:05 |
| Re: postgreSQL editors | Adam Ruth | 16:53 |
| "on insert" rules happen before the insert? | Thomas Reat | 21:49 |
| Thread | Author | Time |
|---|---|---|
| Re: postgreSQL editors | Michael Glaesemann | 05:02 |
| functional index | Hijax | 10:55 |
| Re: postgreSQL editors | Wei Weng | 15:23 |
| Re: postgreSQL editors | Rich Hall | 19:08 |
| Re: postgreSQL editors | Andy Lewis | 19:57 |
| Re: postgreSQL editors | beyaRecords - The home Urban music | 20:44 |
| Re: postgreSQL editors | Adam Ruth | 22:46 |
| Thread | Author | Time |
|---|---|---|
| Re: not in vs not exists - vastly diferent performance | Randolf Richardson | 04:48 |
| Re: Radius of a zip code | Randolf Richardson | 04:56 |
| Re: [SQL] index row size 2728 exceeds btree maximum, 2713 | Dinesh Pandey | 09:43 |
| Re: index row size 2728 exceeds btree maximum, 2713 | Dinesh Pandey | 10:09 |
| Thread | Author | Time |
|---|---|---|
| Stored procedures | beyaRecords - The home Urban music | 01:50 |
| Re: Stored procedures | Tom Lane | 02:10 |
| Ambiguous error message | Samuel Tardieu | 16:49 |
| Thread | Author | Time |
|---|---|---|
| Re: Ambiguous error message | Michael Glaesemann | 00:46 |
| Re: Ambiguous error message | Tom Lane | 00:47 |
| Re: Ambiguous error message | Samuel Tardieu | 00:55 |
| Re: Ambiguous error message | Samuel Tardieu | 00:56 |
| Re: Ambiguous error message | Michael Fuhr | 01:05 |
| sort by on two columns | Andy Lewis | 01:15 |
| Re: Ambiguous error message | Bertrand Petit | 01:30 |
| Re: sort by on two columns | Michael Glaesemann | 02:40 |
| Re: sort by on two columns | Andy Lewis | 02:55 |
| Re: sort by on two columns | Michael Glaesemann | 03:04 |
| Re: sort by on two columns | Chris Travers | 04:05 |
| Re: sort by on two columns | Adam Ruth | 04:32 |
| Complex Update | John Coryat | 09:20 |
| Thread | Author | Time |
|---|---|---|
| DO INSTEAD in rule | Tatsuo Ishii | 13:51 |
| Re: DO INSTEAD in rule | Tom Lane | 17:48 |
| Historic Query using a view/function ? | Chris Gamache | 18:54 |
| Re: DO INSTEAD in rule | Tatsuo Ishii | 23:39 |
| Thread | Author | Time |
|---|---|---|
| Re: not in vs not exists - vastly diferent performance | Iain | 01:40 |
| Re: "on insert" rules happen before the insert? | Tom Lane | 05:26 |
| Virtual records | Kumar | 11:04 |
| Re: Complex Update | Richard Huxton | 11:10 |
| grouping by date | teknokrat | 17:14 |
| ecpg - problem compiling prepare and declare statements | Paul Tilles | 18:14 |
| PostgreSQL Array Syntax | Evan Klinger | 21:47 |
| Re: Virtual records | Rich Hall | 23:21 |
| Thread | Author | Time |
|---|---|---|
| Calendar Scripts - Quite a complex one | Kumar | 06:06 |
| Re: Calendar Scripts - Quite a complex one | Peter Eisentraut | 18:56 |
| Re: Calendar Scripts - Quite a complex one | Josh Berkus | 22:13 |
| unix time -> timestamp | boyd | 23:29 |
| Re: unix time -> timestamp | boyd | 23:36 |
| question : the choice of the primary key. | Loeke | 23:38 |
| Thread | Author | Time |
|---|---|---|
| Re: Calendar Scripts - Quite a complex one | Kumar | 06:06 |
| COPY command | azwa | 06:19 |
| Re: Calendar Scripts - Quite a complex one | Chris Travers | 07:49 |
| COPY command | azwa | 08:35 |
| Different query results in psql and Perl DBI with Postgres 7.2.1 | Brendan LeFebvre | 11:14 |
| Re: Calendar Scripts - Quite a complex one | Kumar | 12:39 |
| Importation wtih copy generated some wrong registers.. | Rodrigo Sakai | 13:58 |
| unique constraints | Kenneth Gonsalves | 14:17 |
| Re: question : the choice of the primary key. | Loeke | 14:17 |
| Notation of index | Andreas | 17:09 |
| Re: unique constraints | Michael Fuhr | 17:31 |
| Re: Notation of index | Richard Huxton | 18:25 |
| Re: Notation of index | Peter Eisentraut | 18:36 |
| Re: Importation wtih copy generated some wrong registers.. | Peter Eisentraut | 18:41 |
| Thread | Author | Time |
|---|---|---|
| Re: unique constraints | Kenneth Gonsalves | 04:20 |
| Re: Calendar Scripts - Quite a complex one | Chris Travers | 10:02 |
| Re: Different query results in psql and Perl DBI with Postgres 7.2.1 | boyd | 12:05 |
| Start-up problems | beyaRecords - The home Urban music | 12:59 |
| Date select question... | Lance Munslow | 13:13 |
| Re: Start-up problems | Kaloyan Iliev Iliev | 14:00 |
| Re: Start-up problems | Johannes Lochmann | 14:17 |