Discussion for users on SQL related matters.
| Thread | Author | Time |
|---|---|---|
| Why doesn't this work | Barbara Woolums | 11:50 |
| Re: Why doesn't this work | Bèrto ëd Sèra | 11:55 |
| Re: Why doesn't this work | Leif Biberg Kristensen | 11:58 |
| Re: Why doesn't this work | Rob Sargent | 15:04 |
| Re: returning values from dynamic SQL to a variable | kgeographer | 17:08 |
| Curious problem of using BETWEEN with start and end being the same versus EQUALS '=' | Venky Kandaswamy | 18:18 |
| Re: returning values from dynamic SQL to a variable | Pavel Stehule | 18:23 |
| Re: [SQL] Curious problem of using BETWEEN with start and end being the same versus EQUALS '=' | Tom Lane | 22:30 |
| Re: [SQL] Curious problem of using BETWEEN with start and end being the same versus EQUALS '=' | Venky Kandaswamy | 22:44 |
| Thread | Author | Time |
|---|---|---|
| Re: returning the number of rows output by a copy command from a function | Jasen Betts | 10:54 |
| number of values updated per column | Willy-Bas Loos | 17:36 |
| Re: number of values updated per column | Akihiro Okuno | 18:30 |
| Aggregate over a linked list | M Lubratt | 23:19 |
| Re: Aggregate over a linked list | Venky Kandaswamy | 23:30 |
| Thread | Author | Time |
|---|---|---|
| [No subject] | wln | 03:35 |
| Thread | Author | Time |
|---|---|---|
| need some magic with generate_series() | Andreas | 21:41 |
| Re: need some magic with generate_series() | jan zimmek | 21:49 |
| Re: need some magic with generate_series() | Filip Rembiałkowski | 21:52 |
| Re: need some magic with generate_series() | Andreas | 22:49 |
| Thread | Author | Time |
|---|---|---|
| Re: [SQL] need some magic with generate_series() | Alexander Gataric | 00:08 |
| Re: need some magic with generate_series() | Andreas | 01:00 |
| Re: [SQL] need some magic with generate_series() | Alexander Gataric | 01:37 |
| vacuum / analyze parent tables on partitioned tables. | Bert | 10:21 |
| Range types (DATERANGE, TSTZRANGE) in a foreign key with "inclusion" logic | Matthias Nagel | 10:28 |
| Problem with extract(epoch from interval ... | Kaloyan Iliev | 10:54 |
| Re: Problem with extract(epoch from interval ... | Ian Lawrence Barwick | 11:00 |
| Re: Problem with extract(epoch from interval ... | Kaloyan Iliev | 11:23 |
| Re: Re: [SQL] need some magic with generate_series() | Andreas | 12:11 |
| Re: Problem with extract(epoch from interval ... | Adrian Klaver | 14:37 |
| Thread | Author | Time |
|---|---|---|
| How to access multicolumn function results? | Andreas | 00:58 |
| Re: How to access multicolumn function results? | Tom Lane | 01:42 |
| Thread | Author | Time |
|---|---|---|
| Writeable CTE Not Working? | Kong Man | 02:32 |
| Re: Writeable CTE Not Working? | Виктор Егоров | 07:40 |
| Re: Writeable CTE Not Working? | Kong Man | 19:29 |
| Thread | Author | Time |
|---|---|---|
| Re: Writeable CTE Not Working? | Tom Lane | 01:16 |
| Re: Writeable CTE Not Working? | Kong Man | 02:45 |
| Thread | Author | Time |
|---|---|---|
| Partition tables to improve select speed? | Bert | 09:43 |
| How to put multiples results in just one column | Nei Rauni Santos | 12:35 |
| Re: How to put multiples results in just one column | Pavel Stehule | 12:39 |
| Re: How to put multiples results in just one column | Nei Rauni Santos | 13:55 |
| Re: How to put multiples results in just one column | Pavel Stehule | 14:04 |
| Re: Partition tables to improve select speed? | Jonathan S. Katz | 16:48 |
| Thread | Author | Time |
|---|---|---|
| Querying multiple database | Dev Kumkar | 17:12 |
| Thread | Author | Time |
|---|---|---|
| Conditional expression in an UPDATE statement | JORGE MALDONADO | 01:08 |
| Re: Conditional expression in an UPDATE statement | Jasen Betts | 06:41 |
| Thread | Author | Time |
|---|---|---|
| upsert doesn't seem to work.. | Bert | 09:38 |
| Thread | Author | Time |
|---|---|---|
| Re: upsert doesn't seem to work.. | Sergey Konoplev | 00:53 |
| Thread | Author | Time |
|---|---|---|
| Summing & Grouping in a Hierarchical Structure | Don Parris | 01:57 |
| Re: Summing & Grouping in a Hierarchical Structure | Alexander Gataric | 04:30 |
| Perform Function When The Rows Of A View Change | Adam | 20:31 |
| Thread | Author | Time |
|---|---|---|
| Volatile functions in WITH | Ben Morrow | 07:58 |
| Re: upsert doesn't seem to work.. | Ben Morrow | 09:44 |
| Re: Perform Function When The Rows Of A View Change | Ben Morrow | 10:50 |
| How to reject overlapping timespans? | Andreas | 17:02 |
| Re: How to reject overlapping timespans? | Andreas Kretschmer | 18:20 |
| Re: How to reject overlapping timespans? | Andreas | 18:59 |
| Re: How to reject overlapping timespans? | Ben Morrow | 22:26 |
| Thread | Author | Time |
|---|---|---|
| query doesn't always follow 'correct' path.. | Bert | 09:43 |
| Re: query doesn't always follow 'correct' path.. | Frank Lanitz | 10:51 |
| HP and libxnet ... | Sebastien FLAESCH | 11:44 |
| Re: query doesn't always follow 'correct' path.. | Bert | 13:42 |
| Re: query doesn't always follow 'correct' path.. | Bert | 14:39 |
| Re: query doesn't always follow 'correct' path.. | Виктор Егоров | 15:20 |
| Re: query doesn't always follow 'correct' path.. | Julien Cigar | 15:20 |
| Re: Summing & Grouping in a Hierarchical Structure | Relyea, Mike | 15:24 |
| Re: query doesn't always follow 'correct' path.. | Julien Cigar | 15:28 |
| Re: query doesn't always follow 'correct' path.. | Bert | 15:34 |
| Thread | Author | Time |
|---|---|---|
| Re: Volatile functions in WITH | Sergey Konoplev | 06:17 |
| Re: Volatile functions in WITH | Ben Morrow | 08:19 |
| Re: Volatile functions in WITH | Sergey Konoplev | 16:10 |
| Re: Volatile functions in WITH | Ben Morrow | 18:16 |
| Re: Volatile functions in WITH | Sergey Konoplev | 20:28 |
| Thread | Author | Time |
|---|---|---|
| Re: Volatile functions in WITH | Ben Morrow | 01:25 |
| Re: Summing & Grouping in a Hierarchical Structure | Don Parris | 10:38 |
| Re: Summing & Grouping in a Hierarchical Structure | Don Parris | 10:42 |
| need help | denero team | 17:36 |
| Re: need help | Carlos Chapi | 19:56 |
| Re: need help | denero team | 20:20 |
| Re: need help | Oliver d'Azevedo Cristina | 20:35 |
| Re: need help | Russell Keane | 21:07 |
| Re: need help | Russell Keane | 21:28 |
| Re: need help | Oliver d'Azevedo Cristina | 22:26 |
| Thread | Author | Time |
|---|---|---|
| Re: Summing & Grouping in a Hierarchical Structure | Alexander Gataric | 03:28 |
| Re: need help | Jaime Casanova | 03:55 |
| Re: need help | Russell Keane | 08:31 |
| Re: Summing & Grouping in a Hierarchical Structure | Misa Simic | 09:00 |
| Re: need help | Russell Keane | 09:26 |
| Re: need help | denero team | 10:41 |
| Is using the xml column type a good idea for queries that need to be fast? | Denis Papathanasiou | 17:20 |
| Re: need help | denero team | 18:30 |
| Update HSTORE record and then delete if it is now empty - What is the correct sql? | Ashwin Jayaprakash | 22:46 |
| Thread | Author | Time |
|---|---|---|
| Using Ltree For Hierarchical Structures | Don Parris | 22:20 |
| Thread | Author | Time |
|---|---|---|
| Euclidean distance between two sets of tuples | Surfing | 18:34 |
| Creating a new database with a TEMPLATE did not work | mkumbale | 22:49 |
| Re: Creating a new database with a TEMPLATE did not work | Adrian Klaver | 22:56 |
| Thread | Author | Time |
|---|---|---|
| Re: Creating a new database with a TEMPLATE did not work | Ben Morrow | 02:46 |
| Re: Using Ltree For Hierarchical Structures | Igor Neyman | 14:01 |
| Re: Using Ltree For Hierarchical Structures | Misa Simic | 16:14 |
| Re: Creating a new database with a TEMPLATE did not work | mkumbale | 18:20 |
| Re: Using Ltree For Hierarchical Structures | Don Parris | 18:22 |
| Re: Using Ltree For Hierarchical Structures | Thomas Kellerer | 18:43 |
| Re: Using Ltree For Hierarchical Structures | Igor Neyman | 19:30 |
| Re: Using Ltree For Hierarchical Structures | Don Parris | 21:54 |
| Re: Using Ltree For Hierarchical Structures | Misa Simic | 23:12 |
| Thread | Author | Time |
|---|---|---|
| Re: Using Ltree For Hierarchical Structures | Igor Neyman | 16:02 |
| Thread | Author | Time |
|---|---|---|
| Concatenating bytea types... | Marko Rihtar | 10:21 |
| Need help revoking access WHERE state = 'deleted' | Mark Stosberg | 16:37 |
| Re: Need help revoking access WHERE state = 'deleted' | Ben Morrow | 18:02 |
| Re: Need help revoking access WHERE state = 'deleted' | Mark Stosberg | 18:35 |
| Re: Need help revoking access WHERE state = 'deleted' | Tom Lane | 19:08 |
| Re: Need help revoking access WHERE state = 'deleted' | Mark Stosberg | 19:29 |
| Thread | Author | Time |
|---|---|---|
| Re: Concatenating bytea types... | Richard Huxton | 14:32 |
| Thread | Author | Time |
|---|---|---|
| Re: Concatenating bytea types... | Jasen Betts | 05:07 |
| Re: Need help revoking access WHERE state = 'deleted' | Wayne Cuddy | 18:20 |
| I need to fill up a sparse table in an view | Andreas | 19:30 |
| Re: I need to fill up a sparse table in an view | Victor Yegorov | 20:46 |
| Re: Need help revoking access WHERE state = 'deleted' | Ben Morrow | 23:45 |
| Thread | Author | Time |
|---|---|---|
| Migrate to Postgres - Alias a Keyword? | Huan Ruan | 23:17 |
| Thread | Author | Time |
|---|---|---|
| Re: Migrate to Postgres - Alias a Keyword? | Torsten Zuehlsdorff | 13:45 |
| Thread | Author | Time |
|---|---|---|
| 3/9/2013 2:45:30 PM | Barbara Woolums | 13:45 |
| Thread | Author | Time |
|---|---|---|
| xmlelement name | Ben Morgan | 13:55 |
| Re: xmlelement name | Pavel Stehule | 14:27 |
| Thread | Author | Time |
|---|---|---|
| bug in 9.2.2 ? subquery accepts wrong column name : upd | Achilleas Mantzios | 15:29 |
| Re: bug in 9.2.2 ? subquery accepts wrong column name : upd | Tom Lane | 16:17 |
| UPDATE query with variable number of OR conditions in WHERE | JORGE MALDONADO | 22:25 |
| Re: UPDATE query with variable number of OR conditions in WHERE | Ben Morrow | 23:58 |
| Thread | Author | Time |
|---|---|---|
| Re: UPDATE query with variable number of OR conditions in WHERE | Tom Lane | 03:15 |
| Re: bug in 9.2.2 ? subquery accepts wrong column name : upd | Achilleas Mantzios | 07:49 |
| Thread | Author | Time |
|---|---|---|
| ZIP function | Victor Sterpu | 19:50 |
| Re: ZIP function | Jasen Betts | 23:37 |
| Thread | Author | Time |
|---|---|---|
| Re: ZIP function | Ben Morrow | 01:36 |
| Efficiency Problem | Surfing | 11:15 |
| Re: Efficiency Problem | Misa Simic | 11:39 |
| Re: Efficiency Problem | Surfing | 11:43 |
| link | Claudio Adriano Guarracino | 15:47 |
| Thread | Author | Time |
|---|---|---|
| How to split an array-column? | Andreas | 19:13 |
| Re: How to split an array-column? | Venky Kandaswamy | 19:24 |
| Re: How to split an array-column? | Andreas | 20:43 |
| Thread | Author | Time |
|---|---|---|
| Reading from file without superuser privilege | Jose Antonio Quintana/UPC | 11:43 |
| Re: Reading from file without superuser privilege | Adrian Klaver | 13:40 |
| Thread | Author | Time |
|---|---|---|
| From with case | Mauricio Cruz | 13:48 |
| Re: From with case | Pavel Stehule | 14:01 |
| Re: From with case | Mauricio Cruz | 14:38 |
| Re: From with case | Ben Morrow | 22:50 |
| Thread | Author | Time |
|---|---|---|
| Re: From with case | Pavel Stehule | 05:33 |
| Re: From with case | Ben Morrow | 06:22 |
| Re: From with case | Pavel Stehule | 07:44 |
| Re: From with case | Pavel Stehule | 08:08 |
| how can I replace all instances of a pattern | James Sharrett | 13:08 |
| Re: how can I replace all instances of a pattern | James Sharrett | 13:13 |
| Re: how can I replace all instances of a pattern | [email protected] | 13:18 |
| Re: how can I replace all instances of a pattern | Steve Crawford | 13:22 |
| Re: how can I replace all instances of a pattern | James Sharrett | 13:31 |
| Thread | Author | Time |
|---|---|---|
| Hot standby with streaming replication under PgSQL 9.1.x : failover when master crashes? | David Guyot (English) | 14:29 |
| Re: Hot standby with streaming replication under PgSQL 9.1.x : failover when master crashes? | Douglas J Hunley | 14:47 |