Re: DELETE with LIMIT (or my first hack)

Поиск
Список
Период
Сортировка
От Jaime Casanova
Тема Re: DELETE with LIMIT (or my first hack)
Дата
Msg-id AANLkTi=unAuVdMxY0ia-FoHy2tFDi1iaK=OnpSLEKaR+@mail.gmail.com
обсуждение исходный текст
Ответ на Re: DELETE with LIMIT (or my first hack)  (Daniel Loureiro <loureirorg@gmail.com>)
Ответы Re: DELETE with LIMIT (or my first hack)  (Robert Haas <robertmhaas@gmail.com>)
Re: DELETE with LIMIT (or my first hack)  (Marti Raudsepp <marti@juffo.org>)
Список pgsql-hackers
On Mon, Nov 29, 2010 at 9:55 PM, Daniel Loureiro <loureirorg@gmail.com> wrote:
> good point. But when you use a LIMIT in a SELECT statement you WANT n RANDOM
> tuples

no. at least IMHO the only sensible way that LIMIT is usefull is with
an ORDER BY clause with make the results very well defined...

--
Jaime Casanova         www.2ndQuadrant.com
Professional PostgreSQL: Soporte y capacitación de PostgreSQL


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: [GENERAL] column-level update privs + lock table
Следующее
От: Robert Haas
Дата:
Сообщение: Re: DELETE with LIMIT (or my first hack)