Re: [INTERFACES] limiting the rows selected in postgresql

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;

-Jose'-