Discussion for users on SQL related matters.
| Thread | Author | Time |
|---|---|---|
| Need help 📎 | Shamik Majumder | 11:51 |
| Re: PostgreSQL SELECT error | Calvin Dodge | 23:50 |
| Thread | Author | Time |
|---|---|---|
| Re: [SQL] An easy question about creating a primary key | Christopher Kings-Lynne | 03:36 |
| Re: [SQL] Unpredictable text -> date implicit casting behaviour/to_date bug 📎 | Karel Zak | 13:04 |
| OUTER JOIN doesn't work on pgSQL 7.1.2 | Alex Glikson | 13:31 |
| Re: [SQL] Unpredictable text -> date implicit casting behaviour/to_date | Bruce Momjian | 18:26 |
| Re: Tree structure index usage | Josh Berkus | 19:38 |
| Getting Hour From a Time in Different Time Zone | Tom Kreiner | 21:45 |
| Re: [SQL] Unpredictable text -> date implicit casting behaviour/to_date bug | Tom Lane | 22:10 |
| Thread | Author | Time |
|---|---|---|
| Re: top? | Christopher Kings-Lynne | 01:59 |
| maintaining a field for every UPDATION. | Bhuvan A | 06:47 |
| Re: How to union tables and have a field with UNIQUE constraint? | Katona Gabor | 08:08 |
| Re: maintaining a field for every UPDATION. | Stephan Szabo | 08:19 |
| Re: SQL syntax help needed | Bjrn Lundin | 13:25 |
| Re: SQL syntax help needed | Bjrn Lundin | 13:28 |
| Re: top? | SHELTON,MICHAEL (Non-HP-Boise,ex1) | 14:40 |
| Execute dynamically generated query??? | Unnikrishnan Menon | 14:55 |
| Re: left join and where | Masaru Sugawara | 15:18 |
| Telling how many records are joined | Andrew Perrin | 16:29 |
| simple? join | Frank Bax | 17:10 |
| Re: Telling how many records are joined | Bill Cunningham | 19:20 |
| Re: change null to 0 in SQL script | ThomasR | 19:52 |
| Thread | Author | Time |
|---|---|---|
| Re: SQL syntax help needed | Chris Sypolt | 00:05 |
| who has lock on table/row | Mir S Islam | 01:06 |
| Re: SQL syntax help needed | Bjrn Lundin | 13:09 |
| Which date/paper pairs are NOT represented? | Andrew Perrin | 20:37 |
| Re: change null to 0 in SQL script | Karl Raven | 20:54 |
| Thread | Author | Time |
|---|---|---|
| Re: simple? join | Peter Eisentraut | 05:22 |
| Thread | Author | Time |
|---|---|---|
| nested inner join help | Darryl M. Wolski | 05:37 |
| Re: Error trying to create a functional index. | CoL | 11:01 |
| Re: create table with multiple unique fields | steve boyle | 12:58 |
| Postgres vs. Redhat DB | Hunter, Ray | 17:14 |
| Uisng Procedures via JDBC | Michaell Oxtoby | 17:42 |
| Re: Which date/paper pairs are NOT represented? | Peter Eisentraut | 18:10 |
| Re: Conditional test | steve boyle | 18:46 |
| Re: simple? join | Frank Bax | 22:08 |
| Re: simple? join | Peter Eisentraut | 22:52 |
| SELECT * FROM xy WHERE name LIKE '%german special char' | Albrecht Berger | 23:23 |
| Re: simple? join | Tom Lane | 23:25 |
| Thread | Author | Time |
|---|---|---|
| Re: [SQL] Need help | Doug McNaught | 00:04 |
| Re: Postgres vs. Redhat DB | Marc G. Fournier | 05:30 |
| Re: Postgres vs. Redhat DB | Tom Lane | 06:14 |
| Re: [GENERAL] Need help | Maarten.Boekhold | 09:47 |
| Re: SQL Joins | steve boyle | 11:31 |
| Nested loops and $13 | Torbj=?ISO-8859-1?B?9g==?=rn Andersson | 14:19 |
| Re: Nested loops and $13 | Tom Lane | 15:37 |
| Re: Nested loops and $13 | Torbj=?ISO-8859-1?B?9g==?=rn Andersson | 16:02 |
| Re: Porting Oracle Packages | Roberto Mello | 16:04 |
| problem with date and to_char | postgresql | 16:17 |
| Re: Nested loops and $13 | Torbj=?ISO-8859-1?B?9g==?=rn Andersson | 16:41 |
| Thread | Author | Time |
|---|---|---|
| Re: problem with date and to_char | Josh Berkus | 00:19 |
| Re: problem with date and to_char | Tom Lane | 00:49 |
| Re: problem with date and to_char | Josh Berkus | 01:13 |
| converting an epoch to a timestamp | Christopher Kings-Lynne | 01:25 |
| Re: converting an epoch to a timestamp | Tom Lane | 01:59 |
| Result sets from functions | Kevin Zapico | 08:23 |
| Resources | Gurudutt | 13:33 |
| Re: Resources | Jason Earl | 15:50 |
| Re: Resources | Nick Fankhauser | 15:54 |
| Re: Resources | Stephan Szabo | 16:12 |
| Grant all to Public & adding users | Marc Mitchell | 18:38 |
| Re: Resources | Wei Weng | 20:33 |
| Re: Grant all to Public & adding users | Tom Lane | 20:44 |
| Re: Grant all to Public & adding users | Peter Eisentraut | 20:50 |
| Re: Resources | SHELTON,MICHAEL (Non-HP-Boise,ex1) | 21:59 |
| Re: Resources | Tom Lane | 22:09 |
| replication | Peter T. Brown | 22:27 |
| Re: Result sets from functions | steve boyle | 22:53 |
| Temporary tables | SHELTON,MICHAEL (Non-HP-Boise,ex1) | 23:02 |
| Recall: Temporary tables | SHELTON,MICHAEL (Non-HP-Boise,ex1) | 23:06 |
| Re: [SQL] replication | Bryan White | 23:34 |
| Re: replication | David Stanaway | 23:35 |
| Thread | Author | Time |
|---|---|---|
| Search The pg.pm | Ali Gumus | 00:08 |
| Re: Resources | Gurudutt | 13:03 |
| Re: Resources | Nick Fankhauser | 13:45 |
| Re: Resources | Isabelle Brette | 14:17 |
| Re: Resources | Frank Bax | 16:09 |
| Re: Resources | Nick Fankhauser | 16:13 |
| Re: Resources | jtp | 16:23 |
| Re: Resources | Frank Bax | 16:27 |
| Re: Resources | Nick Fankhauser | 16:56 |
| Re: Temporary tables | Peter T. Brown | 17:17 |
| Re: Resources | Chester Carlton Young | 17:39 |
| Re: Resources | Frank Bax | 19:18 |
| Re: Resources | Frank Bax | 21:13 |
| Re: who has lock on table/row | Tom Lane | 22:01 |
| Thread | Author | Time |
|---|---|---|
| Re: How to union tables and have a field with UNIQUE constraint? | Stephan Szabo | 00:51 |
| triggered data change violation | Murray Prior Hobbs | 13:41 |
| Re: triggered data change violation | Tom Lane | 16:19 |
| Re: triggered data change violation | Murray Prior Hobbs | 22:54 |
| Thread | Author | Time |
|---|---|---|
| Re: create table with multiple unique fields | elisabeth maniez | 08:23 |
| Problems with PL/PGSQL - functions | Unnikrishnan Menon | 14:37 |
| Re: Problems with PL/PGSQL - functions | Ross J. Reedstrom | 16:19 |
| Re: Problems with PL/PGSQL - functions | Tom Lane | 16:59 |
| Commercial: New Book!! PostgreSQL book is released into the market | Al Dev | 18:08 |
| Problem with unique index | Sharon Cowling | 20:23 |
| Re: Problem with unique index | Stephan Szabo | 20:50 |
| Re: Problem with unique index | Tom Lane | 20:53 |
| pg with different sql? | Paulo J. Matos | 22:04 |
| Re: pg with different sql? | Ian Barwick | 22:38 |
| Re: pg with different sql? | Jean-Luc Lachance | 22:38 |
| Re: pg with different sql? | Tom Lane | 22:39 |
| Re: pg with different sql? | George Moga | 23:01 |
| Thread | Author | Time |
|---|---|---|
| Re: nested inner join help | Josh Berkus | 01:01 |
| Re: Long-running DELETE...WHERE... | Tom Lane | 01:21 |
| Re: Long-running DELETE...WHERE... | Chester Carlton Young | 02:04 |
| Re: Resources - Regular Expressions | Gurudutt | 04:45 |
| Re: On delete cascade! | Roberto Mello | 06:29 |
| Problem with the postgresql operator. | KH Lim | 06:39 |
| Re: Problem with the postgresql operator. | Oliver Elphick | 10:35 |
| Re: On delete cascade! | Steve Boyle (Roselink) | 11:32 |
| Re: Date Time calculation help | Steve Boyle (Roselink) | 12:39 |
| Hierarchical queries | Paulo Rodrigues | 13:39 |
| Re: Resources - Regular Expressions | Jeff Eckermann | 15:03 |
| Re: Problem with the postgresql operator. | GB Clark | 15:56 |
| Re: Hierarchical queries | Josh Berkus | 16:33 |
| Re: Hierarchical queries | Paulo Rodrigues | 16:46 |
| Re: Hierarchical queries | Wei Weng | 16:47 |
| Re: Hierarchical queries | Steve Boyle (Roselink) | 16:58 |
| Long-running DELETE | Jeff Boes | 19:02 |
| Re: Problem with the postgresql operator. | Josh Berkus | 19:10 |
| Re: Long-running DELETE...WHERE... | Frank Bax | 19:22 |