how to get the total number of records in report

Поиск
Список
Период
Сортировка
От AI Rumman
Тема how to get the total number of records in report
Дата
Msg-id AANLkTimLXyfHRzo+PdrXmcMf_JKJL+L_EegusSeh1T-v@mail.gmail.com
обсуждение исходный текст
Ответы Re: how to get the total number of records in report
Re: how to get the total number of records in report
Список pgsql-performance
Дерево обсуждения
At present for reporting I use following types of query: 
select crm.*, crm_cnt.cnt
from crm,
(select count(*) as cnt from crm) crm_cnt;
Here count query is used to find the total number of records. 
Same FROM clause is copied in both the part of the query.
Is there any other good alternative way to get this similar value?


В списке pgsql-performance по дате отправления:

Предыдущее
От: Merlin Moncure
Дата:
Сообщение: Re: Stored procedure declared as VOLATILE => no good optimization is done
Следующее
От: Nikolai Zhubr
Дата:
Сообщение: Re: Index scan / Index cond limitation or ?