Re: Turning column into row (More...) - Mailing list pgsql-sql

From Wm. G. Urquhart
Subject Re: Turning column into row (More...)
Date
Msg-id Pine.LNX.4.44.0205221504160.5109-100000@mailer.wurquhart.co.uk
Whole thread Raw
In response to Re: Turning column into row  ("Tille, Andreas" <TilleA@rki.de>)
List pgsql-sql
On Wed, 22 May 2002, Tille, Andreas wrote:

> On Wed, 22 May 2002, Wm. G. Urquhart wrote:
> > 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.
> Well, there are not much but how to insert a new Property with this
> approach.  Quite impossible.
>
> Anyway, thanks for the thought
>
>          Andreas.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>

In fact on further investigation :

select ?, ?, ? from ? where (column & value = value) ;

Returns the rows with the appropriate bits set. So this idea will work in
PostgreSQL.

HTH.

-- 
Regards,


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




pgsql-sql by date:

Previous
From: "Wm. G. Urquhart"
Date:
Subject: Re: Turning column into row
Next
From: Tom Lane
Date:
Subject: Re: Compatibility Issue of CREATE RULE in 7.2