Discussion for users on SQL related matters.
| Thread | Author | Time |
|---|---|---|
| Thanks | Bill | 03:14 |
| RE: Temp tables being written to disk. Avoidable? | Paul McGarry | 07:06 |
| Interval FAQ - please review 📎 | Josh Berkus | 16:22 |
| Re: Interval FAQ - please review | Vivek Khera | 17:06 |
| Re: Interval FAQ - please review | Jeff Eckermann | 19:21 |
| Nested JOINs | Oleg Lebedev | 20:28 |
| Re: Re: Help!!! Trying to "SELECT" and get a tree structure back. | Mark Stosberg | 20:34 |
| Re: Interval FAQ - please review | Josh Berkus | 20:42 |
| Re: Re: Interval FAQ - please review | Josh Berkus | 20:44 |
| Re: Re: Interval FAQ - please review | Vivek Khera | 20:50 |
| Re: Nested JOINs | Tom Lane | 21:42 |
| Re: Nested JOINs | Josh Berkus | 21:44 |
| Re: Interval FAQ - please review | Peter Eisentraut | 22:05 |
| Re: Nested JOINs | Tom Lane | 22:12 |
| Fwd: [SQL] how to use record type | Horst Herb | 22:24 |
| Thread | Author | Time |
|---|---|---|
| Query Approach and performance | Morgan Curley | 07:29 |
| pg_ctl start hangs | Christophe Labouisse | 08:22 |
| Re: Query Approach and performance | Martijn van Oosterhout | 09:47 |
| Re: how to use record type | Jeff Eckermann | 14:18 |
| Re: Nested JOINs - upgrade to 7.1.2 | Oleg Lebedev | 18:19 |
| Finding table constraints | Stephen Patterson | 18:23 |
| Thread | Author | Time |
|---|---|---|
| Nested set model | Renato De Giovanni | 01:00 |
| Function define question | Bill | 05:23 |
| Re: Function define question | omid omoomi | 18:23 |
| Thread | Author | Time |
|---|---|---|
| Re: how to use record type | Horst Herb | 13:20 |
| Array in plpgsql | omid omoomi | 20:41 |
| Thread | Author | Time |
|---|---|---|
| Re: exists | Joseph Shraibman | 00:15 |
| changes to table creation syntax in 7.1.2? | Jayson Callaway | 04:23 |
| Altering pg_conndefaults | macky | 06:28 |
| Re: [SQL] Altering pg_conndefaults | Peter Eisentraut | 16:09 |
| just checking | postgresql | 19:37 |
| protected ON DELETE CASCADE | Murray Hobbs | 22:01 |
| Thread | Author | Time |
|---|---|---|
| Help On Postgresql | Jaydip | 07:50 |
| Re: [NOVICE] protected ON DELETE CASCADE | Albert Reiner | 12:12 |
| Re: protected ON DELETE CASCADE | Jan Wieck | 13:55 |
| Re: protected ON DELETE CASCADE | Gregory Wood | 14:48 |
| Function returning an array | Francesco Casadei | 14:58 |
| Re: Function returning an array 📎 | Josh Berkus | 15:44 |
| Re: Function returning an array | Tom Lane | 17:07 |
| HELP: Trend reporting | Jason Charette | 18:05 |
| Execute permsissions on fuctions | Zot O'Connor | 18:52 |
| Re: protected ON DELETE CASCADE | Murray Hobbs | 19:07 |
| DBD::Pg install error (freebsd) | jake johnson | 19:08 |
| Re: Function returning an array | Alex Pilosov | 19:45 |
| Re: protected ON DELETE CASCADE | Jan Wieck | 20:21 |
| Re: protected ON DELETE CASCADE | Murray Hobbs | 20:46 |
| Thread | Author | Time |
|---|---|---|
| GRANT ALL ON TO GROUP failure | Jari Aalto+usenet | 05:35 |
| Re: GRANT ALL ON TO GROUP failure | Thurstan R. McDougle | 08:51 |
| Re: Temp tables being written to disk. Avoidable? [Another TO-DO] | Chris Ruprecht | 13:38 |
| Re: DBD::Pg install error (freebsd) | Vivek Khera | 15:39 |
| WHERE on an alias | Joseph Shraibman | 18:11 |
| Re: WHERE on an alias | Stephan Szabo | 19:27 |
| Re: WHERE on an alias | Joseph Shraibman | 19:31 |
| Indexing and performance | Josh Berkus | 19:56 |
| Re: WHERE on an alias | Josh Berkus | 19:58 |
| Re: WHERE on an alias | Joseph Shraibman | 20:18 |
| Re: WHERE on an alias | Josh Berkus | 20:43 |
| Re: WHERE on an alias | Stephan Szabo | 20:52 |
| Re: WHERE on an alias | Tom Lane | 20:56 |
| Re: DBD::Pg install error (freebsd) | jake johnson | 23:20 |
| Thread | Author | Time |
|---|---|---|
| Re: Execute permsissions on fuctions | Zot O'Connor | 04:42 |
| Re: Execute permsissions on fuctions | Dmitry G. Mastrukov Дмитрий Геннадьевич Мастрюков | 06:08 |
| Re: Execute permsissions on fuctions | Christopher Sawtell | 08:19 |
| Thread | Author | Time |
|---|---|---|
| Sql | Marcia Cunha | 00:55 |
| Different Choices For Index/Sequential Scan With And Without A Join In 7.2 | Mark kirkwood | 08:36 |
| undocumented setval() | Cedar Cox | 08:40 |
| "AND", "OR" and Materialize :(((( | Meszaros Attila | 12:38 |
| Re: [SQL] undocumented setval() | Tom Lane | 15:24 |
| Re: Different Choices For Index/Sequential Scan With And Without A Join In 7.2 | Tom Lane | 15:44 |
| Re: "AND", "OR" and Materialize :(((( | Tom Lane | 15:51 |
| Re: "AND", "OR" and Materialize :(((( | Meszaros Attila | 18:09 |
| Re: Different Choices For Index/Sequential Scan With And Without A Join In 7.2 | markir | 22:49 |
| Thread | Author | Time |
|---|---|---|
| Apache authentication and v7.1 | Giorgio Volpe | 08:34 |
| Thread | Author | Time |
|---|---|---|
| Create table syntax | satish rao | 07:11 |
| Problem with sequences | Vladimir Terziev | 15:15 |
| Thread | Author | Time |
|---|---|---|
| List archives moved and cleaned up ... | Marc G. Fournier | 03:44 |
| Re: WHERE on an alias | Andre Schnabel | 06:27 |
| [No subject] | Vladimir Terziev | 07:40 |
| getting the oid for a new tuple in a BEFORE trigger | Markus Wagner | 09:15 |
| Re: | omid omoomi | 09:16 |
| Re: [SQL] getting the oid for a new tuple in a BEFORE trigger | omid omoomi | 10:11 |
| Re: getting the oid for a new tuple in a BEFORE trigger 📎 | Josh Berkus | 14:38 |
| Re: changes to table creation syntax in 7.1.2? | Stephan Szabo | 18:24 |
| Re: changes to table creation syntax in 7.1.2? | Jason Earl | 20:34 |
| GRANT ALL ON TO GROUP failure | Jari Aalto | 21:26 |
| RE: changes to table creation syntax in 7.1.2? | Jayson Callaway | 21:42 |
| Re: GRANT ALL ON TO GROUP failure | Peter Eisentraut | 21:57 |
| Re: GRANT ALL ON TO GROUP failure | Oliver Elphick | 22:20 |
| Thread | Author | Time |
|---|---|---|
| Re: Latin-2 sort order | Tatsuo Ishii | 00:59 |
| Re: Help On Postgresql | Henshall, Stuart - WCP | 10:18 |
| Re: 2 tables, joins and same name... | Richard Poole | 14:17 |
| Re: 2 tables, joins and same name... | Stephan Szabo | 14:30 |
| Re: 2 tables, joins and same name... 📎 | Josh Berkus | 14:46 |
| Re: 2 tables, joins and same name... 📎 | Josh Berkus | 15:29 |
| Re: 2 tables, joins and same name... | Thomas Rehlich | 15:55 |
| Re: getting the oid for a new tuple in a BEFORE trigger | Mikheev, Vadim | 16:45 |
| Re: 2 tables, joins and same name... | Ross J. Reedstrom | 22:29 |
| Thread | Author | Time |
|---|---|---|
| Re: 2 tables, joins and same name... 📎 | Josh Berkus | 16:44 |
| Re: 2 tables, joins and same name... | Ross J. Reedstrom | 18:21 |
| Thread | Author | Time |
|---|---|---|
| duplicated oid | Carolyn Lu Wong | 04:41 |
| [No subject] | Joseph Syjuco | 09:02 |
| Re: | Michael Davis | 16:29 |
| GRANT ALL ON TO GROUP failure | Jari Aalto | 16:34 |
| Re: | Joe Conway | 17:05 |
| Re: | Peter Eisentraut | 17:35 |
| Re: | Stephan Szabo | 17:45 |
| More on the TO DO wishlist | Chris Ruprecht | 18:06 |
| Re: INSERT Syntax 📎 | Josh Berkus | 19:33 |
| Re: More on the TO DO wishlist 📎 | Josh Berkus | 19:39 |
| Re: More on the TO DO wishlist | Peter Eisentraut | 21:24 |
| Re: On Differing Optimizer Choices ( Again) | Tom Lane | 22:33 |
| Re: Index Scan Backward vs. Sort/Sequential Scan when using ORDER BY | Tom Lane | 23:31 |
| Thread | Author | Time |
|---|---|---|
| Re: More on the TO DO wishlist 📎 | Josh Berkus | 03:16 |
| Re: 2 tables, joins and same name... 📎 | Josh Berkus | 03:18 |
| Need help in composing PostgreSQL query | Vladimir V. Zolotych | 06:23 |
| Re: Need help in composing PostgreSQL query | Oliver Elphick | 07:53 |
| Re: GRANT ALL ON TO GROUP failure | Henshall, Stuart - WCP | 09:53 |
| Re: 2 tables, joins and same name... | Jeff Eckermann | 15:10 |