Re: Proposal: CREATE CONVERSION

Поиск
Список
Период
Сортировка
От Tatsuo Ishii
Тема Re: Proposal: CREATE CONVERSION
Дата
Msg-id 20020709.140110.27798256.t-ishii@sra.co.jp
обсуждение исходный текст
Ответ на Re: Proposal: CREATE CONVERSION  (Thomas Lockhart <lockhart@fourpalms.org>)
Список pgsql-hackers
> > I've been think this for a while too. What about collation? If we add
> > new chaset A and B, and each has 10 collations then we are going to
> > have 20 new types? That seems overkill to me.
> 
> Well, afaict all of the operations we would ask of a type we will be
> required to provide for character sets and collations. So ordering,
> conversions, operators, index methods, etc etc are all required. It
> *does* seem like a lot of work, but the type system is specifically
> designed to do exactly this. Lifting those capabilities out of the type
> system only to reimplement them elsewhere seems all trouble with no
> upside.

If so, what about the "coercibility" property?
The standard defines four distinct coercibility properties. So in
above my example, actually you are going to define 80 new types?
(also a collation could be either "PAD SPACE" or "NO PAD". So you
might have 160 new types).
--
Tatsuo Ishii




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

Предыдущее
От: Tatsuo Ishii
Дата:
Сообщение: Re: Proposal: CREATE CONVERSION
Следующее
От: Hannu Krosing
Дата:
Сообщение: Re: Issues Outstanding for Point In Time Recovery (PITR)