Re: [GENERAL] Unpivot / uncrosstab support?

2010-05-13 Thread Josh.Vote
> -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

[GENERAL] Unpivot / uncrosstab support?

2010-05-12 Thread Josh.Vote
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