Re: Extended unit - Mailing list pgsql-general

From Roman Neuhauser
Subject Re: Extended unit
Date
Msg-id 20050125131523.GA1269@isis.wad.cz
Whole thread Raw
In response to Extended unit  (Pailloncy Jean-Gerard <jg@rilk.com>)
Responses Re: Extended unit  (Pailloncy Jean-Gerard <jg@rilk.com>)
List pgsql-general
# jg@rilk.com / 2005-01-25 10:40:15 +0100:
> I add use in my time in University some software that use "extended
> type".
> For each variable, we define the mandatory "classic type" as integer,
> float, double array of.
> And we define an optional "extended type" as the unit in the MKSA
> system (Meter, Kilogram, Second, Ampere) or any other unit we would
> have previously define (eg. Currency).
>
> This "extended type" was wonderful, because there was warning/error if
> "extend type" does not match in any computation: you can not add apple
> to orange.
>
> I would appreciate to have such system in PostgreSQL.

    Is CREATE TYPE what you're looking for?
    http://www.postgresql.org/docs/8.0/static/sql-createtype.html

--
If you cc me or remove the list(s) completely I'll most likely ignore
your message.    see http://www.eyrie.org./~eagle/faqs/questions.html

pgsql-general by date:

Previous
From: John DeSoi
Date:
Subject: Re: EMBEDDED PostgreSQL
Next
From: Jean-Yves Barbier
Date:
Subject: software development solution