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 <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster