Discussion for users on SQL related matters.
| 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 |
| Thread | Author | Time |
|---|---|---|
| data loading | azwa | 02:13 |
| Re: COPY command | Gregory S. Williamson | 03:06 |
| Re: COPY command | azwa | 04:11 |
| Re: COPY command | Michael Glaesemann | 04:49 |
| Re: grouping by date | Robert Creager | 04:59 |
| Left outer join on multiple tables | David Witham | 05:23 |
| Re: Date select question... | Tom Lane | 05:49 |
| Missing data for column | azwa | 07:15 |
| Type conversion from TEXT to DOUBLE PRECISION | Daniel Lau | 07:35 |
| Re: Type conversion from TEXT to DOUBLE PRECISION | Tom Lane | 07:47 |
| Re: Type conversion from TEXT to DOUBLE PRECISION | Richard Huxton | 08:09 |
| Re: Missing data for column | Michael Glaesemann | 09:54 |
| Re: Type conversion from TEXT to DOUBLE PRECISION | Tom Lane | 14:57 |
| Re: Type conversion from TEXT to DOUBLE PRECISION | Daniel Lau | 15:44 |
| Re: data loading | Richard Huxton | 20:04 |
| Re: data loading | Richard Huxton | 20:06 |
| how to show table structure? | Bing Du | 23:05 |
| Re: how to show table structure? | scott.marlowe | 23:10 |
| Re: how to show table structure? | Larry Rosenman | 23:12 |
| Thread | Author | Time |
|---|---|---|
| Re: how to show table structure? | Kumar | 04:03 |
| Adding a column to a VIEW which has dependent objects. | Rajesh Kumar Mallah | 07:54 |
| Re: Adding a column to a VIEW which has dependent objects. | Tom Lane | 16:48 |
| Re: data loading | Jeff Eckermann | 18:28 |
| Thread | Author | Time |
|---|---|---|
| Re: Different query results in psql and Perl DBI with Postgres 7.2.1 | Greg Sabino Mullane | 19:17 |
| Re: Left outer join on multiple tables | Peter Eisentraut | 19:55 |
| Thread | Author | Time |
|---|---|---|
| Re: Missing data for column | azwa | 01:07 |
| Select into | beyaRecords - The home Urban music | 01:09 |
| Problem with NOT IN portion of query. | Robert Creager | 04:04 |
| Unique field key or several fks ? | Katarn | 05:18 |
| Unique key field or serverl fks ? | katarn | 05:51 |
| Re: Problem with NOT IN portion of query. | Tomasz Myrta | 06:28 |
| Insert into | azwa | 09:12 |
| Re: Select into | Richard Huxton | 09:45 |
| Re: Unique key field or serverl fks ? | Richard Huxton | 09:52 |
| Re: Problem with NOT IN portion of query. | Robert Creager | 13:05 |
| Triggers | beyaRecords - The home Urban music | 16:14 |
| Re: Triggers | Peter Eisentraut | 16:33 |
| Re: Adding a column to a VIEW which has dependent objects. | scott.marlowe | 16:34 |
| Re: Triggers | Sai Hertz And Control Systems | 16:47 |
| Re: Triggers | Richard Huxton | 17:11 |
| Re: Unique key field or serverl fks ? | katarn | 21:36 |
| Is it possible in PostgreSQL? | Bronx | 23:58 |
| Thread | Author | Time |
|---|---|---|
| Transpose rows to columns | David Witham | 01:12 |
| Re: Transpose rows to columns | Michael Glaesemann | 03:50 |
| Re: Triggers | Benoît BOURNON | 08:26 |
| Re: Triggers | BenLaKnet | 09:11 |
| Re: Insert into | Gabriel Dovalo Carril | 10:15 |
| problem with function trigger | jclaudio | 11:00 |
| problem with function trigger | jclaudio | 13:42 |
| Problems with postgresql 7.4.1 configuration - URGENT | beyaRecords - The home Urban music | 14:05 |
| Email function using c instead of tclu | beyaRecords - The home Urban music | 14:19 |