is it possible to get the number of rows of a table?

From: Frederick Klauschen <fklauschen(at)yahoo(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: is it possible to get the number of rows of a table?
Date: 2001-09-26 15:14:32
Message-ID: 20010926151432.46962.qmail@web10105.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

I would like to compare the number of rows
of one table and of another and use it in
a query like this:
SELECT * FROM xxxx
WHERE "number of rows of table xxxx"
EQUALS
"number of rows of table yyyy"
i.e. I only want get a query result if the tables
have the same number of rows.
Is there a function or a way to do this ?

Thanks,
Frederick

__________________________________________________
Do You Yahoo!?
Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger. http://im.yahoo.com

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Wei Weng 2001-09-26 16:56:07 Re: is it possible to get the number of rows of a table?
Previous Message A. Mannisto 2001-09-26 14:24:41 Subquery with IN or EXISTS