Discussion for users on SQL related matters.
| Thread | Author | Time |
|---|---|---|
| time of constraint checking | Markus Bertheau | 15:58 |
| Re: time of constraint checking | Markus Bertheau | 16:16 |
| Re: time of constraint checking | Stephan Szabo | 16:56 |
| "copy from" in "create function" | Gifford Hesketh | 22:03 |
| Thread | Author | Time |
|---|---|---|
| Re: Reuse previously calculated column in sql query? | Iain | 01:31 |
| Offtopic: psql | sad | 11:58 |
| Re: Offtopic: psql | Achilleus Mantzios | 12:35 |
| Re: Aggregate Function with Argument | David Siegal | 15:26 |
| Finding duplicated values | Kent Anderson | 18:58 |
| Re: Finding duplicated values | Bricklen | 19:20 |
| Re: Finding duplicated values | Stephan Szabo | 20:09 |
| Trouble with explicit joins | Dmitry Tkach | 22:44 |
| Re: Finding duplicated values | lorid | 23:18 |
| Re: Trouble with explicit joins | Tom Lane | 23:32 |
| Re: Trouble with explicit joins | Dmitry Tkach | 23:36 |
| Thread | Author | Time |
|---|---|---|
| Question on the 8.0Beta Version | Davide Negri | 06:59 |
| Re: Finding duplicated values | Christoph Haller | 07:49 |
| now() + integer, not rounded to whole day | JN | 12:04 |
| Re: Functions return a select in a table, which data type I | Markus Bertheau | 13:38 |
| Log | Davide Negri | 13:52 |
| Thread | Author | Time |
|---|---|---|
| Re: Question on the 8.0Beta Version | Gaetano Mendola | 22:08 |
| Thread | Author | Time |
|---|---|---|
| Re: [GENERAL] Question on the 8.0Beta Version | Scott Marlowe | 01:06 |
| Re: Log | Scott Marlowe | 01:08 |
| Re: Question on the 8.0Beta Version | Harald Armin Massa | 10:19 |
| Thread | Author | Time |
|---|---|---|
| Create interval using column value? | Larry Lennhoff | 02:54 |
| Re: Create interval using column value? | Tom Lane | 03:11 |
| Re: Create interval using column value? | Michael Glaesemann | 03:13 |
| Re: Create interval using column value? | Larry Lennhoff | 03:18 |
| sql | cristivoinicaru | 08:13 |
| Re: Cross tabulations | Muhyiddin A.M Hayat | 08:49 |
| Re: now() + integer, not rounded to whole day | JN | 09:27 |
| Re: sql | Andrei Bintintan | 10:04 |
| Re: bibliographic schema | James Cloos | 10:36 |
| Re: sql | Mike Rylander | 11:20 |
| Re: sql | Andrew J. Kopciuch | 11:44 |
| Re: sql | Mike Rylander | 13:05 |
| Re: now() + integer, not rounded to whole day | Bruno Wolff III | 16:32 |
| Re: "copy from" in "create function" | Jan Wieck | 17:19 |
| plpgsql: PERFORM vs. SELECT INTO (PERFORM not setting FOUND variable?) | Marinos Yannikos | 19:44 |
| Re: plpgsql: PERFORM vs. SELECT INTO (PERFORM not setting FOUND variable?) | Tom Lane | 20:02 |
| Re: plpgsql: PERFORM vs. SELECT INTO (PERFORM not setting FOUND | Edmund Bacon | 20:08 |
| Thread | Author | Time |
|---|---|---|
| Re: [HACKERS] Question on the 8.0Beta Version | Adrian Maier | 06:13 |
| How to recognize trigger-inserted rows? | Jeff Boes | 16:27 |
| How to recognize trigger-inserted rows? | Jeff Boes | 17:00 |
| How to re-sort a sorted query? | Yudie | 19:23 |
| How do you compare (NULL) and (non-NULL)? | Wei Weng | 20:23 |
| Re: How to re-sort a sorted query? | Oliver Elphick | 20:34 |
| Re: How do you compare (NULL) and (non-NULL)? | Stephan Szabo | 20:48 |
| Re: How do you compare (NULL) and (non-NULL)? | Jerome Alet | 21:01 |
| Re: How to re-sort a sorted query? | Yudie | 21:32 |
| Re: How to re-sort a sorted query? | Tom Lane | 21:43 |
| Re: How to re-sort a sorted query? | Oliver Elphick | 21:57 |
| Thread | Author | Time |
|---|---|---|
| JOIN not being calculated correctly | Scott Pederick | 11:02 |
| RULE and default nextval() column | Dmitry P. Ovechkin | 13:19 |
| Re: RULE and default nextval() column | Stephan Szabo | 14:11 |
| Foreign Key Non-Null Problem in 8.0 | Jon Uhal | 15:09 |
| Re: How to re-sort a sorted query? | Yudie | 15:30 |
| Re: How do you compare (NULL) and (non-NULL)? | Bruno Wolff III | 15:36 |
| Thread | Author | Time |
|---|---|---|
| Select Instead on a table | Markus Schaber | 10:03 |
| curious delay on view/where | Gary Stainburn | 10:16 |
| Re: extra info - curious delay on view/where | Gary Stainburn | 10:42 |
| Re: Select Instead on a table | Tom Lane | 14:22 |
| Re: curious delay on view/where | Tom Lane | 14:25 |
| Re: extra info - curious delay on view/where | andre.toscano | 14:53 |
| Re: curious delay on view/where | Gary Stainburn | 15:01 |
| Re: ORDER BY and NULLs | Murphy Pope | 16:52 |
| Re: Select Instead on a table | Markus Schaber | 16:58 |
| Re: ORDER BY and NULLs | Murphy Pope | 18:36 |
| Thread | Author | Time |
|---|---|---|
| Re: Functions return a select in a table, which data type I | Markus Bertheau | 09:08 |
| paertially restoring a DB | Niall Linden | 14:04 |
| Re: How do you compare (NULL) and (non-NULL)? | Wei Weng | 15:59 |
| Re: extra info - curious delay on view/where | Markus Schaber | 17:46 |
| Re: How do you compare (NULL) and (non-NULL)? | Bruno Wolff III | 17:57 |
| Thread | Author | Time |
|---|---|---|
| Re: ORDER BY and NULLs | Murphy Pope | 00:00 |
| Re: Foreign Key Non-Null Problem in 8.0 | Stephan Szabo | 06:22 |
| Thread | Author | Time |
|---|---|---|
| Re: paertially restoring a DB | Iain | 05:51 |
| 'show databases' in psql way? | Erik Wasser | 12:13 |
| Re: 'show databases' in psql way? | Frank Bax | 12:23 |
| Re: 'show databases' in psql way? | Ian Barwick | 12:26 |
| Re: 'show databases' in psql way? | Erik Wasser | 12:33 |
| Join Table | T E Schmitz | 16:34 |
| Re: Join Table | Michael Fuhr | 17:03 |
| Re: Join Table | Tom Lane | 17:07 |
| Re: Join Table | Richard Huxton | 17:08 |
| Re: Join Table | T E Schmitz | 18:12 |
| Re: Join Table | Mischa Sandberg | 19:55 |
| Thread | Author | Time |
|---|---|---|
| Re: 'show databases' in psql way? | Greg Sabino Mullane | 03:40 |
| Re: Join Table | Michael Fuhr | 04:22 |
| Update instead rules on Views | Markus Schaber | 12:05 |
| Re: 'show databases' in psql way? | lorid | 14:24 |
| Re: 'show databases' in psql way? | Arash Zaryoun | 15:03 |
| Re: Update instead rules on Views | Markus Schaber | 15:20 |
| Re: 'show databases' in psql way? | Achilleus Mantzios | 15:21 |
| Re: Update instead rules on Views | Markus Schaber | 15:42 |
| query using a date field that isn't set | John B. Scalia | 15:44 |
| Re: JOIN not being calculated correctly | Andrew Hammond | 18:46 |
| Re: [SQL] Log | Andrew Hammond | 18:56 |
| third edition of SQL FOR SMARTIES | --CELKO-- | 19:36 |
| Thread | Author | Time |
|---|---|---|
| vacuum analyze slows sql query | patrick ~ | 02:50 |
| Insert/Update Perl Function involving two tables needing to by 'in sync' | Ferindo Middleton Jr | 03:26 |
| Re: 'show databases' in psql way? | Greg Sabino Mullane | 03:46 |
| Re: vacuum analyze slows sql query | Andrew Sullivan | 12:01 |
| Re: vacuum analyze slows sql query | Jim Buttafuoco | 13:31 |
| trigger status | hook | 14:57 |
| Re: trigger status | Michael Fuhr | 15:33 |
| CREATE TYPE | Ameen - Etemady | 15:56 |
| Re: CREATE TYPE | Jeff | 16:23 |
| Re: vacuum analyze slows sql query | patrick ~ | 18:31 |
| Re: vacuum analyze slows sql query | Andrew Sullivan | 18:45 |
| Re: vacuum analyze slows sql query | Greg Stark | 19:20 |
| oracle v$session equivalent in postgresql | stuff | 20:06 |
| Thread | Author | Time |
|---|---|---|
| Re: CREATE TYPE | sad | 06:30 |
| Group by and aggregates | Michael L. Hostbaek | 16:54 |
| Delayed result from another connection | SZŰCS Gábor | 17:19 |
| Re: Group by and aggregates | Sam Mason | 17:25 |
| Re: Group by and aggregates | Michael Fuhr | 17:31 |
| Re: Group by and aggregates | Edmund Bacon | 17:34 |
| Re: Group by and aggregates | Franco Bruno Borghesi | 17:41 |
| Re: Delayed result from another connection | Tom Lane | 17:46 |
| Re: Group by and aggregates | Oliver Elphick | 17:46 |
| CREATE TRIGGER ... FOR EACH STATEMENT | Mischa Sandberg | 22:16 |
| Thread | Author | Time |
|---|---|---|
| Re: CREATE TRIGGER ... FOR EACH STATEMENT | Mischa Sandberg | 03:27 |
| Re: Delayed result from another connection | SZŰCS Gábor | 13:29 |
| sql problem | Flavio Fonseca | 14:34 |
| Help in stored procedure | Igor Maciel Macaubas | 14:35 |
| Re: Group by and aggregates | Michael L. Hostbaek | 14:51 |
| Killed backend won't rollback transaction? | SZŰCS Gábor | 14:52 |
| Oracle to Postgres | Mickael Faivre-Macon | 15:12 |
| Re: Help in stored procedure | Thomas F.O'Connell | 15:13 |
| oracle v$session equivalent in postgresql | stuff | 15:27 |
| Re: Delayed result from another connection | Tom Lane | 15:53 |
| Re: Killed backend won't rollback transaction? | Tom Lane | 16:02 |
| Re: sql problem | Achilleus Mantzios | 16:50 |
| Simple SQL Question | Andras Kutrovics | 16:54 |
| Scheduling Jobs In PostgreSQL | Chethana Kuloor | 17:05 |
| Re: Simple SQL Question | Bricklen | 17:13 |
| Re: Simple SQL Question | Franco Bruno Borghesi | 18:09 |
| Re: Simple SQL Question | Tomasz Myrta | 18:09 |
| Re: oracle v$session equivalent in postgresql | Ian Barwick | 19:53 |
| Thread | Author | Time |
|---|---|---|
| Re: Simple SQL Question | Greg Stark | 08:17 |
| Thread | Author | Time |
|---|---|---|
| Hi | vasundhar | 06:45 |
| tricky GROUP BY / JOIN question | T E Schmitz | 10:31 |
| Re: tricky GROUP BY / JOIN question | Tom Lane | 18:31 |
| Thread | Author | Time |
|---|---|---|
| Re: query using a date field that isn't set | D'Arcy J.M. Cain | 01:56 |
| Re: third edition of SQL FOR SMARTIES | D'Arcy J.M. Cain | 02:03 |
| Re: Scheduling Jobs In PostgreSQL | Michael Fuhr | 03:25 |
| Re: Scheduling Jobs In PostgreSQL | Christopher Browne | 04:17 |
| how to use COPY within plperl | Marek Lewczuk | 08:59 |
| Re: Scheduling Jobs In PostgreSQL | Kaare Rasmussen | 09:36 |
| Re: Killed backend won't rollback transaction? | SZŰCS Gábor | 14:21 |
| Re: Hi | Steven Klassen | 15:57 |
| Re: how to use COPY within plperl | Goutam Paruchuri | 19:04 |
| Re: how to use COPY within plperl | Marek Lewczuk | 19:14 |
| Job opportunity | Kyle | 23:29 |