Karl Grossner wrote:
> I've thrashed at this transform for quite a while and come up empty. The
> crosstab() functions, and the documented examples, all do something more
> complex than I need. I can do this after the fact trivially in python with
> the 'zip()' function, but I need it real-time from a view or function.
>
> Of course I could be overlooking the obvious (it's happened before!)
>
> I have this:
> attr1 attr2 attr3
> ------ ------ ------
> cat1 0.34 0.12 0.22
> cat2 0.11 0.67 0.31
>
> and need it transposed thus:
> cat1 cat2
> ----- -----
> attr1 0.34 0.11
> attr2 0.12 0.67
> attr3 0.22 0.31
I see no response; so I thought I'd take a stab at it. I don't have 8.3
yet so I cannot test my idea. I read the docs, and I think what you
need to do is create SQL that will produce
cat attr val
---- ----- ----
cat1 attr1 0.34
cat1 attr2 0.12
cat1 attr3 0.22
cat2 attr1 0.11
cat2 attr2 0.67
cat2 attr3 0.31
That pass the SQL into crosstab().