On 5/19/06, Csaba Nagy <nagy@xxxxxxxxxxxxxx> 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/