Discussion for users on SQL related matters.
| Thread | Author | Time |
|---|---|---|
| copy from command - quotes and header lines | Kenneth Evans | 17:21 |
| Thread | Author | Time |
|---|---|---|
| How does postgres handle non literal string values | javaholic | 12:57 |
| Question on SQL and pg_-tables | Tilo Schwarz | 16:21 |
| Re: Question on SQL and pg_-tables | Tom Lane | 18:32 |
| changing the size of a column without dump/restore | Michael Richards | 18:57 |
| Re: celko nested set functions | greg | 20:22 |
| Thread | Author | Time |
|---|---|---|
| Re: join question | Manfred Koizar | 08:10 |
| Re: retrieving specific info. from one column and locating it in another | Christoph Haller | 16:14 |
| Thread | Author | Time |
|---|---|---|
| Analyze + Index | Rudi Starcevic | 04:04 |
| Re: Analyze + Index | Rudi Starcevic | 04:45 |
| Re: Big query problem | Christoph Haller | 09:55 |
| master-detail relationship and count | Gary Stainburn | 10:06 |
| Re: Analyze + Index | Richard Huxton | 10:32 |
| Re: master-detail relationship and count | Richard Huxton | 10:35 |
| Re: master-detail relationship and count | Achilleus Mantzios | 10:36 |
| Re: master-detail relationship and count | Gary Stainburn | 10:51 |
| Re: master-detail relationship and count | Achilleus Mantzios | 11:16 |
| import sql script | Rafal Kedziorski | 12:13 |
| Re: master-detail relationship and count | Dan Langille | 14:24 |
| Re: master-detail relationship and count | Gary Stainburn | 14:39 |
| ALTER TABLE x DROP CONSTRAINT fkey | Thomas Good | 18:41 |
| Min and Max | Sergio Oshiro | 18:55 |
| Question about slow Select when using 'IN'. | Mike Winter | 22:23 |
| Thread | Author | Time |
|---|---|---|
| [No subject] | A.M. | 03:50 |
| Re: | Tom Lane | 04:28 |
| Re: | A.M. | 04:31 |
| Accumulative Queries? | Benjamin Smith | 14:40 |
| How to take advantage of PREPARED QUERIES of PGSQL 7.3 in mod_perl enviornment? | Rajesh Kumar Mallah. | 19:06 |
| Moving tables accross schemas in PostgreSQL 7.3 | Rajesh Kumar Mallah. | 19:12 |
| Thread | Author | Time |
|---|---|---|
| SQL99 <search or cycle clause> | Evgen Potemkin | 18:49 |
| Thread | Author | Time |
|---|---|---|
| Need Postgresql Help | Atul Pedgaonkar | 07:10 |
| Re: Need Postgresql Help | Andreas Joseph Krogh | 08:42 |
| Need Postgresql Help | Atul | 08:44 |
| Re: Need Postgresql Help | Richard Huxton | 10:57 |
| Analyzing the 7.3 SQL92 Schema | Christian Gausepohl | 16:39 |
| CURRENT_TIMSTAMP 📎 | Raymond Chui | 16:41 |
| Re: [SQL] CURRENT_TIMSTAMP | Joel Burton | 18:38 |
| Re: Min and Max | Dennis Björklund | 18:44 |
| Combining queries while preserving order in SQL - Help! | Casey Allen Shobe | 18:46 |
| Re: Min and Max | Joel Burton | 18:46 |
| Re: Accumulative Queries? | Joel Burton | 19:01 |
| Re: Combining queries while preserving order in SQL - Help! | Joel Burton | 19:23 |
| Re: Min and Max | Jean-Luc Lachance | 19:54 |
| Re: [SQL] CURRENT_TIMSTAMP | Stephan Szabo | 21:27 |
| Thread | Author | Time |
|---|---|---|
| sql query | Vijay Uppal | 02:03 |
| Re: How does postgres handle non literal string values | Vernon Wu | 05:22 |
| loop query results | Stefan Reuschke | 08:58 |
| Re: loop query results | Dennis Björklund | 09:21 |
| Re: How does postgres handle non literal string values | Charles H. Woloszynski | 13:00 |
| Problem with view in PostgreSQl 7.3 📎 | Alphasoft | 14:40 |
| Re: How does postgres handle non literal string values | Vernon Wu | 17:11 |
| Query about table and catalog | javier garcia | 18:08 |
| Inheritance in PostgreSQL limitation | Pedro Igor | 19:19 |
| Re: problem with view in 7.3 | Tom Lane | 20:02 |
| Ran out of connections | Mike Diehl | 22:08 |
| Re: Ran out of connections | Roberto Mello | 22:25 |
| Re: Ran out of connections | Steve Crawford | 22:29 |
| Re: Ran out of connections | Robert Treat | 23:23 |
| Re: Ran out of connections | Mike Diehl | 23:52 |
| Thread | Author | Time |
|---|---|---|
| Re: Ran out of connections | Roberto Mello | 00:00 |
| Re: Ran out of connections | Steve Crawford | 00:25 |
| Regarding boolean datatype | kanika singh | 09:11 |
| Re: Backend message type 0x50 arrived while idle | Thrasher | 09:27 |
| Re: Query about table and catalog | Christoph Haller | 09:44 |
| Re: Regarding boolean datatype | Richard Huxton | 10:29 |
| Re: Regarding boolean datatype | kanika singh | 11:04 |
| Re: master-detail relationship and count | Ross J. Reedstrom | 19:38 |
| Thread | Author | Time |
|---|---|---|
| Case-insensitive | Pedro Igor | 12:33 |
| Re: Case-insensitive | Richard Huxton | 13:11 |
| Accent-insensitive | Pedro Igor | 13:30 |
| Rules/Trigges Trade-offs | Jean-Luc Lachance | 16:03 |
| Re: Rules/Trigges Trade-offs | Richard Huxton | 16:31 |
| Re: Rules/Trigges Trade-offs | Bruce Momjian | 16:34 |
| Re: Rules/Trigges Trade-offs | Jean-Luc Lachance | 17:30 |
| Re: Rules/Trigges Trade-offs | Bruce Momjian | 17:41 |
| order by a "select as" determined by case statement | FatTony | 18:05 |
| Re: order by a "select as" determined by case statement | Stephan Szabo | 18:16 |
| SELECT FOR UPDATE locks whole table | D'Arcy J.M. Cain | 19:03 |
| Re: SELECT FOR UPDATE locks whole table | Bruce Momjian | 19:10 |
| Re: Accent-insensitive | Cédric Dufour (public) | 20:33 |
| Re: Accent-insensitive | Joel Burton | 22:17 |
| Re: SELECT FOR UPDATE locks whole table | Tom Lane | 23:00 |
| Re: Rules/Trigges Trade-offs | Josh Berkus | 23:25 |
| Re: Rules/Trigges Trade-offs | Bruce Momjian | 23:30 |
| Re: Rules/Trigges Trade-offs | Josh Berkus | 23:54 |
| Thread | Author | Time |
|---|---|---|
| Re: Rules/Trigges Trade-offs | Bruce Momjian | 02:24 |
| Re: Rules/Trigges Trade-offs | Bruce Momjian | 03:43 |
| Re: [SQL] SELECT FOR UPDATE locks whole table | D'Arcy J.M. Cain | 13:17 |
| Re: Accent-insensitive | Joel Burton | 21:19 |
| Thread | Author | Time |
|---|---|---|
| adding a GROUP BY to an outer join | Dan Langille | 03:38 |
| Default Permissions (repost from Novice) | Michael Weaver | 06:51 |
| sql | cristi | 10:40 |
| Re: sql | Richard Huxton | 12:04 |
| ISNULL FUNCTION | Héctor Iturre | 14:30 |
| ISNULL FUNCTION | Héctor Iturre | 14:30 |
| Re: ISNULL FUNCTION | Ludwig Lim | 14:42 |
| Adding foreign key constraint post table creation | Charles Hauser | 16:11 |
| Re: Rules/Trigges Trade-offs | Jean-Luc Lachance | 16:11 |
| Re: Default Permissions (repost from Novice) | Richard Huxton | 16:28 |
| Re: Rules/Trigges Trade-offs | Josh Berkus | 20:06 |
| Re: Rules/Trigges Trade-offs | Josh Berkus | 20:40 |
| Re: Rules/Trigges Trade-offs | Josh Berkus | 20:48 |
| Problem with a lookup table! Please help. | Chris Jewell | 20:58 |
| Re: [OT] Inventory systems (private) | Troy | 21:01 |
| Re: Problem with a lookup table! Please help. | Josh Berkus | 21:08 |
| Re: Problem with a lookup table! Please help. | Jean-Luc Lachance | 21:34 |
| Re: Problem with a lookup table! Please help. | Chris Jewell | 22:21 |
| Thread | Author | Time |
|---|---|---|
| Re: ISNULL FUNCTION | 2000 Informática | 01:53 |
| Re: Problem with a lookup table! Please help. | Oliver Elphick | 02:07 |
| SQL syntax for concating values in different rows together | Elizabeth O'Neill's Office Mail | 12:27 |
| Re: SQL syntax for concating values in different rows together | Roberto Mello | 16:10 |
| Re: SQL syntax for concating values in different rows together | Joe Conway | 18:31 |
| Thread | Author | Time |
|---|---|---|
| is numeric relational operator problem fixed in v7.3 | jack | 02:54 |
| Re: is numeric relational operator problem fixed in v7.3 | Oliver Elphick | 03:08 |
| Question | Jonathan Man | 06:44 |
| Re: Question | Christoph Haller | 08:57 |