9.3 view / cross join / flat table solution

Поиск
Список
Период
Сортировка
От Wells Oliver
Тема 9.3 view / cross join / flat table solution
Дата
Msg-id CAOC+FBX8soovOV+Lsv=bc0Ku1qJpvC-mWW=bzKADb5Lz0Ei1bA@mail.gmail.com
обсуждение исходный текст
Ответы Re: 9.3 view / cross join / flat table solution  (<marin@kset.org>)
Список pgsql-general
Дерево обсуждения
Hi everyone. I have a view setup like so:

create view myview as
select
    department,
    employee_id,
    report_status,
    sum(reports) reports
from logger.reports
group by department, employee_id, report_status;

Which gives me the total number of reports by status, which is either 'published' or 'finalized'.

What I don't get is an 'all' rollup. Which I could do with another flat table and a cross join on a table of report statuses, but I'd love to keep this is as a view if possible.

Using 9.3, so I have the "latest and greatest". What are my options here?

--
Wells Oliver
wellsoliver@gmail.com

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Row number estimation...
Следующее
От:
Дата:
Сообщение: Re: Row number estimation...