From: | "Tille, Andreas" <TilleA(at)rki(dot)de> |
---|---|
To: | |
Cc: | PostgreSQL SQL <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: Turning column into row |
Date: | 2002-05-22 13:25:13 |
Message-ID: | Pine.LNX.4.44.0205221514460.8932-100000@wr-linux02.rki.ivbb.bund.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2002-05-22 13:55:35 | Re: Compatibility Issue of CREATE RULE in 7.2 |
Previous Message | Joel Burton | 2002-05-22 13:14:25 | Re: Turning column into row |