Received: from sss.pgh.pa.us (sss.pgh.pa.us [209.114.132.154]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f1NLdVx09056 for ; Fri, 23 Feb 2001 16:39:31 -0500 (EST) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.1/8.11.1) with ESMTP id f1NLdS900657; Fri, 23 Feb 2001 16:39:28 -0500 (EST) To: Najm Hashmi cc: pgsql Subject: Re: Controlling Reuslts with Limit In-reply-to: <3A9822F2.FF9437C9@mondo-live.com> References: <3A9822F2.FF9437C9@mondo-live.com> Comments: In-reply-to Najm Hashmi message dated "Sat, 24 Feb 2001 16:09:06 -0500" Date: Fri, 23 Feb 2001 16:39:27 -0500 Message-ID: <654.982964367@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200102/369 X-Sequence-Number: 1570 Najm Hashmi 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