Received: from lin.local.lan ([216.221.221.2]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f1NL3cx04764 for ; Fri, 23 Feb 2001 16:03:38 -0500 (EST) (envelope-from najm@mondo-live.com) Received: from mondo-live.com (IDENT:najm@najm.local2.lan [192.168.2.20]) by lin.local.lan (8.9.3/8.8.7) with ESMTP id UAA08617 for ; Fri, 23 Feb 2001 20:36:09 GMT Message-ID: <3A9822F2.FF9437C9@mondo-live.com> Date: Sat, 24 Feb 2001 16:09:06 -0500 From: Najm Hashmi X-Mailer: Mozilla 4.76 [en] (X11; U; Linux 2.2.14-5.0 i686) X-Accept-Language: en MIME-Version: 1.0 To: pgsql Subject: Controlling Reuslts with Limit Content-Type: multipart/mixed; boundary="------------3DC0C3D15632ECFB75CB685D" X-Archive-Number: 200102/365 X-Sequence-Number: 1564 This is a multi-part message in MIME format. --------------3DC0C3D15632ECFB75CB685D Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi, I was reading through Bruce's on line . I found follwing bit unclear... "Notice that each query uses ORDER BY . Although this clause is not required, LIMIT without ORDER BY returns random rows from the query, which would be useless. " When I run a query several time I get the same results as given flipr=# select song_id from songs limit 5; song_id --------- 945 946 947 948 949 (5 rows) flipr=# select song_id from songs limit 5; song_id --------- 945 946 947 948 949 (5 rows) flipr=# select song_id from songs limit 5; song_id --------- 945 946 947 948 949 (5 rows) flipr=# select song_id from songs limit 5; song_id --------- 945 946 947 948 949 (5 rows) flipr=# select song_id from songs limit 5; song_id --------- 945 946 947 948 949 (5 rows) flipr=# select song_id from songs limit 5; song_id --------- 945 946 947 948 949 I just want to know what exatly --"LIMIT without ORDER BY returns random rows from the query" --means Regards --------------3DC0C3D15632ECFB75CB685D Content-Type: text/x-vcard; charset=us-ascii; name="najm.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Najm Hashmi Content-Disposition: attachment; filename="najm.vcf" begin:vcard n:Hashmi;Najm x-mozilla-html:FALSE org:Mondo-Live.com;www.flipr.com adr:;;;;;; version:2.1 email;internet:najm@mondo-live.com x-mozilla-cpt:;6144 fn:Najm Hashmi end:vcard --------------3DC0C3D15632ECFB75CB685D--