Jeff Davis <[EMAIL PROTECTED]> writes: > On Sat, 2008-11-01 at 16:38 -0400, Tom Lane wrote: >> Peter Eisentraut <[EMAIL PROTECTED]> 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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers