Discussion for users on SQL related matters.
| Thread | Author | Time |
|---|---|---|
| Want some basic compare of data type on PostgreSQL and MySQL | bhavesh1385 | 05:15 |
| Re: Want some basic compare of data type on PostgreSQL and MySQL | Scott Marlowe | 09:16 |
| Re: Want some basic compare of data type on PostgreSQL and MySQL | Samuel Gendler | 09:38 |
| Re: Want some basic compare of data type on PostgreSQL and MySQL | Jasen Betts | 11:22 |
| Re: Want some basic compare of data type on PostgreSQL and MySQL | Leif Biberg Kristensen | 13:32 |
| Re: Want some basic compare of data type on PostgreSQL and MySQL | Scott Marlowe | 13:45 |
| Schema partitioning | Charlie | 18:13 |
| Thread | Author | Time |
|---|---|---|
| Re: Schema partitioning | David Johnston | 13:20 |
| Re: Schema partitioning | Little, Douglas | 13:22 |
| Thread | Author | Time |
|---|---|---|
| How can I inherit constraints? | Andreas | 01:04 |
| Thread | Author | Time |
|---|---|---|
| My Trigger is not working :( | Waqar Azeem | 12:27 |
| Re: how can I get the length of columns of a table by system tables/views | shuaixf | 12:53 |
| Re: My Trigger is not working :( | pasman pasmański | 13:23 |
| Re: My Trigger is not working :( | Waqar Azeem | 13:31 |
| Thread | Author | Time |
|---|---|---|
| Re: Re: how can I get the length of columns of a table by system tables/views | msi77 | 05:51 |
| Dynamic sql | Gabriel Filipiak | 06:45 |
| Re: Dynamic sql | Jasen Betts | 09:18 |
| FW: Hi | Mandana Mokhtary | 21:22 |
| FW: Hi | Mandana Mokhtary | 21:22 |
| Re: FW: Hi | Adrian Klaver | 22:04 |
| Thread | Author | Time |
|---|---|---|
| Re: FW: Hi | Craig Ringer | 01:31 |
| Use select and update together | Boris | 10:36 |
| Thread | Author | Time |
|---|---|---|
| Re: Use select and update together | pasman pasmański | 05:50 |
| Re: Use select and update together | Samuel Gendler | 06:45 |
| Partition over a sliding date window | Guillaume Roger | 11:25 |
| Window function sort order help | Dianna Harter | 18:04 |
| Re: Window function sort order help | nicoletta maia | 20:53 |
| Thread | Author | Time |
|---|---|---|
| Re: Window function sort order help | Nicoletta Maia | 08:30 |
| Re: Window function sort order help | Thomas Kellerer | 09:02 |
| Re: Window function sort order help | Dianna Harter | 16:54 |
| Re: Window function sort order help | Nicoletta Maia | 17:24 |
| Thread | Author | Time |
|---|---|---|
| Clever way to check overlapping time intervals ? | Andreas | 23:40 |
| Thread | Author | Time |
|---|---|---|
| Re: Clever way to check overlapping time intervals ? | Andreas Kretschmer | 00:15 |
| Re: Clever way to check overlapping time intervals ? | pasman pasmański | 09:17 |
| Re: Clever way to check overlapping time intervals ? | Frank Bax | 11:15 |
| Re: Window function sort order help | Tim Landscheidt | 23:55 |
| Thread | Author | Time |
|---|---|---|
| Passing function parameters to regexp_replace | Leif Biberg Kristensen | 11:21 |
| Re: Passing function parameters to regexp_replace | Leif Biberg Kristensen | 11:31 |
| Sorting of data from two tables | R. Smith | 13:32 |
| Re: Sorting of data from two tables | David Johnston | 13:56 |
| insert or update within transaction | Andreas | 14:52 |
| Re: Use select and update together | Andreas | 14:56 |
| Re: insert or update within transaction | Josh Kupershmidt | 15:49 |
| Re: Use select and update together | Guillaume Lelarge | 15:51 |
| Re: Use select and update together | Tom Lane | 16:16 |
| Re: Passing function parameters to regexp_replace | Tim Landscheidt | 17:07 |
| Re: Passing function parameters to regexp_replace | Leif Biberg Kristensen | 17:27 |
| select xpath ... | boris | 17:48 |
| Re: Passing function parameters to regexp_replace | Tim Landscheidt | 18:34 |
| Thread | Author | Time |
|---|---|---|
| Re: select xpath ... | Rob Sargent | 14:49 |
| Re: select xpath ... | boris | 15:49 |
| Re: Window function sort order help | Dianna Harter | 21:31 |
| Thread | Author | Time |
|---|---|---|
| Combining several CTEs with a recursive CTE | Thomas Kellerer | 09:58 |
| Re: Combining several CTEs with a recursive CTE | David Johnston | 14:15 |
| Re: Combining several CTEs with a recursive CTE | Thomas Kellerer | 14:54 |
| Thread | Author | Time |
|---|---|---|
| handling duplicate row exception | Amar Dhole | 05:54 |
| Re: handling duplicate row exception | Filip Rembiałkowski | 15:07 |
| Re: Trigger Procedure Error: NEW used in query that is not in a rule | jablonov | 15:32 |
| Re: select xpath ... | Brian Sherwood | 16:27 |
| ambiguous local variable name in 9.0 proc | Samuel Gendler | 23:35 |
| Re: ambiguous local variable name in 9.0 proc | David Johnston | 23:49 |
| Re: ambiguous local variable name in 9.0 proc | Samuel Gendler | 23:55 |
| Thread | Author | Time |
|---|---|---|
| Re: ambiguous local variable name in 9.0 proc | Tom Lane | 00:00 |
| a spatial table's bounding box | Asli Akarsakarya | 06:04 |
| Re: handling duplicate row exception | Amar Dhole | 06:11 |
| help with xpath namespace | Brian Sherwood | 15:03 |
| Thread | Author | Time |
|---|---|---|
| using the aggregate function max() | John Fabiani | 02:49 |
| Re: using the aggregate function max() | David Johnston | 03:14 |
| Re: using the aggregate function max() | John Fabiani | 04:40 |
| use of savepoint in containter managed transaction | Amar Dhole | 06:32 |
| Re: using the aggregate function max() | Thomas Kellerer | 06:37 |
| Re: help with xpath namespace | Filip Rembiałkowski | 16:14 |
| Re: a spatial table's bounding box | Filip Rembiałkowski | 19:18 |
| Thread | Author | Time |
|---|---|---|
| Howto build a funtion that selects an id or inserts a value | Andreas | 00:06 |
| Better way to check more than 1 value NOT IN (...) | Andreas | 09:38 |
| Re: Better way to check more than 1 value NOT IN (...) | pasman pasmański | 11:54 |
| Thread | Author | Time |
|---|---|---|
| Re: Sorting of data from two tables | R. Smith | 16:37 |
| Re: Sorting of data from two tables | David Johnston | 18:44 |
| Thread | Author | Time |
|---|---|---|
| Re: help with xpath namespace | Brian Sherwood | 13:56 |
| Thread | Author | Time |
|---|---|---|
| Re: handling duplicate row exception | Filip Rembiałkowski | 00:57 |
| how to calculate differences of timestamps? | Andreas | 01:31 |
| Re: how to calculate differences of timestamps? | Tim Landscheidt | 02:42 |
| Re: how to calculate differences of timestamps? | Steve Crawford | 16:08 |
| Thread | Author | Time |
|---|---|---|
| Edit multiple rows concurrent save | Péter Szabó | 21:58 |
| Edit multiple rows concurrent save | Péter Szabó | 22:07 |