Re: Type inheritance - Mailing list pgsql-sql

From Rob Sargent
Subject Re: Type inheritance
Date
Msg-id 4A294A00.5020802@gmail.com
Whole thread Raw
In response to Type inheritance  (Gianvito Pio <pio.gianvito@gmail.com>)
Responses Re: Type inheritance  (Gianvito Pio <pio.gianvito@gmail.com>)
List pgsql-sql
I'm not sure how Temperature and Humidity are related as types beyond 
"extends float". i.e. What tuple definition could alternatively have a 
Temp or a Humidity value?  (I do understand their physical relationship :) )



Gianvito Pio wrote:
> Hi all,
> I just want to ask you if it's possible to define sub types in 
> PostgreSQL (Type inheritance). I found that table inheritance is 
> possible...but I'd like to do it on types.
>
> Example:
> define a type Value and two subtypes Temperature and Humidity and then 
> define a table that has an attribute of Value type (that can accept 
> both specialized types).
>
> Thanks 



pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: do unneeded outer joins cost?
Next
From: Gianvito Pio
Date:
Subject: Re: Type inheritance