| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
| Cc: | Alban Hertroys <alban(at)magproductions(dot)nl>, Pailloncy Jean-Gerard <jg(at)rilk(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Extended unit |
| Date: | 2005-01-25 19:31:40 |
| Message-ID: | 6204.1106681500@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Martijn van Oosterhout <kleptog(at)svana(dot)org> writes:
> We're talking here about a database with indexes to speed up
> intersection tests for arbitrary polygons, extensions to handle
> encryption, full text indexing and even builtin XML support.
... none of which require any extensions to the core type system.
AFAICS this could easily be implemented as a user-defined type, along
the lines of
CREATE TYPE measurement AS (value double, units text);
and if you want to constrain a particular column to contain only one
value of units, use CHECK.
The argument that we should extend the type system for this would become
a lot more credible if there were a widely-used extension in existence
for it to prove that there's sufficient demand.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-01-25 19:34:16 | Re: Recursive queries |
| Previous Message | John DeSoi | 2005-01-25 19:30:48 | Re: EMBEDDED PostgreSQL |