Re: Retreving count of rows returned by a join query
| От | David Gardner |
|---|---|
| Тема | Re: Retreving count of rows returned by a join query |
| Дата | |
| Msg-id | C975BFE03CC5DE4999143A5BEA9FB515021DC0C4EF@yucex.lax.yucwin обсуждение исходный текст |
| Ответ на | Retreving count of rows returned by a join query ("Jasbinder Singh Bali" <jsbali@gmail.com>) |
| Список | 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@postgresql.org [mailto:pgsql-novice-owner@postgresql.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
В списке pgsql-novice по дате отправления: