Postgres Pro
Downloads
Home   >   mailing lists

limiting the rows selected in postgresql - Mailing list pgsql-interfaces

From RADHAKRISHNAN C V
Subject limiting the rows selected in postgresql
Date
Msg-id Pine.OSF.3.95.981109182032.10351B-100000@md2.vsnl.net.in
Whole thread Raw
In response to Re: [INTERFACES] crypt not included when compiling libpgtcl !!!!!!!  (Constantin Teodorescu <teo@flex.ro>)
List pgsql-interfaces
Tree view 
how can i limit the number of rows obtained from a select statement
in postgreSQL to say, 10 rows while the select condition  actually
matches more than that. in oracle we can use the ROW_NUM variable
for this purpose but now i met such an issue with postgreSQL

thanks in advance

CV Radhakrishnan

http://www.river-valley.com

pgsql-interfaces by date:

Previous
From: Jim Bowlin
Date:
Subject: libpq.o problem in Pg.pm 1.8 make test on Linux
Next
From: Sferacarta Software
Date:
Subject: Re: [INTERFACES] limiting the rows selected in postgresql