Re: LIMIT for UPDATE and DELETE

Поиск
Список
Период
Сортировка
От Etsuro Fujita
Тема Re: LIMIT for UPDATE and DELETE
Дата
Msg-id 5417EF55.7020702@lab.ntt.co.jp
обсуждение исходный текст
Ответ на LIMIT for UPDATE and DELETE  (Rukh Meski <rukh.meski@gmail.com>)
Ответы Re: LIMIT for UPDATE and DELETE  (Kevin Grittner <kgrittn@ymail.com>)
Список pgsql-hackers
(2014/08/15 6:18), Rukh Meski wrote:
> Based on the feedback on my previous patch, I've separated only the
> LIMIT part into its own feature.  This version plays nicely with
> inheritance.  The intended use is splitting up big UPDATEs and DELETEs
> into batches more easily and efficiently.

IIUC, the patch doesn't support OFFSET with UPDATE/DELETE ... LIMIT.  Is 
that OK?  When we support ORDER BY ... LIMIT/OFFSET, we will also be 
allowing for OFFSET with UPDATE/DELETE ... LIMIT.  So, ISTM it would be 
better for the patch to support OFFSET at this point.  No?

Thanks,

Best regards,
Etsuro Fujita



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

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: Anonymous code block with parameters
Следующее
От: Pavel Stehule
Дата:
Сообщение: Re: Anonymous code block with parameters