Received: from mail.postgresql.org (webmail.postgresql.org [216.126.85.28]) by mail.postgresql.org (8.11.3/8.11.1) with SMTP id f2PJM8w48675 for ; Sun, 25 Mar 2001 14:22:08 -0500 (EST) (envelope-from pgsql-sql-owner@postgresql.org) Received: from cesma.com.sg ([203.126.155.34]) by mail.postgresql.org (8.11.3/8.11.1) with SMTP id f2N3Ycw67546 for ; Thu, 22 Mar 2001 22:34:43 -0500 (EST) (envelope-from weetat@cesma.com.sg) Received: (qmail 12281 invoked from network); 23 Mar 2001 03:38:21 -0000 Received: from unknown (HELO cesma.com.sg) (wt@192.168.0.27) by 203.126.155.34 with SMTP; 23 Mar 2001 03:38:21 -0000 Message-ID: <3ABAC5E2.25156979@cesma.com.sg> Date: Fri, 23 Mar 2001 11:41:22 +0800 From: Ricky X-Mailer: Mozilla 4.61 [en] (X11; I; Linux 2.2.13-0.13 i686) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Limit clause is not working in Postgresql7.0.2 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200103/492 X-Sequence-Number: 2163 Hi all , I tried to do a select statement below : select * from homeuser order userid limit 5; However it did not working ,it display all the records in the database. You all have any ideas how to use limit clause ?? Thanks weetat