From: Richard Huxton <dev@archonet.com>
To: Josh Berkus <josh@agliodbs.com>,
	Kurt Overberg <kurt@hotdogrecords.com>, pgsql-sql@postgresql.org
Subject: Re: Selecting rows as if they were columns?
Date: Thu, 9 Oct 2003 18:57:37 +0100
User-Agent: KMail/1.5
References: <3F855F38.9070803@hotdogrecords.com>
	<200310091014.09695.josh@agliodbs.com>
In-Reply-To: <200310091014.09695.josh@agliodbs.com>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200310091857.37460.dev@archonet.com>

On Thursday 09 October 2003 18:14, Josh Berkus wrote:
> Kurt,
>
> > I've got what I think should be a pretty simple problem- I just can't
> > figure out how I'd do it.  Heck, I can't even figure out how I'd search
> > for an answer to this problem.
>
> This is an old common SQL problem ... the "crosstab" table.   There are 3
> standard ways to solve it, depending on the exact circumstances of your
> case. It's probably best if you buy Joe Celko's "SQL for Smarties, 2nd
> Ed.", which has a 50-page chapter on the topic and explores the methods in
> detail.

Or see the contrib/tablefunc functions which can do this sort of thing for 
you.

-- 
  Richard Huxton
  Archonet Ltd