Postgres Pro
Downloads
Home   >   mailing lists

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

From Jaime Casanova
Subject Re: DELETE with LIMIT (or my first hack)
Date
Msg-id AANLkTi=unAuVdMxY0ia-FoHy2tFDi1iaK=OnpSLEKaR+@mail.gmail.com
Whole thread Raw
In response to Re: DELETE with LIMIT (or my first hack)  (Daniel Loureiro <loureirorg@gmail.com>)
Responses Re: DELETE with LIMIT (or my first hack)
Re: DELETE with LIMIT (or my first hack)
List pgsql-hackers
Tree view 
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 by date:

Previous
From: Robert Haas
Date:
Subject: Re: [GENERAL] column-level update privs + lock table
Next
From: Robert Haas
Date:
Subject: Re: DELETE with LIMIT (or my first hack)