Retreving count of rows returned by a join query

From: "Jasbinder Singh Bali" <jsbali(at)gmail(dot)com>
To: "Novice Postgresql-list" <pgsql-novice(at)postgresql(dot)org>
Subject: Retreving count of rows returned by a join query
Date: 2007-05-31 08:32:27
Message-ID: a47902760705310132w3c08030am63be8b5db4a24d90@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

I have a query in which I have joins.

something like

select a.1, b.2 from a, b
where a.3 = b.3;

how can I fetch the number of rows returned by this query.
normal count(*) doesn't work in this context as desired.

Thanks,
~Jas

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Phillip Smith 2007-05-31 09:05:30 Re: Retreving count of rows returned by a join query
Previous Message Tom Lane 2007-05-30 21:51:23 Re: referencing an attribute of a ROWTYPE variable in pgpsql using quote_ident or quote_literal