Re: Pre-proposal: unicode normalized text

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: Pre-proposal: unicode normalized text
Дата
Msg-id CA+TgmoaJoECzK-rzMBmMktBfEVMAfLmtG8PdmHfq2UYRoHvsmg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Pre-proposal: unicode normalized text  (Peter Eisentraut <peter@eisentraut.org>)
Ответы Re: Pre-proposal: unicode normalized text  (Jeff Davis <pgsql@j-davis.com>)
Re: Pre-proposal: unicode normalized text  (Peter Eisentraut <peter@eisentraut.org>)
Список pgsql-hackers
On Tue, Oct 10, 2023 at 2:44 AM Peter Eisentraut <peter@eisentraut.org> wrote:
> Can you restate what this is supposed to be for?  This thread appears to
> have morphed from "let's normalize everything" to "let's check for
> unassigned code points", but I'm not sure what we are aiming for now.

Jeff can say what he wants it for, but one obvious application would
be to have the ability to add a CHECK constraint that forbids
inserting unassigned code points into your database, which would be
useful if you're worried about forward-compatibility with collation
definitions that might be extended to cover those code points in the
future. Another application would be to find data already in your
database that has this potential problem.

--
Robert Haas
EDB: http://www.enterprisedb.com



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

Предыдущее
От: torikoshia
Дата:
Сообщение: Re: RFC: Logging plan of the running query
Следующее
От: Robert Haas
Дата:
Сообщение: Re: CHECK Constraint Deferrable