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