Thread: ridiculously large crosstabs

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