Re: DELETE with LIMIT (or my first hack) - Mailing list pgsql-hackers

From Tom Lane
Subject Re: DELETE with LIMIT (or my first hack)
Date
Msg-id 25464.1291129460@sss.pgh.pa.us
Whole thread Raw
In response to Re: DELETE with LIMIT (or my first hack)  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: DELETE with LIMIT (or my first hack)
List pgsql-hackers
Robert Haas <robertmhaas@gmail.com> writes:
> On Mon, Nov 29, 2010 at 11:25 PM, Andrew Dunstan <andrew@dunslane.net> wrote:
>> I can't say I'd be excited by this feature. In quite a few years of writing
>> SQL I don't recall ever wanting such a gadget.

> It's something I've wanted periodically, though not badly enough to do
> the work to make it happen.

It would certainly look like nothing but a crude hack if the feature is
only available for DELETE and not UPDATE.  Unfortunately, the UPDATE
case would be an order of magnitude harder (think inheritance trees
where the children aren't all alike).
        regards, tom lane


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: GiST insert algorithm rewrite
Next
From: Andrew Dunstan
Date:
Subject: Re: DELETE with LIMIT (or my first hack)