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 по дате отправления