Re: Turning column into row

On Wed, 22 May 2002, Tille, Andreas wrote:

> 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.
>
>
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>

Depending on how many properties you had you could include these in the
first table and remove the other two table. Using a hash value pair or
sommit similar (Value=Desc, Value=Desc) you could then do bitwise
operations on the column to extract the information you need.

Just a thought.

-- 
Regards,


Wm. G. Urquhart
Custom Software Solutions
http://www.wurquhart.co.uk