Re: Controlling Reuslts with Limit - Mailing list pgsql-sql

From Tom Lane
Subject Re: Controlling Reuslts with Limit
Date
Msg-id 654.982964367@sss.pgh.pa.us
Whole thread Raw
In response to Controlling Reuslts with Limit  (Najm Hashmi <najm@mondo-live.com>)
List pgsql-sql
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


pgsql-sql by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Controlling Reuslts with Limit
Next
From: Stephan Szabo
Date:
Subject: Re: Controlling Reuslts with Limit