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  |  
[EMAIL PROTECTED]        |  -- Joe Walsh for the 21st Century


Reply via email to