Discussion for users on SQL related matters.
| Thread | Author | Time | 
|---|---|---|
| Re: [HACKERS] | Chris Bitmead | 00:02 | 
| Re: possible bug with group by? | Tom Lane | 02:59 | 
| Re: Use of index in 7.0 vs 6.5 | Tom Lane | 03:12 | 
| Re: Use of index in 7.0 vs 6.5 | Ryan Bradetich | 03:57 | 
| Re: [SQL] | Michael A. Mayo | 04:54 | 
| Re: Use of index in 7.0 vs 6.5 | Tom Lane | 06:14 | 
| RE: Use of index in 7.0 vs 6.5 | Hiroshi Inoue | 07:19 | 
| RE: Use of index in 7.0 vs 6.5 | Mikheev, Vadim | 14:29 | 
| Re: Use of index in 7.0 vs 6.5 | Tom Lane | 14:39 | 
| Re: Use of index in 7.0 vs 6.5 | Bruce Momjian | 15:11 | 
| Re: Use of index in 7.0 vs 6.5 | Jeff Hoffmann | 15:30 | 
| Re: Use of index in 7.0 vs 6.5 | Tom Lane | 16:03 | 
| Re: Use of index in 7.0 vs 6.5 | Tom Lane | 16:08 | 
| Re: Use of index in 7.0 vs 6.5 | Bruce Momjian | 16:08 | 
| RE: Use of index in 7.0 vs 6.5 | Mikheev, Vadim | 16:12 | 
| RE: Use of index in 7.0 vs 6.5 | Mikheev, Vadim | 17:17 | 
| Re: Use of index in 7.0 vs 6.5 | Ryan Bradetich | 23:40 | 
| Thread | Author | Time | 
|---|---|---|
| Re: Re: [SQL] aliases break my query | Mike Mascari | 01:45 | 
| Re: Re: [SQL] aliases break my query | Tom Lane | 04:06 | 
| Re: New Type | selkovjr | 07:22 | 
| joins again | CB | 10:29 | 
| Re: joins again | Erol Oz | 11:41 | 
| PL/pgSQL | Antony Sakellariou | 20:03 | 
| Thread | Author | Time | 
|---|---|---|
| Re: Re: [SQL] aliases break my query | Andreas Zeugswetter | 07:34 | 
| plpgsql variable substitution problem ... | Greg Wickham | 17:48 | 
| Re: plpgsql variable substitution problem ... | Tom Lane | 18:15 | 
| Thread | Author | Time | 
|---|---|---|
| date format | Carolyn Wong | 05:37 | 
| Rollback & Nextval fails | Eriksson, Fredrik | 08:54 | 
| Antw: Rollback & Nextval fails | Gerhard Dieringer | 09:44 | 
| Re: Rollback & Nextval fails | Grant Finnemore | 09:50 | 
| adding fields containing NULL values | Werner Modenbach | 11:58 | 
| Re: adding fields containing NULL values | Grant Finnemore | 13:43 | 
| template or index of some kind 📎 | Bernie Huang | 16:21 | 
| constraint 📎 | Bernie Huang | 17:22 | 
| Re: constraint | Jan Wieck | 20:59 | 
| storing images! 📎 | Bernie Huang | 21:09 | 
| Thread | Author | Time | 
|---|---|---|
| does the' text' type cann't store more than 20,000char ? | xu hai | 01:11 | 
| Re: does the' text' type cann't store more than 20,000char ? | Mitch Vincent | 01:49 | 
| Re: [HACKERS] Re: aliases break my query | Thomas Lockhart | 02:04 | 
| Re: Pg/PLSQL Errors!! | SL Baur | 04:31 | 
| Re: Re: Pg/PLSQL Errors!! | Tom Lane | 05:58 | 
| Re: 7.0 weirdness | Peter Vazsonyi | 06:45 | 
| Re: Function-based index not used in a simple query | Rostislav Opocensky | 10:33 | 
| create view security 📎 | Wallingford, Ted | 12:45 | 
| Re: Function-based index not used in a simple query 📎 | Tom Lane | 15:53 | 
| psql problem | Rick Parker | 16:51 | 
| Re: psql problem | Ed Loehr | 17:21 | 
| Re: psql problem | Mitch Vincent | 17:36 | 
| TOP SESSIONS? 📎 | mikeo | 18:41 | 
| creating rules on joined views | Brian Powell | 18:55 | 
| Re: [HACKERS] Re: 7.0 weirdness | Jeff MacDonald | 19:00 | 
| Inheritance heirarchy | Jon Parise | 19:05 | 
| Re: create view security | Peter Eisentraut | 19:35 | 
| Re: create constraint trigger 📎 | Kyle Bateman | 19:56 | 
| Re: TOP SESSIONS? | Mike Mascari | 23:32 | 
| Thread | Author | Time | 
|---|---|---|
| Re: [SQL] Re: create view security | Jan Wieck | 02:24 | 
| question on diagnostics | Alexander H. Iliev | 03:12 | 
| Re: question on diagnostics | Tom Lane | 04:37 | 
| Re: question on diagnostics | Alexander H. Iliev | 05:07 | 
| Re: question on diagnostics | Tom Lane | 05:16 | 
| textpos() in postgreSQL 7.0 | Adam Walczykiewicz | 05:47 | 
| Data modelling tools 📎 | Jorge Garcia | 09:49 | 
| SQL Server and C++ Data Types | Jason.Weiss | 13:57 | 
| Re: textpos() in postgreSQL 7.0 | Ross J. Reedstrom | 14:10 | 
| Re: SQL'92 web resources | Bruce Momjian | 18:10 | 
| short query becomes long | mikeo | 18:24 | 
| I'm missing outer joins | bill | 19:53 | 
| Simulating CURSORS?? | p.lam | 23:59 | 
| Thread | Author | Time | 
|---|---|---|
| Re: short query becomes long | Tom Lane | 02:31 | 
| SPEED UP. | Alessandro Rossi | 06:49 | 
| Antw: Insert with replace? | Gerhard Dieringer | 07:02 | 
| RE: psql problem | Volker Paul | 07:10 | 
| pg_recvbuf : unexpected EOF on client | Adam Walczykiewicz | 09:47 | 
| Re: SPEED UP. | Mitch Vincent | 12:57 | 
| Re: SPEED UP. | Patrick Giagnocavo | 15:25 | 
| Deferral of primary key constraint 📎 | Kyle Bateman | 15:34 | 
| Benchmark | Nikolaj Lundsgaard | 18:35 | 
| Re: Deferral of primary key constraint | Jan Wieck | 19:14 | 
| Re: Benchmark | Jan Wieck | 20:58 | 
| Re: SQL'92 web resources | Peter Eisentraut | 23:46 | 
| Thread | Author | Time | 
|---|---|---|
| Re: SQL'92 web resources | Bruce Momjian | 01:46 | 
| @@Identity | Craig May | 09:26 | 
| Update table: extract max(hour). | T.J.Farrell | 20:02 | 
| LIKE vrs ~~ | T.J.Farrell | 20:31 | 
| Thread | Author | Time | 
|---|---|---|
| Ho Ho Ho !!! 6684 | qzhwjb | 00:24 | 
| Re: LIKE vrs ~~ | Peter Eisentraut | 01:46 | 
| Re: LIKE vrs ~~ | Tom Lane | 19:19 | 
| Thread | Author | Time | 
|---|---|---|
| Re: Vacuum problem in my system ? | Tom Lane | 00:08 | 
| Is it possible to "truncate" a LOB? | Stephen Crawley | 00:35 | 
| Re: [SQL] moving DB | Christopher Sawtell | 07:33 | 
| Re: Vacuum problem in my system ? | Rostislav Opocensky | 12:11 | 
| Re: moving DB | Kenn Thompson | 13:54 | 
| New book on Postgres | Ted Kennedy | 15:13 | 
| Re: New book on Postgres | bill | 15:50 | 
| Re: New book on Postgres | Pablo Prieto | 16:57 | 
| Thread | Author | Time | 
|---|---|---|
| Re: New book on Postgres | Brett W. McCoy | 00:01 | 
| how to know when a table is altered | Vincenzo Passoli | 05:24 | 
| sql doubts | Gustavo Henrique | 11:53 | 
| oracle rownum equivalent? | mikeo | 12:24 | 
| Re: sql doubts | Frank G Hahn | 13:25 | 
| Re: [SQL] oracle rownum equivalent? | Ed Loehr | 13:29 | 
| Re: how to know when a table is altered | Ed Loehr | 13:36 | 
| Re: [SQL] oracle rownum equivalent? | mikeo | 14:14 | 
| Temp table and loop call from one session | Dmitriy Yusupov | 14:21 |