Re: Distinct types - Mailing list pgsql-hackers

From Kevin Grittner
Subject Re: Distinct types
Date
Msg-id 493021FF.EE98.0025.0@wicourts.gov
Whole thread Raw
In response to Re: Distinct types  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Distinct types  ("Greg Stark" <stark@enterprisedb.com>)
List pgsql-hackers
>>> 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


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: HEAD build failure on win32 mingw
Next
From: "Greg Stark"
Date:
Subject: Re: Distinct types