Row Count? - Mailing list pgsql-general

From Bruce Tong
Subject Row Count?
Date
Msg-id Pine.LNX.4.04.9905050956440.20229-100000@laxmi.ev.net
Whole thread Raw
In response to Re: [GENERAL] index on an int8 column  (José Soares <jose@sferacarta.com>)
Responses Re: [GENERAL] Row Count?  (Dustin Sallings <dustin@spy.net>)
List pgsql-general
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



pgsql-general by date:

Previous
From: José Soares
Date:
Subject: Re: [GENERAL] index on an int8 column
Next
From: Michael Davis
Date:
Subject: Re: [GENERAL] advice on buying sun hardware to run postgres