Re: allow LIMIT in UPDATE and DELETE

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: allow LIMIT in UPDATE and DELETE
Дата
Msg-id 28677.1148046663@sss.pgh.pa.us
обсуждение исходный текст
Ответ на allow LIMIT in UPDATE and DELETE  (Csaba Nagy <nagy@ecircle-ag.com>)
Ответы Re: allow LIMIT in UPDATE and DELETE  (Csaba Nagy <nagy@ecircle-ag.com>)
Список pgsql-general
Csaba Nagy <nagy@ecircle-ag.com> writes:
> Currently the LIMIT clause is not allowed in UPDATE or DELETE
> statements. I wonder how easy it would be to allow it, and what people
> think about it ?

This has been proposed before, and rejected before, and the arguments
against are just as strong as they were before.  See the archives.

            regards, tom lane

В списке pgsql-general по дате отправления:

Предыдущее
От: Csaba Nagy
Дата:
Сообщение: Re: allow LIMIT in UPDATE and DELETE
Следующее
От: Tom Lane
Дата:
Сообщение: Re: VACUUM FULL hangs on ordinary table