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
обсуждение исходный текст
Ответы 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>)
Список pgsql-novice
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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: referencing an attribute of a ROWTYPE variable in pgpsql using quote_ident or quote_literal
Следующее
От: "Phillip Smith"
Дата:
Сообщение: Re: Retreving count of rows returned by a join query