Received: from web10105.mail.yahoo.com (web10105.mail.yahoo.com [216.136.130.55]) by postgresql.org (8.11.3/8.11.4) with SMTP id f8QFEah02763 for ; Wed, 26 Sep 2001 11:14:36 -0400 (EDT) (envelope-from fklauschen@yahoo.com) Message-ID: <20010926151432.46962.qmail@web10105.mail.yahoo.com> Received: from [128.231.231.124] by web10105.mail.yahoo.com via HTTP; Wed, 26 Sep 2001 08:14:32 PDT Date: Wed, 26 Sep 2001 08:14:32 -0700 (PDT) From: Frederick Klauschen Subject: is it possible to get the number of rows of a table? To: pgsql-sql@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Archive-Number: 200109/225 X-Sequence-Number: 4907 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