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@xxxxxxxxx> 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.
Attachment:
signature.asc
Description: Digital signature
