Re: [GENERAL] Row Count?

Try
   "select count(*) from row"

to get a count of the number of rows.

If trying to receive 10 rows, try

begin;
declare thomas cursor for select * from foo;
fetch 10 in thomas;
end;

Bruce Tong wrote:
>
> 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

--
------------------------------------------------------------
Thomas Reinke                            Tel: (416) 460-7021
Director of Technology                   Fax: (416) 598-2319
E-Soft Inc.                         http://www.e-softinc.com