Re: [INTERFACES] limiting the rows selected in postgresql

On Sat, 7 Nov 1998, Sergio wrote:

Date: Sat, 7 Nov 1998 13:39:27 -0300
From: Sergio <ser@perio.unlp.edu.ar>
To: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] limiting the rows selected in postgresql

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,

be patient. Jan Wieck is working on patch for support LIMIT in select query.
I'm using his patch (trial 2) with 6.4 and it works great for me.
With this patch you can limit output using LIMIT offset,count statement.
Hope, this patch will come to 6.4.1.

Regards,

Oleg

PS. Browse hackers mailing list for last month to read discussion on
this subject.

Sergio

_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83

I did this with:-

declare tmp cursor for select * from table;fetch forward 10 in tmp;

But if someone else has a better way, please let me know....

On Sat, 7 Nov 1998, Sergio wrote:

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

James (james@linuxrocks.co.uk)
Vortex Internet
My Windows unders~1 long filena~1, and yours?