Error in sql sintax

From: Abaco informática s(dot)a(dot) <abasoft(at)ciudad(dot)com(dot)ar>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: Error in sql sintax
Date: 2004-11-09 12:37:41
Message-ID: 000801c4c658$e87fd550$2bbbfea9@RICDOS
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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'.

this occurs in linux versions and windows versions.

Thanks for your attention.
bye.
Ricardo Solanilla

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Craig Ruff 2004-11-09 15:01:16 Re: Deadlock or other hang while vacuuming?
Previous Message Fabio 2004-11-09 12:15:17 Bug no tipo de dados "text" do PostgreSQL 8.0-beta1