Re: LIMIT for UPDATE and DELETE - Mailing list pgsql-hackers

From Etsuro Fujita
Subject Re: LIMIT for UPDATE and DELETE
Date
Msg-id 5417EF55.7020702@lab.ntt.co.jp
Whole thread Raw
In response to LIMIT for UPDATE and DELETE  (Rukh Meski <rukh.meski@gmail.com>)
Responses Re: LIMIT for UPDATE and DELETE
List 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 by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: Anonymous code block with parameters
Next
From: Pavel Stehule
Date:
Subject: Re: Anonymous code block with parameters