From: | David Gardner <David(dot)Gardner(at)yucaipaco(dot)com> |
---|---|
To: | 'Jasbinder Singh Bali' <jsbali(at)gmail(dot)com>, Novice Postgresql-list <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Retreving count of rows returned by a join query |
Date: | 2007-06-04 16:32:33 |
Message-ID: | C975BFE03CC5DE4999143A5BEA9FB515021DC0C4EF@yucex.lax.yucwin |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
I know this is an old post that I am responding to, but if you are making these calls from inside of a client application or programming language, often the application or the data structures of the programming language have a count, such as VB's recordset object has a count() method.
---
David Gardner, IT
The Yucaipa Companies
(310) 228-2855
________________________________
From: pgsql-novice-owner(at)postgresql(dot)org [mailto:pgsql-novice-owner(at)postgresql(dot)org] On Behalf Of Jasbinder Singh Bali
Sent: Thursday, May 31, 2007 1:32 AM
To: Novice Postgresql-list
Subject: [NOVICE] Retreving count of rows returned by a join query
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
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Glaesemann | 2007-06-04 16:43:26 | Re: current_date / datetime stuff |
Previous Message | Netzach | 2007-06-04 16:23:00 | Re: current_date / datetime stuff |