Re: Turning column into row - Mailing list pgsql-sql

On Wed, 22 May 2002, Gabriel Dovalo Carril wrote:

> Select item.item,
>   max(case when property.idproperty = 0 then property.property else
> ''::text end) as p0,
>   max(case when property.idproperty = 1 then property.property else
> ''::text end) as p1
> >From item, property, tlkp_item_property
> Where item.iditem = tlkp_item_property.iditem and
>     tlkp_item_property.idproperty = property.idproperty
> Group by item.item;

Thanks a lot.  This helped much.  Any hints if there are online
documents available which do explain those problems?

Kind regards
          Andreas.