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