| From: | Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com> |
|---|---|
| To: | Abaco informática s(dot)a(dot) <abasoft(at)ciudad(dot)com(dot)ar> |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: Error in sql sintax |
| Date: | 2004-11-13 21:41:53 |
| Message-ID: | 20041113133952.E44723@megazone.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On Tue, 9 Nov 2004, [iso-8859-1] Abaco informtica s.a. wrote:
> this sentence is accepted by postgresql sintax analizer but we think
> that's incorrect:
>
> select * from table T where T.field = table.field_1
>
> it take the result as an inner join between 'T' and 'table' which not
> exist ... just exists 'T'.
Yes, because PostgreSQL adds defined behavior for such queries beyond that
of the spec for queries which reference tables not mentioned in the from
clause. In recent versions this can be controlled by a runtime parameter
(add_missing_from).
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Magnus Hagander | 2004-11-14 13:07:02 | Re: Unable to run PostgreSQL 8 beta 3 on Windows XP Home |
| Previous Message | David Walker | 2004-11-13 20:15:38 | libplperl.so and libperl.so |