| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | Josh Berkus <josh(at)agliodbs(dot)com>, Kurt Overberg <kurt(at)hotdogrecords(dot)com>, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Selecting rows as if they were columns? |
| Date: | 2003-10-09 17:57:37 |
| Message-ID: | 200310091857.37460.dev@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruno Wolff III | 2003-10-09 19:05:36 | Re: [SQL] SQL query problem |
| Previous Message | Slava Gorski | 2003-10-09 17:29:03 | get diagnostics not supported by ecpg? |