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: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of Frederick Klauschen > Sent: Wednesday, September 26, 2001 11:15 AM > To: [EMAIL PROTECTED] > 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 [EMAIL PROTECTED]) > ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html