From: Sergio <ser@perio.unlp.edu.ar>
To: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] limiting the rows selected in postgresql
Date: Sat, 7 Nov 1998 13:39:27 -0300
Message-ID: <SAK.7.11.1998.bqqscjfl@speedy.perio.unlp.edu.ar> (raw)
In-Reply-To: <7606.981109@bo.nettuno.it>
Sferacarta Software <sferac@bo.nettuno.it> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: ser@perio.unlp.edu.ar
Subject: Re: [INTERFACES] limiting the rows selected in postgresql
In-Reply-To: <SAK.7.11.1998.bqqscjfl@speedy.perio.unlp.edu.ar>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox