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@laxmi.ev.net | -- Joe Walsh for the 21st Century