Discussion for users on SQL related matters.
| Thread | Author | Time |
|---|---|---|
| self join issue | Ed Rouse | 20:41 |
| Thread | Author | Time |
|---|---|---|
| Re: self join issue | David G. Johnston | 15:18 |
| EnterpriseDB: PostgreSql 9.4 Where is the Language Pack Installer? | Stephen Tahmosh | 15:19 |
| Re: EnterpriseDB: PostgreSql 9.4 Where is the Language Pack Installer? | Stephen Tahmosh | 15:34 |
| Thread | Author | Time |
|---|---|---|
| 3 foreign keys in 1 table for 3 1-to-many relations? | gvim | 00:51 |
| Re: 3 foreign keys in 1 table for 3 1-to-many relations? | David G. Johnston | 01:30 |
| Re: self join issue | Marc Mamin | 19:45 |
| Thread | Author | Time |
|---|---|---|
| Re: extracting PII data and transforming it across table. | Suresh Raja | 21:09 |
| Run analyze on schema | Suresh Raja | 21:10 |
| Re: Run analyze on schema | Jerry Sievers | 23:53 |
| Thread | Author | Time |
|---|---|---|
| Re: [GENERAL] Run analyze on schema | Suresh Raja | 03:34 |
| Thread | Author | Time |
|---|---|---|
| Disable Trigger for session only | gmb | 07:43 |
| Re: Disable Trigger for session only | Adrian Klaver | 13:06 |
| Re: Disable Trigger for session only | gmb | 14:13 |
| Re: Disable Trigger for session only | Adrian Klaver | 14:26 |
| Re: Disable Trigger for session only | Greg Sabino Mullane | 20:34 |
| Re: Disable Trigger for session only | Adrian Klaver | 20:43 |
| Thread | Author | Time |
|---|---|---|
| Re: Disable Trigger for session only | gmb | 07:17 |
| Re: Disable Trigger for session only | gmb | 08:31 |
| Thread | Author | Time |
|---|---|---|
| [C#] File Upload to PostgreSQL | drunken | 08:10 |
| Re: [C#] File Upload to PostgreSQL | David G. Johnston | 12:17 |
| Thread | Author | Time |
|---|---|---|
| PGSQL-Performance mailing list | John Sherwood | 10:52 |
| Thread | Author | Time |
|---|---|---|
| Re: Help with 'contestant' query | Greg Sabino Mullane | 19:36 |
| Thread | Author | Time |
|---|---|---|
| Backups failing despite many settings that should prevent it | John Sherwood | 13:35 |
| Re: Backups failing despite many settings that should prevent it | Tom Lane | 14:28 |
| Thread | Author | Time |
|---|---|---|
| Oracle to PostgreSQL Migration - Need Information | Tim Clotworthy | 16:30 |
| Re: Oracle to PostgreSQL Migration - Need Information | [email protected] | 18:21 |
| encrypt psql password in unix script | Suresh Raja | 18:34 |
| Re: encrypt psql password in unix script | John R Pierce | 18:46 |
| Re: encrypt psql password in unix script | Steve Midgley | 19:01 |
| Re: encrypt psql password in unix script | Vick Khera | 19:06 |
| Re: [SQL] encrypt psql password in unix script | Xavier Stevens | 19:08 |
| Re: [SQL] encrypt psql password in unix script | John R Pierce | 19:20 |
| Thread | Author | Time |
|---|---|---|
| decode double slash octal | 06:29 | |
| Octal to UTF-8 | 09:21 | |
| Re: Octal to UTF-8 | Vinayak | 09:35 |
| Strange DOMAIN behavior | Alex Ignatov | 10:03 |
| Strange DOMAIN behavior | David G. Johnston | 12:49 |
| Re: Strange DOMAIN behavior | Alex Ignatov | 14:10 |
| Re: Strange DOMAIN behavior | David G. Johnston | 14:23 |
| Re: Strange DOMAIN behavior | Alex Ignatov | 16:42 |
| Re: Strange DOMAIN behavior | David G. Johnston | 16:50 |
| Re: Strange DOMAIN behavior | Alex Ignatov | 17:28 |
| How to insert a carriage return and line field between fields in a query | JORGE MALDONADO | 23:10 |
| Re: How to insert a carriage return and line field between fields in a query | David G. Johnston | 23:18 |
| Thread | Author | Time |
|---|---|---|
| User defined exceptions | Alex Ignatov | 14:10 |
| Re: User defined exceptions | David G. Johnston | 14:22 |
| Re: User defined exceptions | Pavel Stehule | 15:54 |
| Thread | Author | Time |
|---|---|---|
| Re: User defined exceptions | Alexey Bashtanov | 07:34 |
| Re: User defined exceptions | Alexey Bashtanov | 07:36 |
| Re: User defined exceptions | Alex Ignatov | 15:31 |
| Thread | Author | Time |
|---|---|---|
| Getting the list of foreign keys (for deleting data from the database) | Mario Splivalo | 15:04 |
| Re: Getting the list of foreign keys (for deleting data from the database) | Thomas Kellerer | 15:20 |
| Re: Getting the list of foreign keys (for deleting data from the database) | Adrian Klaver | 15:25 |
| Re: Getting the list of foreign keys (for deleting data from the database) | Mario Splivalo | 15:44 |
| Re: Re: Getting the list of foreign keys (for deleting data from the database) | Mario Splivalo | 15:48 |
| Thread | Author | Time |
|---|---|---|
| Stored Procedure to return resultset from multiple delete statements. | Jason Aleski | 03:54 |
| Re: Stored Procedure to return resultset from multiple delete statements. | David G. Johnston | 05:21 |
| Thread | Author | Time |
|---|---|---|
| Sales report by month and item category | Richard RK. Klingler | 16:16 |
| IP address, subnet query behaves wrong for /32 | Richard RK. Klingler | 16:47 |
| Re: IP address, subnet query behaves wrong for /32 | David G. Johnston | 17:01 |
| Re: IP address, subnet query behaves wrong for /32 | Adrian Klaver | 17:02 |
| Re: IP address, subnet query behaves wrong for /32 | David G. Johnston | 17:07 |
| Re: IP address, subnet query behaves wrong for /32 | Tom Lane | 19:10 |
| Re: IP address, subnet query behaves wrong for /32 | Richard RK. Klingler | 19:35 |
| Re: IP address, subnet query behaves wrong for /32 | [email protected] | 19:45 |
| Re: IP address, subnet query behaves wrong for /32 | Adrian Klaver | 19:53 |
| Re: Sales report by month and item category | Steve Midgley | 21:36 |
| Thread | Author | Time |
|---|---|---|
| ERROR: cache lookup failed for type | Stuart | 00:58 |
| Re: ERROR: cache lookup failed for type | Adrian Klaver | 01:17 |
| Re: ERROR: cache lookup failed for type | Tom Lane | 03:16 |
| Re: ERROR: cache lookup failed for type | Stuart | 03:52 |
| Re: ERROR: cache lookup failed for type | Stuart | 03:56 |
| Re: ERROR: cache lookup failed for type | Adrian Klaver | 04:08 |
| Re: ERROR: cache lookup failed for type | Stuart | 04:46 |
| Re: ERROR: cache lookup failed for type | Adrian Klaver | 14:11 |
| Re: ERROR: cache lookup failed for type | Stuart | 14:13 |
| Re: IP address, subnet query behaves wrong for /32 | Peter Eisentraut | 14:30 |
| Thread | Author | Time |
|---|---|---|
| WHERE ... NOT NULL ... OR ... (SELECT...) | Mario Splivalo | 21:01 |
| Thread | Author | Time |
|---|---|---|
| Re: WHERE ... NOT NULL ... OR ... (SELECT...) | Dickson S. Guedes | 11:34 |
| Re: WHERE ... NOT NULL ... OR ... (SELECT...) | Mario Splivalo | 12:13 |
| Thread | Author | Time |
|---|---|---|
| Reassign permissions | Amreen Khan | 19:20 |
| Re: Reassign permissions | Rene Romero Benavides | 20:46 |
| Thread | Author | Time |
|---|---|---|
| Showing a cumlative total by month | David Nelson | 14:46 |
| Re: Showing a cumlative total by month | David G. Johnston | 15:15 |
| Re: Showing a cumlative total by month | David Nelson | 15:47 |
| Re: Showing a cumlative total by month | David Nelson | 15:53 |
| Re: Showing a cumlative total by month | David Nelson | 18:15 |
| Thread | Author | Time |
|---|---|---|
| View not using index | gmb | 11:56 |
| Re: View not using index | Brice André | 13:18 |
| Re: View not using index | Igor Neyman | 13:29 |
| Thread | Author | Time |
|---|---|---|
| Re: View not using index | gmb | 04:45 |
| Thread | Author | Time |
|---|---|---|
| Recursive merging of overlapping arrays in a column | dave | 11:12 |
| Re: Recursive merging of overlapping arrays in a column | Rob Sargent | 14:00 |
| Re: Recursive merging of overlapping arrays in a column | dave | 15:57 |
| Re: Recursive merging of overlapping arrays in a column | David G. Johnston | 17:43 |
| Re: Recursive merging of overlapping arrays in a column | dave | 19:40 |
| Thread | Author | Time |
|---|---|---|
| Re: Recursive merging of overlapping arrays in a column | hari.fuchs | 09:45 |
| Re: Recursive merging of overlapping arrays in a column | dave | 12:19 |
| Thread | Author | Time |
|---|---|---|
| problem with regexp_matches in nested funcion | Isaac Marco Blancas | 09:00 |
| problem with regexp_matches in nested funcion | David G. Johnston | 12:36 |
| Re: problem with regexp_matches in nested funcion | Isaac Marco Blancas | 15:11 |
| Thread | Author | Time |
|---|---|---|
| query option in COPY postgres | masyaf | 20:22 |
| Re: query option in COPY postgres | David G. Johnston | 22:02 |
| Re: query option in COPY postgres | Adrian Klaver | 22:40 |
| Re: query option in COPY postgres | masyaf | 22:54 |
| Thread | Author | Time |
|---|---|---|
| Re: query option in COPY postgres | Adrian Klaver | 17:13 |
| Thread | Author | Time |
|---|---|---|
| Exception Handling in Postgis function | ranjitsaurav | 07:35 |
| Thread | Author | Time |
|---|---|---|
| Re: How would I get rid of trailing blank line? | david.paulo | 02:17 |
| Thread | Author | Time |
|---|---|---|
| Need more info on PL/pgSQL compile listing | Michael Moore | 23:29 |
| Thread | Author | Time |
|---|---|---|
| Re: Need more info on PL/pgSQL compile listing | Tom Lane | 00:02 |
| Re: Need more info on PL/pgSQL compile listing | Michael Moore | 00:36 |
| Thread | Author | Time |
|---|---|---|
| plpgsql: how to use a composite type varray | 卢迪 | 08:09 |
| Re: plpgsql: how to use a composite type varray | Alexander Shereshevsky | 09:21 |
| Re: plpgsql: how to use a composite type varray | 卢迪 | 10:23 |
| Re: plpgsql: how to use a composite type varray | Alexander Shereshevsky | 11:24 |
| Re: plpgsql: how to use a composite type varray | 卢迪 | 11:48 |
| Re: plpgsql: how to use a composite type varray | Tom Lane | 15:10 |
| Thread | Author | Time |
|---|---|---|
| Select values by interval | Markus Wolters | 16:37 |
| Re: Select values by interval | David G. Johnston | 16:49 |
| Re: Select values by interval | Andreas Kretschmer | 17:22 |
| Re: Select values by interval | David G. Johnston | 17:25 |
| Re: Select values by interval | Andreas Kretschmer | 17:31 |
| ERROR while creating new user - could not open relation mapping file global/pg_filenode.map | Sribeiro | 19:38 |
| Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map | Adrian Klaver | 20:13 |
| Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map | Sribeiro | 20:23 |
| Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map | Adrian Klaver | 20:36 |
| Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map | Sribeiro | 20:39 |
| Thread | Author | Time |
|---|---|---|
| Re: Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map | Adrian Klaver | 20:23 |
| Thread | Author | Time |
|---|---|---|
| Re: unique constraint definition within create table | Vik Fearing | 06:16 |
| 来自test的邮件 | test | 08:39 |
| Re: unique constraint definition within create table | Andreas Kretschmer | 12:05 |
| call by reference vs call by value | Michael Moore | 19:07 |
| Re: call by reference vs call by value | David G. Johnston | 19:15 |
| How to manually load RETURNS SETOF RECORD? | Michael Moore | 19:34 |
| Re: How to manually load RETURNS SETOF RECORD? | Tom Lane | 19:49 |
| Re: How to manually load RETURNS SETOF RECORD? | Adrian Klaver | 20:14 |
| Re: call by reference vs call by value | Michael Moore | 20:25 |
| Re: call by reference vs call by value | Pavel Stehule | 20:29 |
| Re: call by reference vs call by value | Pavel Stehule | 20:31 |
| Re: How to manually load RETURNS SETOF RECORD? | Michael Moore | 20:42 |
| Re: call by reference vs call by value | Michael Moore | 20:55 |
| Thread | Author | Time |
|---|---|---|
| CVS to In_list without dynamic SQL, how? | Michael Moore | 20:16 |
| Re: CVS to In_list without dynamic SQL, how? | David G. Johnston | 20:19 |
| Re: CVS to In_list without dynamic SQL, how? | Michael Moore | 21:30 |