ridiculously large crosstabs

Поиск
Список
Период
Сортировка
Искать
От
Joseph Doench
Тема
ridiculously large crosstabs
Дата
Msg-id
001501cbf45e$4fa90050$eefb00f0$@rr.com
Список
I need to generate a very large crosstab. about 50 rows x 50 columns  -- for
a request for a recurring report.

Example: Column Headings = Job_ID    and   Row Headings = Employee_ID   and
Values in the table = Hours_worked

Got the idea?

I've looked at :
http://www.postgresonline.com/journal/archives/14-CrossTab-Queries-in-Postgr
eSQL-using-tablefunc-contrib.html

...and the comments there.

Of course, the Job_IDs change every month... I need some more clues on how
to proceed with this - how to 'get' and output the column headings?

(Using pgsql 8.2)

Thanks,

JPD


В списке pgsql-general по дате отправления
От: Thom Brown
Дата:
Сообщение: Re: forums.postgresql.com.au
От: tejas tank
Дата:
Сообщение: Critical Bug
FAQ