No error when FROM is missing in subquery

From: "Nikolay Samokhvalov" <samokhvalov(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: No error when FROM is missing in subquery
Date: 2006-12-18 23:01:22
Message-ID: e431ff4c0612181501xadf238dg6ea727f1acd22d0d@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Following query is considered as correct, no "missing from" error has
been reported (so, entire table will be updated and "on update"
triggers will be fired for every row):

update item set obj_id = obj_id
where obj_id in (select obj_id where item_point is null order by
obj_modified limit 10)

Is it a bug? If no, maybe to produce warning in such cases?

--
Best regards,
Nikolay

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Nikolay Samokhvalov 2006-12-18 23:15:03 Re: No error when FROM is missing in subquery
Previous Message Thomas Jahnsen 2006-12-18 19:39:09 BUG #2838: Compile error "tab-complete.c" on Mac OS X