limiting the rows selected in postgresql

From: RADHAKRISHNAN C V <cvr(at)md2(dot)vsnl(dot)net(dot)in>
To: pgsql-interfaces(at)postgreSQL(dot)org
Subject: limiting the rows selected in postgresql
Date: 1998-11-09 12:52:58
Message-ID: Pine.OSF.3.95.981109182032.10351B-100000@md2.vsnl.net.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-interfaces


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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Sferacarta Software 1998-11-09 13:33:06 Re: [INTERFACES] limiting the rows selected in postgresql
Previous Message Goran Thyni 1998-11-09 08:40:54 Overruns (was: 'pgsql/src/backend/lib stringinfo.c')

Browse pgsql-interfaces by date

  From Date Subject
Next Message Sferacarta Software 1998-11-09 13:33:06 Re: [INTERFACES] limiting the rows selected in postgresql
Previous Message Jim Bowlin 1998-11-09 10:07:00 libpq.o problem in Pg.pm 1.8 make test on Linux