Re: Flattening a kind of 'dynamic' table

> Alexandre Leclerc wrote:
> Sorry for jumping in on this thread so late -- I haven't been able to
> select * from crosstab(
> 'select product_id, department_id, req_time
> from product_department_time order by 1',
> 'select ''A'' union all select ''C'' union all select ''D'''
> ) as (product_id int, a int, c int, d int);

I forgot you could do this...This would certainly be easier than parsing
array values returned from array_accum. It will probably be faster as
well...but with the array approach the query would not have to be
modified each time a new department was added. That said, a crosstab
based query could be built easily enough from a department query on the
client and then you have the best of both worlds.

Merlin