Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: allow LIMIT in UPDATE and DELETE
Date
Msg-id 28677.1148046663@sss.pgh.pa.us
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
List pgsql-general
Tree view 
Csaba Nagy <nagy@ecircle-ag.com> writes:
> 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 ?

This has been proposed before, and rejected before, and the arguments
against are just as strong as they were before.  See the archives.

            regards, tom lane

pgsql-general by date:

Previous
From: Csaba Nagy
Date:
Subject: Re: allow LIMIT in UPDATE and DELETE
Next
From: Tom Lane
Date:
Subject: Re: VACUUM FULL hangs on ordinary table