Re: allow LIMIT in UPDATE and DELETE - Mailing list pgsql-general

From chris smith
Subject Re: allow LIMIT in UPDATE and DELETE
Date
Msg-id 3c1395330605190543l1db1489bmc9dacc4da6f85384@mail.gmail.com
Whole thread Raw
In response to allow LIMIT in UPDATE and DELETE  (Csaba Nagy <nagy@ecircle-ag.com>)
Responses Re: allow LIMIT in UPDATE and DELETE  (Csaba Nagy <nagy@ecircle-ag.com>)
List pgsql-general
On 5/19/06, Csaba Nagy <nagy@ecircle-ag.com> wrote:
> Hi all,
>
> 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 ? For our application it would help a lot when processing
> things chunk-wise to avoid long running queries.

I asked that question a while ago..

http://archives.postgresql.org/pgsql-general/2005-04/msg00386.php

and got this response:

http://archives.postgresql.org/pgsql-general/2005-04/msg00387.php

Works quite well :)
--
Postgresql & php tutorials
http://www.designmagick.com/

pgsql-general by date:

Previous
From: Robert Treat
Date:
Subject: Re: Contributing code
Next
From: "Dawid Kuroczko"
Date:
Subject: Re: allow LIMIT in UPDATE and DELETE