Re: WIP patch: Collation support

Поиск
Список
Период
Сортировка
От Martijn van Oosterhout
Тема Re: WIP patch: Collation support
Дата
Msg-id 20080902155727.GF3664@svana.org
обсуждение исходный текст
Ответ на Re: WIP patch: Collation support  (Peter Eisentraut <peter_e@gmx.net>)
Ответы Re: WIP patch: Collation support
Список pgsql-hackers
On Tue, Sep 02, 2008 at 04:46:16PM +0300, Peter Eisentraut wrote:
> >While it's true POSIX locales don't handle this, other collation
> >libraries do and we should support them if the user wants.
>
> Do they handle exactly those two attributes specifically?  Can you point
> out references?  Or do you mean, other collation libraries allow their
> collations to be configured/customized?  I think linguistically it is a
> very narrow view of the world to hardcode those two attributes.

Well, yes. Accents and case are attributes of a character. (I'm using
the unicode model here). So, to do a case insensetive match you take
the characters, strip the attributes and then do the comparison. There
are specialised routines which handle the denormalisation of the string
for you so in theory you could even get specific about which accents
you ignore. In practice I don't think people do that.

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Please line up in a tree and maintain the heap invariant while
> boarding. Thank you for flying nlogn airlines.

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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: What is d2mdir?
Следующее
От: "David E. Wheeler"
Дата:
Сообщение: Re: Mysterious Bus Error with get_fn_expr_argtype()