Skip site navigation (1)
Skip section navigation (2)
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
Peripheral Links
Header And Logo
|
Site Navigation
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: Thu, 31 May 2007 04:32:27 -0400
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
- Follow-Ups:
- Re: Retreving count of rows returned by a join query
- From: Phillip Smith
- Re: Retreving count of rows returned by a join query
- Prev by Date: Re: referencing an attribute of a ROWTYPE variable in pgpsql using quote_ident or quote_literal
- Next by Date: Re: Retreving count of rows returned by a join query
- Previous by thread: referencing an attribute of a ROWTYPE variable in pgpsql using quote_ident or quote_literal
- Next by thread: Re: Retreving count of rows returned by a join query
- Indexes: