Re: Distinct types

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Distinct types
Дата
Msg-id 21661.1226082990@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Distinct types  (Jeff Davis <pgsql@j-davis.com>)
Список pgsql-hackers
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


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Guillaume Lelarge
Дата:
Сообщение: Re: Patch for ALTER DATABASE WITH TABLESPACE
Следующее
От: Kenneth Marshall
Дата:
Сообщение: Re: [RRR] Tests citext casts