On 5/19/06, Csaba Nagy <[EMAIL PROTECTED]> 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/
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
