Re: Normalized storage to denormalized report

On Thu, Jan 19, 2006 at 07:03:47AM -0500, Sean Davis wrote:
> I have a table that stores data like so:

<snip>

> And I would like to design a query that gives:
>
> Clone_idx expt_id_1 expt_id_2 ....
> 1 0.7834 0.8231 ....
> 2 0.2832 1.2783 ....
>
> There are several tens-of-thousands of clone_idx entries, so doing this
> quickly may not even be possible. Any suggestions on how to go from this
> normalized structure to the denormalized form easily. Note that this isn't
> exactly a crosstab, since there is no counting data, just reshaping.

Although you may not call it exactly a crosstab, the crosstab
functions in contrib/tablefunc should solve your problem nicely.

Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.