Row Count?

From: Bruce Tong <zztong(at)laxmi(dot)ev(dot)net>
To: PostgreSQL General <pgsql-general(at)postgreSQL(dot)org>
Subject: Row Count?
Date: 1999-05-05 14:08:44
Message-ID: Pine.LNX.4.04.9905050956440.20229-100000@laxmi.ev.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)laxmi(dot)ev(dot)net | -- Joe Walsh for the 21st Century

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Davis 1999-05-05 14:15:41 Re: [GENERAL] advice on buying sun hardware to run postgres
Previous Message José Soares 1999-05-05 13:03:56 Re: [GENERAL] index on an int8 column