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