RE: [GENERAL] Row Count?

Try:
SELECT * FROM foo WHERE LIMIT 10;

You must have PostgreSQL 6.5 for this to work. It is a new feature.

-----Original Message-----
From: Bruce Tong [SMTP:zztong(at)laxmi(dot)ev(dot)net]
Sent: Wednesday, May 05, 1999 8:09 AM
To: PostgreSQL General
Subject: [GENERAL] Row Count?

This is probably one of those things everyone knows except me, but
my
search of the documentation only turned up it's not a keyword in
PostgreSQL...

SELECT * FROM foo WHERE ROW_COUNT < 10;

Is there anything like "ROW_COUNT" or "ROWCOUNT" in PostgreSQL?

I've been looking through "The Practical SQL Handbook" as I know it
is a
significant influence on PostgreSQL, and I haven't found anything
similar
there either.

Bruce Tong | Got me an office; I'm there late at
night.
Systems Programmer | Just send me e-mail, maybe I'll write.
Electronic Vision / FITNE |
zztong(at)laxmi(dot)ev(dot)net | -- Joe Walsh for the 21st Century