Re: help yourself by helping others - Mailing list pgsql-sql

On Fri, 2003-04-04 at 11:10, Ali Adams wrote:
> Dear All,
>
> I am new to Relational Databases and SQL and my background in ODBs is
> clouding my way to solving what seems to be a simple problem. I am
> sure many of you have met it many times.

You need to use a pivot table.

Specifically, see crosstab() within contrib/tablefunc in the source
base.