Postgres Pro
Downloads
Home   >   mailing lists

Retreving count of rows returned by a join query - Mailing list pgsql-novice

From Jasbinder Singh Bali
Subject Retreving count of rows returned by a join query
Date
Msg-id a47902760705310132w3c08030am63be8b5db4a24d90@mail.gmail.com
Whole thread Raw
Responses Re: Retreving count of rows returned by a join query  ("Phillip Smith" <phillip.smith@weatherbeeta.com.au>)
Re: Retreving count of rows returned by a join query  (David Gardner <David.Gardner@yucaipaco.com>)
List pgsql-novice
Tree view
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

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: referencing an attribute of a ROWTYPE variable in pgpsql using quote_ident or quote_literal
Next
From: "Phillip Smith"
Date:
Subject: Re: Retreving count of rows returned by a join query