Re: [PERFORM] Flattening a kind of 'dynamic' table

2005-02-04 Thread Merlin Moncure
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

Re: [PERFORM] Flattening a kind of 'dynamic' table

2005-02-04 Thread Alexandre Leclerc
On Fri, 4 Feb 2005 12:48:43 -0500, Merlin Moncure [EMAIL PROTECTED] wrote: 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',