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)
Re: DELETE with LIMIT (or my first hack)
Список 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 по дате отправления: