Turning column into row - Mailing list pgsql-sql

From
Subject Turning column into row
Date
Msg-id Pine.LNX.4.33.0205212232120.4247-100000@energija.fam-tille.de
Whole thread Raw
List pgsql-sql
Hello,

I'm afraid this is a blody beginners question but I have no idea how
to perform a search sanely in the list archive.

I have a Table of certain items
  create table item (      IdItem      int,      Item        varchar(64),      ...  );

a lookuptable which defines some properties
  create table property (      IdProperty  int,      Property    varchar(64)  );

and a table which defines the different properties which are possible for
a certain item:
  create table tlkp_item_property (      IdItem     int,      IdProperty int  );

So I can easily select all the properties of a certain item in a table
where the columns contain the properties.  But I want to have an output
of the kind
   Item 1: Property 1, Property 2, Property 3, ...   Item 2: <Properties of Item 2>      ...

So I have to turn the different properties according to one item into
one field insead of one column.

How to do this sanely?

Kind regards
         Andreas.





pgsql-sql by date:

Previous
From: Thomas Lockhart
Date:
Subject: Re: Bug with Daylight Savings Time & Interval
Next
From: "Tille, Andreas"
Date:
Subject: Re: Turning column into row