variant column type

From: salah jubeh <s_jubeh(at)yahoo(dot)com>
To: pgsql <pgsql-general(at)postgresql(dot)org>
Subject: variant column type
Date: 2011-07-26 17:02:13
Message-ID: 1311699733.59137.YahooMailRC@web161504.mail.bf1.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hello,

suppose the following scenario

the car speed is 240
the car has an airbag

Here the first value is integer and the second value is boolean. Consider that I
have this table structure

feature (feature id feature name)
car (car id, .... )
car_feature (car id, feature id, value). the value attribute might have
different domains. How can I model this using postgres and using ANSI compliant
design ?

Regards

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2011-07-26 17:10:47 Re: variant column type
Previous Message Merlin Moncure 2011-07-26 16:23:29 Re: Implementing "thick"/"fat" databases