Re: DELETE with LIMIT (or my first hack)

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: DELETE with LIMIT (or my first hack)
Дата
Msg-id 25464.1291129460@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: DELETE with LIMIT (or my first hack)  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: DELETE with LIMIT (or my first hack)  (Robert Haas <robertmhaas@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: GiST insert algorithm rewrite
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: DELETE with LIMIT (or my first hack)