Re: [SQL] Controlling Reuslts with Limit

[Tom Lane]

Najm Hashmi <[EMAIL PROTECTED]> 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