Received: from nsx-a.snet.net ([204.60.203.54]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f8QGnUh23872 for ; Wed, 26 Sep 2001 12:49:30 -0400 (EDT) (envelope-from wweng@kencast.com) Received: from pop.snet.net (pop.snet.net [204.60.6.9]) by nsx-a.snet.net (8.11.1/8.11.1/SNET-mx-1.4/D-1.10/O-1.7) with ESMTP id f8QGnge01439 for ; Wed, 26 Sep 2001 12:49:42 -0400 (EDT) Received: from monet (167.95.252.64.snet.net [64.252.95.167] (may be forged)) by pop.snet.net (8.11.1/8.11.1/SNET-pop-1.5/D-1.8/O-1.6) with SMTP id f8QGnML29418 for ; Wed, 26 Sep 2001 12:49:22 -0400 (EDT) Reply-To: From: "Wei Weng" To: Subject: Re: is it possible to get the number of rows of a table? Date: Wed, 26 Sep 2001 12:56:07 -0400 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0) Importance: Normal In-Reply-To: <20010926151432.46962.qmail@web10105.mail.yahoo.com> X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300 X-Archive-Number: 200109/226 X-Sequence-Number: 4908 This should be really easy to implement in a function yourself. And I don't think there is already something similar in pgsql. ========== Wei Weng Network Software Engineer KenCast Inc. > -----Original Message----- > From: pgsql-sql-owner@postgresql.org > [mailto:pgsql-sql-owner@postgresql.org]On Behalf Of Frederick Klauschen > Sent: Wednesday, September 26, 2001 11:15 AM > To: pgsql-sql@postgresql.org > Subject: [SQL] is it possible to get the number of rows of a table? > > > 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 > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) >