Received: from trends.net (root@clio.trends.ca [209.47.148.2]) by hub.org (8.9.1/8.9.1) with ESMTP id OAA05203 for ; Mon, 9 Nov 1998 14:38:34 -0500 (EST) (envelope-from ser@info.perio.unlp.edu.ar) Received: from unlp.unlp.edu.ar (unlp.unlp.edu.ar [163.10.0.67]) by trends.net (8.8.8/8.8.8) with ESMTP id NAA07974 for ; Mon, 9 Nov 1998 13:25:47 -0500 (EST) Received: from info.perio.unlp.edu.ar (root@perio.unlp.edu.ar [163.10.16.2]) by unlp.unlp.edu.ar (8.8.8/8.8.8) with ESMTP id SAA06094 for ; Mon, 9 Nov 1998 18:17:52 GMT Received: from speedy.perio.unlp.edu.ar ([163.10.16.29]) by info.perio.unlp.edu.ar (8.8.5/8.8.5) with SMTP id PAA03122 for ; Mon, 9 Nov 1998 15:36:10 GMT From: Sergio Message-Id: In-Reply-To: <7606.981109@bo.nettuno.it> Date: Sat, 7 Nov 1998 13:39:27 -0300 X-Priority: 3 X-Mailer: Correo Fácil To: pgsql-interfaces@postgreSQL.org Subject: Re: [INTERFACES] limiting the rows selected in postgresql MIME-Version: 1.0 Content-Type: Text/Plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit Sferacarta Software el día Mon, 9 Nov 1998 14:33:06 +0100, escribió: >Hello Radhakrishnan, > >lunedì, 9 novembre 98, you wrote: > > >RCV> how can i limit the number of rows obtained from a select statement >RCV> in postgreSQL to say, 10 rows while the select condition actually >RCV> matches more than that. in oracle we can use the ROW_NUM variable >RCV> for this purpose but now i met such an issue with postgreSQL > >On v6.4 you can specify a limit for queries as: > >set QUERY_LIMIT TO '10'; >To have only the first 10 rows from a select; this will limit _all_ the querys, right ? wich is not very flexible. I can't do something like select * from news order by news_date limit 10 ? Sergio