No error when FROM is missing in subquery

Поиск
Список
Период
Сортировка
От Nikolay Samokhvalov
Тема No error when FROM is missing in subquery
Дата
Msg-id e431ff4c0612181501xadf238dg6ea727f1acd22d0d@mail.gmail.com
обсуждение исходный текст
Ответы Re: No error when FROM is missing in subquery  ("Nikolay Samokhvalov" <samokhvalov@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: "Thomas Jahnsen"
Дата:
Сообщение: BUG #2838: Compile error "tab-complete.c" on Mac OS X
Следующее
От: "Nikolay Samokhvalov"
Дата:
Сообщение: Re: No error when FROM is missing in subquery