get certain # of recs

Mike S. Nowostawsky <mikenowo@sympatico.ca>

From: "Mike S. Nowostawsky" <mikenowo@sympatico.ca>
To: pgsql-general@postgresql.org
Date: 2001-09-14T03:44:29Z
Lists: pgsql-general
How can one select only a certain number of records in Postgres?

In other SQL langs we can use, say, for the first 20 recs:

select  * from tablename where rownum < 21;

WHAT should 'rownum' be to make this select work... OR is there a diff
syntax?

Thx,
--
=============================================
 Mike S. Nowostawsky:
 Email: mikenowo@sympatico.ca, mikenowo@yahoo.ca
 Home Page: http://www3.sympatico.ca/mikenowo/
 Lachine (Montreal), Quebec, Canada