| From: | Roman Neuhauser <neuhauser(at)chello(dot)cz> |
|---|---|
| To: | Pailloncy Jean-Gerard <jg(at)rilk(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Extended unit |
| Date: | 2005-01-25 13:15:23 |
| Message-ID: | 20050125131523.GA1269@isis.wad.cz |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
# jg(at)rilk(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2005-01-25 13:20:45 | Re: EMBEDDED PostgreSQL |
| Previous Message | John DeSoi | 2005-01-25 12:40:05 | Re: Backup DLL |