No error when FROM is missing in subquery - Mailing list pgsql-bugs

From Nikolay Samokhvalov
Subject No error when FROM is missing in subquery
Date
Msg-id e431ff4c0612181501xadf238dg6ea727f1acd22d0d@mail.gmail.com
Whole thread Raw
Responses Re: No error when FROM is missing in subquery
List 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

pgsql-bugs by date:

Previous
From: "Thomas Jahnsen"
Date:
Subject: BUG #2838: Compile error "tab-complete.c" on Mac OS X
Next
From: "Nikolay Samokhvalov"
Date:
Subject: Re: No error when FROM is missing in subquery