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

Поиск
Список
Период
Сортировка
От Frederick Klauschen
Тема is it possible to get the number of rows of a table?
Дата
Msg-id 20010926151432.46962.qmail@web10105.mail.yahoo.com
обсуждение исходный текст
Ответы Re: is it possible to get the number of rows of a table?  ("Wei Weng" <wweng@kencast.com>)
Re: is it possible to get the number of rows of a table?  (Haller Christoph <ch@rodos.fzk.de>)
Список 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


В списке pgsql-sql по дате отправления:

Предыдущее
От: "Thurstan R. McDougle"
Дата:
Сообщение: Re: A simple join question that may stump you
Следующее
От: "Wei Weng"
Дата:
Сообщение: Re: is it possible to get the number of rows of a table?