Re: a simple transform

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().