On 5/19/06, Csaba Nagy <nagy(at)ecircle-ag(dot)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/