Discussion for users on SQL related matters.
| Thread | Author | Time |
|---|---|---|
| Can i force deletion of dependent rows? | Shruthi A | 06:11 |
| Re: Can i force deletion of dependent rows? | Tim Landscheidt | 07:05 |
| Re: Can i force deletion of dependent rows? | Wayne E. Seguin | 11:23 |
| Re: Can i force deletion of dependent rows? | Shoaib Mir | 11:32 |
| Re: Can i force deletion of dependent rows? | Shruthi A | 17:25 |
| Re: Can i force deletion of dependent rows? | Tim Landscheidt | 22:45 |
| Thread | Author | Time |
|---|---|---|
| Re: Can i force deletion of dependent rows? | Rob Sargent | 19:04 |
| Thread | Author | Time |
|---|---|---|
| UNION or LEFT JOIN? | Louis-David Mitterrand | 14:08 |
| Re: UNION or LEFT JOIN? | Oliveiros | 15:33 |
| Re: UNION or LEFT JOIN? | Louis-David Mitterrand | 21:02 |
| Re: UNION or LEFT JOIN? | Tim Landscheidt | 21:38 |
| Re: UNION or LEFT JOIN? | Louis-David Mitterrand | 21:43 |
| Thread | Author | Time |
|---|---|---|
| very frustrating feature-bug | silly sad | 07:20 |
| Re: very frustrating feature-bug | Jasen Betts | 10:51 |
| Re: very frustrating feature-bug | silly sad | 11:34 |
| Re: very frustrating feature-bug | Pavel Stehule | 11:37 |
| Referencing external table in update/insert triggers | Amitabh Kant | 15:18 |
| Re: very frustrating feature-bug | Tom Lane | 15:27 |
| Re: very frustrating feature-bug | Achilleas Mantzios | 15:33 |
| Thread | Author | Time |
|---|---|---|
| Re: Referencing external table in update/insert triggers | Richard Huxton | 09:23 |
| Re: Referencing external table in update/insert triggers | Amitabh Kant | 09:33 |
| Problem with batch insert | zkn | 12:53 |
| Re: Problem with batch insert | Tom Lane | 15:32 |
| Re: Problem with batch insert | zkn | 16:05 |
| Thread | Author | Time |
|---|---|---|
| sintax error | iuri de araujo sampaio | 07:52 |
| Unable to get UPDATE ... FROM syntax correct | Gordon Ross | 09:25 |
| Re: Unable to get UPDATE ... FROM syntax correct | zkn | 10:28 |
| Re: Unable to get UPDATE ... FROM syntax correct | Gordon Ross | 10:32 |
| Re: Unable to get UPDATE ... FROM syntax correct | Richard Huxton | 10:36 |
| Re: sintax error | Richard Huxton | 10:56 |
| Re: Unable to get UPDATE ... FROM syntax correct | Gordon Ross | 10:58 |
| Re: Unable to get UPDATE ... FROM syntax correct | Richard Huxton | 11:33 |
| Re: sintax error | Tom Lane | 14:28 |
| Thread | Author | Time |
|---|---|---|
| Join Advice and Assistance | Gary Chambers | 23:25 |
| Thread | Author | Time |
|---|---|---|
| Re: Join Advice and Assistance | Rob Sargent | 05:10 |
| Re: Join Advice and Assistance | Gary Chambers | 15:51 |
| Re: Join Advice and Assistance | Rob Sargent | 17:05 |
| Re: Join Advice and Assistance | Stephen Belcher | 17:15 |
| Re: Join Advice and Assistance | Gary Chambers | 22:43 |
| Thread | Author | Time |
|---|---|---|
| join with an array | Louis-David Mitterrand | 12:40 |
| Re: join with an array | A. Kretschmer | 13:09 |
| Re: join with an array | Louis-David Mitterrand | 13:34 |
| Microsoft Sync Framework | Ricardo S. Carvalho | 13:42 |
| Re: join with an array | Achilleas Mantzios | 14:39 |
| Thread | Author | Time |
|---|---|---|
| Using new.id in the WHERE condition of one UPDATE inside ON INSERT rule | Aron | 15:19 |
| Re: Using new.id in the WHERE condition of one UPDATE inside ON INSERT rule | Tom Lane | 15:28 |
| Thread | Author | Time |
|---|---|---|
| what exactly is a query structure? | silly sad | 06:50 |
| Re: what exactly is a query structure? | A. Kretschmer | 07:19 |
| Re: what exactly is a query structure? | silly sad | 09:42 |
| Re: what exactly is a query structure? | silly sad | 09:44 |
| Re: what exactly is a query structure? | A. Kretschmer | 09:53 |
| Re: what exactly is a query structure? | Tom Lane | 15:11 |
| Thread | Author | Time |
|---|---|---|
| Date comparison, user defined operators and magic | Petru Ghita | 03:08 |
| Re: Date comparison, user defined operators and magic | Tom Lane | 03:32 |
| Issue with insert | Michael Gould | 17:14 |
| Re: Issue with insert | Scott Marlowe | 17:50 |
| Re: Issue with insert | Michael Gould | 20:25 |
| Re: Issue with insert | Tom Lane | 20:58 |
| Re: Issue with insert | Michael Gould | 21:02 |
| Thread | Author | Time |
|---|---|---|
| kind of RULE on SELECT depending on existence of a WHERE condition | rawi | 10:07 |
| Re: kind of RULE on SELECT depending on existence of a WHERE condition | Richard Huxton | 10:34 |
| Re: kind of RULE on SELECT depending on existence of a WHERE condition | rawi | 12:16 |
| placement of stored procedures and contrib modules | Michael Gould | 13:25 |
| Re: kind of RULE on SELECT depending on existence of a WHERE condition | Richard Huxton | 13:38 |
| Re: Using new.id in the WHERE condition of one UPDATE inside ON INSERT rule | Aron | 16:30 |
| Create functions using a function | Gianvito Pio | 21:50 |
| Re: Create functions using a function | Petru Ghita | 22:38 |
| Thread | Author | Time |
|---|---|---|
| Trigger on select :-( 📎 | Ray Madigan | 02:10 |
| Re: kind of RULE on SELECT depending on existence of a WHERE condition | rawi | 09:43 |
| Re: kind of RULE on SELECT depending on existence of a WHERE condition | Craig Ringer | 12:07 |
| determine the curval() of a view | John | 15:35 |
| Thread | Author | Time |
|---|---|---|
| Deleting rows from a table not contained in another table | Florian Weimer | 10:51 |
| an aggregate to return max() - 1 value? | Louis-David Mitterrand | 20:09 |
| Re: an aggregate to return max() - 1 value? | Gerardo Herzig | 20:14 |
| Re: an aggregate to return max() - 1 value? | Rob Sargent | 20:20 |
| Re: an aggregate to return max() - 1 value? | Greg Stark | 20:53 |
| Thread | Author | Time |
|---|---|---|
| Re: an aggregate to return max() - 1 value? | Pavel Stehule | 06:33 |
| PostgreSQL Active-Active Configuration | Dave Clements | 07:25 |
| Re: PostgreSQL Active-Active Configuration | Iñigo Martinez Lasala | 08:20 |
| Re: PostgreSQL Active-Active Configuration | Devrim GÜNDÜZ | 08:25 |
| client_timezone to server_timezone and reverse | silly sad | 11:45 |
| Re: [SQL] PostgreSQL Active-Active Configuration | Plugge, Joe R. | 13:58 |
| Thread | Author | Time |
|---|---|---|
| Does IMMUTABLE property propagate? | Petru Ghita | 02:44 |
| Re: Create functions using a function | Jasen Betts | 07:55 |
| Re: Does IMMUTABLE property propagate? | Jasen Betts | 08:02 |
| Check type compatibility | Gianvito Pio | 11:04 |
| Re: Check type compatibility | Nilesh Govindarajan | 11:22 |
| Re: Check type compatibility | Little, Douglas | 13:21 |
| Re: an aggregate to return max() - 1 value? | Louis-David Mitterrand | 13:31 |
| Re: Does IMMUTABLE property propagate? | Greg Stark | 14:45 |
| Assigning NEW. anomoly | Little, Douglas | 16:16 |
| Re: Does IMMUTABLE property propagate? | Petru Ghita | 16:16 |
| Drop all constraints | Gianvito Pio | 16:34 |
| Re: Drop all constraints | Andreas Kretschmer | 17:17 |
| Re: Does IMMUTABLE property propagate? | Tom Lane | 21:31 |
| Thread | Author | Time |
|---|---|---|
| list of all months | query | 12:25 |
| Thread | Author | Time |
|---|---|---|
| Re: Help : insert a bytea data into new table | Ben Morrow | 03:46 |
| Re: Help : insert a bytea data into new table | dennis | 07:45 |
| Re: Help : insert a bytea data into new table | Ben Morrow | 11:14 |
| Odd query behavior | Dan McFadyen | 14:08 |
| Thread | Author | Time |
|---|---|---|
| Re: Help : insert a bytea data into new table | dennis | 02:43 |
| Clarification With Money data type | Navanethan Muthusamy | 07:19 |
| Remote monitoring of Postgres w/minimal grants | Bryce Nesbitt | 07:26 |
| Re: Help : insert a bytea data into new table | Ben Morrow | 15:25 |
| Thread | Author | Time |
|---|---|---|
| Re: Help : insert a bytea data into new table | dennis | 04:09 |
| Re: Clarification With Money data type | Jasen Betts | 08:49 |
| Re: Help : insert a bytea data into new table | Ben Morrow | 11:46 |
| Selecting names of indexes that are not dependent on constraints. | Dmitriy Igrishin | 15:15 |
| Re: Selecting names of indexes that are not dependent on constraints. | Dmitriy Igrishin | 15:20 |
| Re: Selecting names of indexes that are not dependent on constraints. | Tom Lane | 15:34 |
| Re: Help : insert a bytea data into new table | dennis | 16:07 |
| Re: Trigger on select :-( | Garrett Murphy | 16:33 |
| Re: Help : insert a bytea data into new table | Ben Morrow | 18:00 |
| Re: Remote monitoring of Postgres w/minimal grants | Tony Wasson | 22:20 |
| Thread | Author | Time |
|---|---|---|
| Re: Trigger on select :-( | Jaime Casanova | 06:56 |
| Re: Clarification With Money data type 📎 | Ireneusz Pluta | 08:10 |
| Odd query behavior | Dan McFadyen | 15:41 |
| Re: Odd query behavior | Rob Sargent | 16:06 |
| Re: Odd query behavior | Tom Lane | 16:29 |
| Thread | Author | Time |
|---|---|---|
| Private functions | Gianvito Pio | 17:57 |
| Re: Private functions | Pavel Stehule | 18:00 |
| Thread | Author | Time |
|---|---|---|
| Re: Private functions | Jasen Betts | 03:21 |
| Linked list with CTE | Mark Lubratt | 23:51 |
| Thread | Author | Time |
|---|---|---|
| Re: Private functions | silly sad | 06:25 |
| Re: Odd query behavior | silly sad | 11:27 |
| Re: Odd query behavior | Tom Lane | 15:03 |
| Re: Odd query behavior | Dan McFadyen | 17:01 |
| Re: Odd query behavior | Tom Lane | 17:14 |
| Please delete my email | Eduardo Palafox | 17:18 |
| Remove my e-mail | Daniel Guedes | 17:24 |
| Re: Please delete my email | Adrian Klaver | 17:29 |
| Re: Remove my e-mail | Adrian Klaver | 17:29 |
| I, nead to capture the IP number from the PC how is running the script ... | John Dizaro | 19:18 |
| Re: I, nead to capture the IP number from the PC how is running the script ... | Niklas Johansson | 19:41 |
| Re: I, nead to capture the IP number from the PC how is running the script ... | Ing. Marcos Ortiz Valmaseda | 20:19 |
| Re: I, nead to capture the IP number from the PC how is running the script ... | Gerardo Herzig | 20:40 |
| Re: list of all months | Garrett Murphy | 21:16 |
| Re: list of all months | Petru Ghita | 21:41 |
| Re: list of all months | Dawid Kuroczko | 22:25 |
| installing uuid generators | Rob Sargent | 23:58 |