Re: Distinct types

Jeff Davis <pgsql@j-davis.com> writes:
> On Sat, 2008-11-01 at 16:38 -0400, Tom Lane wrote:
>> Peter Eisentraut <peter_e@gmx.net> writes:
>>> There is an implicit AS ASSIGNMENT cast between the base type and the distinct 
>>> type in each direction.
>> 
>> Hmm ... so out-of-the-box, a distinct type would have no applicable
>> functions/operators whatsoever.  You couldn't even create an index on
>> it.  This seems a bit too impoverished to be useful.  And given the

> I didn't have any problem creating and using an index on a distinct type
> at all.

[ scratches head... ]  That should have failed, if the cast is really AS
ASSIGNMENT and not implicit.  If it is implicit, how distinct is the type?
        regards, tom lane