DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:from:to:references:in-reply-to:subject:date:mime-version
	:content-type:content-transfer-encoding:x-priority:x-msmail-priority
	:x-mailer:x-mimeole;
	b=oe9oxpqQePptyDJPLy/9bfsYJxSEb37kVO1ETlj6BxANq1xZDiTku1l+olcOacF/YB
	zaHWj08t8MP31K9Q7qGbuUZjCOYXviJuzCyAhCD6DvybQZuPMHGCGfJwltvhEIDIjm5l
	jrFo3jEApAaha8mlJTNKbcfWSmT4eUE0CxbbA=
Message-ID: <72DF18D5AC5748E3A23E6A9B0FE24358@PCGianvito>
From: "Gianvito Pio" <pio.gianvito@gmail.com>
To: <pgsql-sql@postgresql.org>
References: <5eca56860906050330w6171b327k95881b13c4dca466@mail.gmail.com>
	<4A294A00.5020802@gmail.com>
	<5eca56860906060010y4177b88apcf587d62f7286b5d@mail.gmail.com>
	<h0dm0o$h6b$1@reversiblemaps.ath.cx>
In-Reply-To: <h0dm0o$h6b$1@reversiblemaps.ath.cx>
Subject: Re: Type inheritance
Date: Sat, 6 Jun 2009 16:18:57 +0200
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1";
	reply-type=original
Content-Transfer-Encoding: 7bit

Mhm...maybe. I need that thing for just 1 table... Have you seen the Oracle 
example? Do you know if I can do a similar thing in PostgreSQL?

----- Original Message ----- 
From: "Jasen Betts" <jasen@xnet.co.nz>
Newsgroups: gmane.comp.db.postgresql.sql
To: <pgsql-sql@postgresql.org>
Sent: Saturday, June 06, 2009 2:04 PM
Subject: Re: [SQL] Type inheritance


>
> On 2009-06-06, Gianvito Pio <pio.gianvito@gmail.com> wrote:
>> --001485f44bfe3e357c046ba8b3d6
>> Content-Type: text/plain; charset=ISO-8859-1
>> Content-Transfer-Encoding: 7bit
>>
>> Oh that was just an example...Let me make a real example:
>> I have a table "Sensors" (that has to contain different sensor types) 
>> with
>> a Value. That value doesn't have to be fixed, but I want to define it in 
>> a
>> way that it changes its structure when the sensor type changes. For
>> example, for Temperature sensor I would like to have just a float number,
>> but for the humidity I could need of absolute and relative humidity
>> (2 floats). I'd just like to know if I can say that the VALUE is a 
>> composite
>> type...that I have then to specialize in Temp Type and Humidity 
>> type...using
>> them in their particular case.
>
> this appears to be EAV in disguise.
>
> -- 
> Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql