> -Original Message-
> From: pgsql-general-ow...@postgresql.org
> [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of josh.v...@csiro.au
> Sent: Thursday, 13 May 2010 10:41 AM
> To: pgsql-general@postgresql.org
> Subject: [ExternalEmail] [GENERAL] Unpivot / uncrosstab support?
>
> Hi
Hi,
I was wondering if Postgresql (8.3 or later) had an equivalent function to the
MS-SQL function "unpivot"? I've spotted the user contributed crosstab which is
similar to the "pivot" function, but I can't find an equivalent "uncrosstab".
Essentially what I'm trying to do is take a table like