On Thu, Dec 2, 2010 at 7:12 PM, Bruce Momjian <br...@momjian.us> wrote: > Peter Eisentraut wrote: >> On tis, 2010-11-30 at 14:20 -0500, Andrew Dunstan wrote: >> > I agree, that argument is completely misconceived. If the DBA is >> > paying enough attention to use LIMIT, s/he should be paying enough >> > attention not to do damage in the first place. If that were the only >> > argument in its favor I'd be completely against the feature. >> >> I don't have any use for DELETE with LIMIT, but UPDATE with LIMIT could >> be very useful if you are doing full-table updates and you don't have >> enough space so you do it in chunks. > > So should this now be a TODO item? Text?
Allow DELETE and UPDATE to be used with LIMIT and ORDER BY. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
