| 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: | Whole Thread | Raw Message | 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 |