Discussion for users on SQL related matters.
| Thread | Author | Time |
|---|---|---|
| how to do this query | Wes James | 04:26 |
| Re: how to do this query | Ian Barwick | 09:07 |
| Re: how to do this query | msi77 | 11:36 |
| Re: how to do this query | msi77 | 22:52 |
| Thread | Author | Time |
|---|---|---|
| problem using regexp_replace | gherzig | 00:29 |
| Re: problem using regexp_replace | Jasen Betts | 08:28 |
| Re: problem using regexp_replace | gherzig | 10:33 |
| CHECK constraint removing brackets | Andy Shellam | 19:49 |
| Re: CHECK constraint removing brackets | Scott Marlowe | 20:14 |
| Re: CHECK constraint removing brackets | Tom Lane | 20:15 |
| Re: CHECK constraint removing brackets | Andy Shellam | 23:27 |
| Thread | Author | Time |
|---|---|---|
| Re: CHECK constraint removing brackets | Tom Lane | 00:10 |
| Re: problem using regexp_replace | Jasen Betts | 12:10 |
| Re: problem using regexp_replace | gherzig | 16:17 |
| Thread | Author | Time |
|---|---|---|
| rename primary key | Seb | 03:28 |
| Re: rename primary key | Ian Barwick | 03:34 |
| Re: rename primary key | Seb | 03:39 |
| Re: rename primary key | Guillaume Lelarge | 06:35 |
| indexes | Seb | 16:04 |
| Re: rename primary key | Seb | 16:13 |
| Thread | Author | Time |
|---|---|---|
| Re: indexes | Chris | 21:59 |
| Thread | Author | Time |
|---|---|---|
| Re: indexes | Seb | 01:10 |
| Re: indexes | Craig Ringer | 01:22 |
| Thread | Author | Time |
|---|---|---|
| How to cascade information like the user roles ? | Andreas | 00:33 |
| Re: How to cascade information like the user roles ? | Filip Rembiałkowski | 14:27 |
| Re: How to cascade information like the user roles ? | Andreas | 16:47 |
| Thread | Author | Time |
|---|---|---|
| Re: How to cascade information like the user roles ? 📎 | Gurjeet Singh | 05:45 |
| Re: How to cascade information like the user roles ? | Gurjeet Singh | 06:23 |
| Re: How to cascade information like the user roles ? | Andreas | 16:43 |
| Thread | Author | Time |
|---|---|---|
| Error while vacuumdb | Otniel Michael | 05:05 |
| Thread | Author | Time |
|---|---|---|
| Re: How to cascade information like the user roles ? | Gurjeet Singh | 12:25 |
| Thread | Author | Time |
|---|---|---|
| clock command regression in pltcl? | Kyle Bateman | 04:41 |
| Re: clock command regression in pltcl? | Tom Lane | 06:26 |
| Re: clock command regression in pltcl? | Tom Lane | 06:50 |
| Thread | Author | Time |
|---|---|---|
| Re: clock command regression in pltcl? | Tom Lane | 02:17 |
| Thread | Author | Time |
|---|---|---|
| Re: rename primary key | Guillaume Lelarge | 14:19 |
| Thread | Author | Time |
|---|---|---|
| Partitioning by letter question | John Lister | 22:24 |
| Re: Partitioning by letter question | Scott Marlowe | 23:50 |
| Thread | Author | Time |
|---|---|---|
| Re: Partitioning by letter question | John Lister | 15:04 |
| Re: Partitioning by letter question | Scott Marlowe | 16:32 |
| Thread | Author | Time |
|---|---|---|
| Howto have a unique restraint on UPPER (textfield) | Andreas | 02:26 |
| Re: Howto have a unique restraint on UPPER (textfield) | Joshua Tolley | 02:56 |
| Re: Howto have a unique restraint on UPPER (textfield) | msi77 | 08:02 |
| Re: Howto have a unique restraint on UPPER (textfield) | Andreas | 20:48 |
| Re: Howto have a unique restraint on UPPER (textfield) | Tom Lane | 21:07 |
| Thread | Author | Time |
|---|---|---|
| please help me on regular expression | Tena Sakai | 19:22 |
| Re: please help me on regular expression | Pavel Stehule | 20:38 |
| Re: please help me on regular expression | Tena Sakai | 23:16 |
| Thread | Author | Time |
|---|---|---|
| Re: please help me on regular expression | msi77 | 11:38 |
| Re: please help me on regular expression | Tena Sakai | 16:35 |
| Re: please help me on regular expression | Dirk Jagdmann | 19:43 |
| Re: please help me on regular expression | Tena Sakai | 20:32 |
| Re: please help me on regular expression | Lars Gustafsson | 21:33 |
| Thread | Author | Time |
|---|---|---|
| Partitioning improvements query | John Lister | 21:59 |
| Thread | Author | Time |
|---|---|---|
| Re: Howto have a unique restraint on UPPER (textfield) | Yeb Havinga | 20:57 |
| Thread | Author | Time |
|---|---|---|
| 'image' table with relationships to different objects | Louis-David Mitterrand | 07:49 |
| Re: 'image' table with relationships to different objects | Michael Lourant | 11:34 |
| Re: 'image' table with relationships to different objects | Richard Huxton | 11:59 |
| Re: 'image' table with relationships to different objects | Rob Sargent | 15:01 |
| Re: 'image' table with relationships to different objects | Louis-David Mitterrand | 19:41 |
| Thread | Author | Time |
|---|---|---|
| plpgsql loop question | Andrea Visinoni | 16:29 |
| Re: plpgsql loop question | Justin Graf | 17:16 |
| Re: 'image' table with relationships to different objects | Louis-David Mitterrand | 17:29 |
| Re: 'image' table with relationships to different objects | Justin Graf | 19:07 |
| Re: plpgsql loop question | Adrian Klaver | 20:56 |
| Thread | Author | Time |
|---|---|---|
| Re: 'image' table with relationships to different objects | Jasen Betts | 11:05 |
| Thread | Author | Time |
|---|---|---|
| "left join" not working? | Louis-David Mitterrand | 11:14 |
| Re: "left join" not working? | Oliveiros C, | 11:35 |
| Re: "left join" not working? | msi77 | 11:57 |
| Re: "left join" not working? | Louis-David Mitterrand | 11:57 |
| Re: "left join" not working? | Oliveiros C, | 12:17 |
| complex join question | Louis-David Mitterrand | 22:32 |
| Re: complex join question | Tim Landscheidt | 23:55 |
| 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 |