Re: Controlling Reuslts with Limit

Najm Hashmi <najm@mondo-live.com> writes:
>  I just want to know what exatly --"LIMIT without ORDER BY returns random rows
> from the query" --means

It means the results aren't guaranteed.  It doesn't mean that the exact
same query run under the exact same conditions by the exact same version
of Postgres won't return the same results every time.  Especially not
one that's too simple to have more than one possible execution plan...

			regards, tom lane