ok, sorry, I've realized that it's yet another example of "outer
reference", Tom will say "read any SQL book" again :-)
http://archives.postgresql.org/pgsql-bugs/2006-12/msg00115.php
On 12/19/06, Nikolay Samokhvalov <samokhvalov(at)gmail(dot)com> wrote:
> 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
>
--
Best regards,
Nikolay