Discussion for users on SQL related matters.
| 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 |
| Re: Hot standby with streaming replication under PgSQL 9.1.x : failover when master crashes? | David Guyot | 14:53 |
| Re: Hot standby with streaming replication under PgSQL 9.1.x : failover when master crashes? | Douglas J Hunley | 16:51 |
| Re: Hot standby with streaming replication under PgSQL 9.1.x : failover when master crashes? | Douglas J Hunley | 16:54 |
| Thread | Author | Time |
|---|---|---|
| Postgres trigger issue with update statement in it. | Kaleeswaran Velu | 04:08 |
| Re: Postgres trigger issue with update statement in it. | Wolfe Whalen | 07:28 |
| Re: Postgres trigger issue with update statement in it. | Adrian Klaver | 13:16 |
| Re: Postgres trigger issue with update statement in it. | Kaleeswaran Velu | 17:54 |
| Thread | Author | Time |
|---|---|---|
| Data Loss from SQL SELECT (vs. COPY/pg_dump) | Kong Man | 19:56 |
| Re: Data Loss from SQL SELECT (vs. COPY/pg_dump) | Kong Man | 22:51 |
| Thread | Author | Time |
|---|---|---|
| Encrypting PGBouncer to Postgres DB connections | Bhanu Murthy | 18:06 |
| Re: Encrypting PGBouncer to Postgres DB connections | AJ Weber | 18:15 |
| Re: [SQL] Encrypting PGBouncer to Postgres DB connections | [email protected] | 18:16 |
| Advice for index design | JORGE MALDONADO | 22:30 |
| Thread | Author | Time |
|---|---|---|
| Re: Advice for index design | Gavin Flower | 00:00 |
| Restrict FOREIGN KEY to a part of the referenced table | Matthias Nagel | 07:55 |
| Slow update with ST_Contians() | androclos | 16:38 |
| Re: Advice for index design | Greg Sabino Mullane | 23:36 |
| Thread | Author | Time |
|---|---|---|
| Re: Advice for index design | Jasen Betts | 13:29 |
| Re: Restrict FOREIGN KEY to a part of the referenced table | Jasen Betts | 13:53 |
| Re: Restrict FOREIGN KEY to a part of the referenced table | Richard Broersma | 19:52 |
| Clarity on how LOCK interacts with INHERIT | Robins Tharakan | 20:59 |
| Re: Clarity on how LOCK interacts with INHERIT | Simon Riggs | 21:09 |
| pivot query with count | Tony Capobianco | 21:14 |
| Thread | Author | Time |
|---|---|---|
| pivot query with count | Tony Capobianco | 00:28 |
| Re: pivot query with count | David Johnston | 03:26 |
| Re: pivot query with count | David Johnston | 03:29 |
| Re: pivot query with count | Tony Capobianco | 22:05 |
| Thread | Author | Time |
|---|---|---|
| Peer-review requested of soft-delete scheme | Mark Stosberg | 16:24 |
| building psycopg2 | Thomas Burnett | 18:42 |
| Thread | Author | Time |
|---|---|---|
| copy from csv, variable filename within a function | basti | 07:26 |
| Fwd: copy from csv, variable filename within a function | basti | 08:34 |
| ALTER USER abc PASSWORD - what's going on ??? | Marcin Krawczyk | 10:59 |
| Re: ALTER USER abc PASSWORD - what's going on ??? | SEKA Bruno-Emmanuel | 11:19 |
| Re: ALTER USER abc PASSWORD - what's going on ??? | Marcin Krawczyk | 11:21 |
| Re: ALTER USER abc PASSWORD - what's going on ??? | SEKA Bruno-Emmanuel | 11:31 |
| Re: Peer-review requested of soft-delete scheme | Jasen Betts | 11:44 |
| Re: copy from csv, variable filename within a function | bricklen | 13:48 |
| Primary DB stuck becuase of unavailable standby (synchronized streaming) - please help | Sofer, Yuval | 15:41 |
| Re: Primary DB stuck becuase of unavailable standby (synchronized streaming) - please help | Andreas Kretschmer | 16:38 |
| Re: ALTER USER abc PASSWORD - what's going on ??? | Guillaume Lelarge | 18:18 |
| Thread | Author | Time |
|---|---|---|
| SQL query with Overlapping date time ranges | chinnaobi | 03:41 |
| Re: ALTER USER abc PASSWORD - what's going on ??? | Marcin Krawczyk | 08:13 |