Retreving count of rows returned by a join query
От
Jasbinder Singh Bali
Тема
Retreving count of rows returned by a join query
Дата
Msg-id
a47902760705310132w3c08030am63be8b5db4a24d90@mail.gmail.com
Список
Дерево обсуждения
Retreving count of rows returned by a join query "Jasbinder Singh Bali" <jsbali@gmail.com>
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 "Jasbinder Singh Bali" <jsbali@gmail.com>
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 Sean Davis <sdavis2@mail.nih.gov>
Re: Retreving count of rows returned by a join query David Gardner <David.Gardner@yucaipaco.com>
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
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 по дате отправления
От: Tom Lane
Дата: