Discussion for users on SQL related matters.
| Thread | Author | Time |
|---|---|---|
| Using psql to insert character codes | Ian Barwick | 14:20 |
| Re: Using psql to insert character codes | Randall Lucas | 16:15 |
| Re: Using psql to insert character codes | Ian Barwick | 16:53 |
| Re: Using psql to insert character codes | Ian Barwick | 17:35 |
| Re: Using psql to insert character codes | Randall Lucas | 17:36 |
| merge-join for domain with underlying type text | Randall Lucas | 21:04 |
| Re: merge-join for domain with underlying type text | Rod Taylor | 22:13 |
| Re: merge-join for domain with underlying type text | Randall Lucas | 23:40 |
| Thread | Author | Time |
|---|---|---|
| Re: merge-join for domain with underlying type text | Rod Taylor | 00:48 |
| Re: merge-join for domain with underlying type text | Randall Lucas | 00:53 |
| Re: merge-join for domain with underlying type text | Tom Lane | 03:19 |
| Knowing when it is safe to call currval() | Matthew Horoschun | 04:11 |
| Re: Knowing when it is safe to call currval() | Bruno Wolff III | 04:41 |
| Re: Knowing when it is safe to call currval() | Bruno Wolff III | 13:35 |
| Re: Knowing when it is safe to call currval() | Matthew Horoschun | 14:28 |
| please help construct an SQL query | Joe | 15:27 |
| sub select performance | Chris Linstruth | 16:48 |
| Re: Using psql to insert character codes | Peter Eisentraut | 16:54 |
| Re: sub select performance | Bruno Wolff III | 17:51 |
| Re: sub select performance | Mathieu Arnold | 18:53 |
| Re: please help construct an SQL query | David W Noon | 21:10 |
| Constraint Syntax Question | Adam Sherman | 22:17 |
| Thread | Author | Time |
|---|---|---|
| Re: sub select performance | Chris Linstruth | 01:05 |
| Re: Constraint Syntax Question | Peter and Sarah Childs | 04:42 |
| Re: Constraint Syntax Question | Peter Childs | 04:47 |
| Re: insert rowtype | Christoph Haller | 08:42 |
| Looking for script to dump postgresql schema to xml file | J Sensel | 10:39 |
| lock status check | mixo | 11:06 |
| bad query performance | Didrik Pinte | 12:38 |
| Re: epoch to timestamp | Lucas Lain | 15:05 |
| Re: epoch to timestamp | Randall Lucas | 15:22 |
| Re: epoch to timestamp | Larry Rosenman | 15:26 |
| Re: epoch to timestamp | Lucas Lain | 15:27 |
| Re: epoch to timestamp | Larry Rosenman | 15:35 |
| Re: epoch to timestamp | Josh Berkus | 16:00 |
| Re: epoch to timestamp | Larry Rosenman | 16:02 |
| Re: epoch to timestamp | Chris Linstruth | 17:13 |
| Why this query does not work? | Katka a Daniel Dunajsky | 17:55 |
| Re: epoch to timestamp | Achilleus Mantzios | 20:30 |
| Re: epoch to timestamp | Achilleus Mantzios | 20:39 |
| create type question | John DeSoi | 20:48 |
| Re: create type question | Stephan Szabo | 20:58 |
| Re: Why this query does not work? | Tom Lane | 21:53 |
| Thread | Author | Time |
|---|---|---|
| Re: See Temp Table from Trigger | Christoph Haller | 08:41 |
| Re: Testing castability of text to numeric | Christoph Haller | 09:43 |
| Re: lock status check | Christoph Haller | 10:53 |
| installation problem | mdc | 14:02 |
| Chain/Thread Problem | Sammy | 14:46 |
| Re: Testing castability of text to numeric | Achilleus Mantzios | 14:57 |
| Re: "deadlock detected" documentation | Matt Mello | 16:08 |
| Re: Chain/Thread Problem | J Sensel | 16:53 |
| Re: Chain/Thread Problem | Richard Huxton | 17:22 |
| Re: Efficiency Issue with "SELECT IN (..)" and "SELECT .. OR .." | Richard Huxton | 17:29 |
| Re: Efficiency Issue with "SELECT IN (..)" and "SELECT .. OR .." | Randall Lucas | 17:34 |
| Re: "deadlock detected" documentation | Tom Lane | 19:13 |
| Re: Efficiency Issue with "SELECT IN (..)" and "SELECT .. OR .." | Tom Lane | 19:25 |
| Re: Efficiency Issue with "SELECT IN (..)" and "SELECT .. OR | Mike Winter | 19:28 |
| Thread | Author | Time |
|---|---|---|
| JOIN vs. WHERE ... IN (subselect) | Dean Gibson (DB Administrator) | 06:51 |
| Re: JOIN vs. WHERE ... IN (subselect) | Chris Linstruth | 14:45 |
| Re: JOIN vs. WHERE ... IN (subselect) | Dean Gibson (DB Administrator) | 15:12 |
| Re: JOIN vs. WHERE ... IN (subselect) | Stephan Szabo | 16:13 |
| how to use an aggregate function | jmsmithe | 16:18 |
| COALESCE in ORDER BY... | Terry Yapt | 16:40 |
| Re: COALESCE in ORDER BY... | Andreas Schmitz | 17:14 |
| Re: how to use an aggregate function | David W Noon | 17:14 |
| Re: COALESCE in ORDER BY... | Stephan Szabo | 17:41 |
| Thread | Author | Time |
|---|---|---|
| Re: COALESCE in ORDER BY... | Terry Yapt | 11:27 |
| Thread | Author | Time |
|---|---|---|
| Inquiry From Form [pgsql] | Rajendran | 05:23 |
| CASE | James Taylor | 06:59 |
| Referencing a column from another table in a different database with a foreign key constraint. | Dan S | 11:39 |
| AS? | Andreas Selenwall | 15:55 |
| Re: Can arrays reference primary keys in CREATE TABLE? | Jan Wieck | 17:40 |
| libpq program SELECT FOR UPDATE and TIMEOUT or CANCEL REQUEST | Jeffrey Pogodzinski | 17:55 |
| Performance on temp table inserts | Jeff Boes | 19:11 |
| Re: "deadlock detected" documentation | Jan Wieck | 19:19 |
| Re: "deadlock detected" / cascading locks | Matt Mello | 20:55 |
| Re: Performance on temp table inserts | Josh Berkus | 22:04 |
| Re: "deadlock detected" / cascading locks | Stephan Szabo | 22:28 |
| Re: CASE | Stephan Szabo | 22:49 |
| Re: Performance on temp table inserts | David W Noon | 23:19 |
| Re: CASE | Rod Taylor | 23:24 |
| Re: CASE | Manfred Koizar | 23:52 |
| Thread | Author | Time |
|---|---|---|
| Re: CASE | Tom Lane | 00:17 |
| Re: Testing castability of text to numeric | Dean Gibson (DB Administrator) | 00:28 |
| Re: "deadlock detected" / cascading locks | Jan Wieck | 01:01 |
| Re: Performance on temp table inserts | Tom Lane | 04:51 |
| Drop CONSTRAINT | Rado Petrik | 09:32 |
| Re: Performance on temp table inserts | Jeff Boes | 12:37 |
| missing chunk number 0 for toast value 32067496 | Eric Anderson Vianet SAO | 14:05 |
| Re: Testing castability of text to numeric | Jan Wieck | 14:57 |
| Re: Drop CONSTRAINT | Achilleus Mantzios | 15:16 |
| how to do this query? | ww zz | 16:00 |
| Re: Performance on temp table inserts | Tom Lane | 16:04 |
| Re: Performance on temp table inserts | Jeff Boes | 16:15 |
| Re: Performance on temp table inserts | Jeff Boes | 16:21 |
| Date comparison question | Jan Bodey | 16:22 |
| Re: how to do this query? | Richard Huxton | 16:36 |
| Re: how to do this query? | Stephan Szabo | 16:46 |