Re: Distinct types

>>> Tom Lane <tgl@sss.pgh.pa.us> wrote: 
> If it's going to take a significant amount of work then I think
someone
> ought to provide an actual justification why it's worth the work.
This by itself doesn't justify the effort, but I've worked with
databases which would refuse to allow comparison (including within
JOIN conditions) of values if they were in different domains, and I
miss that.  It would occasionally keep people from making dumb
mistakes that wasted time.  It would also be nice to be able to
prevent inappropriate use of data, as previously mentioned.  I'm
afraid I don't have any interest less mundane than that, and ease of
use would need to be there in order for it to be useful.
I would actually like to see comparisons to literals or expressions of
the base type work, although that doesn't seem to be in line with the
SQL spec, and I suspect it might not play nice with the implicit
casting.
-Kevin