Re: Built-in CTYPE provider

Поиск
Список
Период
Сортировка
Искать
От
Jeff Davis
Тема
Re: Built-in CTYPE provider
Дата
Msg-id
69f832595838e40c1b071a5e750665190ba301bf.camel@j-davis.com
Ответ на
Re: Built-in CTYPE provider (Peter Eisentraut)
Список
Дерево обсуждения
Built-in CTYPE provider Jeff Davis <pgsql@j-davis.com>
Re: Built-in CTYPE provider Jeremy Schneider <schneider@ardentperf.com>
Re: Built-in CTYPE provider Jeff Davis <pgsql@j-davis.com>
Re: Built-in CTYPE provider Jeremy Schneider <schneider@ardentperf.com>
Re: Built-in CTYPE provider Jeff Davis <pgsql@j-davis.com>
Re: Built-in CTYPE provider Robert Haas <robertmhaas@gmail.com>
Re: Built-in CTYPE provider Jeff Davis <pgsql@j-davis.com>
Re: Built-in CTYPE provider "Daniel Verite" <daniel@manitou-mail.org>
Re: Built-in CTYPE provider Jeff Davis <pgsql@j-davis.com>
Re: Built-in CTYPE provider Jeff Davis <pgsql@j-davis.com>
Re: Built-in CTYPE provider Jeremy Schneider <schneider@ardentperf.com>
Re: Built-in CTYPE provider Jeff Davis <pgsql@j-davis.com>
Re: Built-in CTYPE provider Jeremy Schneider <schneider@ardentperf.com>
Re: Built-in CTYPE provider Jeff Davis <pgsql@j-davis.com>
Re: Built-in CTYPE provider Jeremy Schneider <schneider@ardentperf.com>
Re: Built-in CTYPE provider Jeff Davis <pgsql@j-davis.com>
Re: Built-in CTYPE provider "Daniel Verite" <daniel@manitou-mail.org>
Re: Built-in CTYPE provider Jeff Davis <pgsql@j-davis.com>
Re: Built-in CTYPE provider Jeff Davis <pgsql@j-davis.com>
Re: Built-in CTYPE provider Peter Eisentraut <peter@eisentraut.org>
Re: Built-in CTYPE provider Jeff Davis <pgsql@j-davis.com>
Re: Built-in CTYPE provider Peter Eisentraut <peter@eisentraut.org>
Re: Built-in CTYPE provider Jeff Davis <pgsql@j-davis.com>
Re: Built-in CTYPE provider Jeff Davis <pgsql@j-davis.com>
Re: Built-in CTYPE provider Jeff Davis <pgsql@j-davis.com>
Re: Built-in CTYPE provider Jeff Davis <pgsql@j-davis.com>
Re: Built-in CTYPE provider Peter Eisentraut <peter@eisentraut.org>
Re: Built-in CTYPE provider Jeff Davis <pgsql@j-davis.com>
Re: Built-in CTYPE provider Jeff Davis <pgsql@j-davis.com>
Re: Built-in CTYPE provider Peter Eisentraut <peter@eisentraut.org>
Re: Built-in CTYPE provider Jeff Davis <pgsql@j-davis.com>
Re: Built-in CTYPE provider Peter Eisentraut <peter@eisentraut.org>
Re: Built-in CTYPE provider Jeff Davis <pgsql@j-davis.com>
Re: Built-in CTYPE provider Noah Misch <noah@leadboat.com>
Re: Built-in CTYPE provider Jeff Davis <pgsql@j-davis.com>
Re: Built-in CTYPE provider Noah Misch <noah@leadboat.com>
Re: Built-in CTYPE provider Jeff Davis <pgsql@j-davis.com>
Re: Built-in CTYPE provider Noah Misch <noah@leadboat.com>
Re: Built-in CTYPE provider Peter Eisentraut <peter@eisentraut.org>
Re: Built-in CTYPE provider Noah Misch <noah@leadboat.com>
Re: Built-in CTYPE provider "Daniel Verite" <daniel@manitou-mail.org>
Re: Built-in CTYPE provider Jeff Davis <pgsql@j-davis.com>
Re: Built-in CTYPE provider Jeff Davis <pgsql@j-davis.com>
Re: Built-in CTYPE provider Noah Misch <noah@leadboat.com>
Re: Built-in CTYPE provider Jeff Davis <pgsql@j-davis.com>
Re: Built-in CTYPE provider Noah Misch <noah@leadboat.com>
Re: Built-in CTYPE provider Tom Lane <tgl@sss.pgh.pa.us>
Re: Built-in CTYPE provider Noah Misch <noah@leadboat.com>
Re: Built-in CTYPE provider Tom Lane <tgl@sss.pgh.pa.us>
Re: Built-in CTYPE provider Jeff Davis <pgsql@j-davis.com>
Re: Built-in CTYPE provider Noah Misch <noah@leadboat.com>
Re: Built-in CTYPE provider Jeff Davis <pgsql@j-davis.com>
Re: Built-in CTYPE provider Noah Misch <noah@leadboat.com>
Re: Built-in CTYPE provider "Daniel Verite" <daniel@manitou-mail.org>
Re: Built-in CTYPE provider Noah Misch <noah@leadboat.com>
Re: Built-in CTYPE provider Noah Misch <noah@leadboat.com>
Re: Built-in CTYPE provider Joe Conway <mail@joeconway.com>
Re: Built-in CTYPE provider Peter Eisentraut <peter@eisentraut.org>
Re: Built-in CTYPE provider Jeremy Schneider <schneider@ardentperf.com>
Re: Built-in CTYPE provider Laurenz Albe <laurenz.albe@cybertec.at>
Re: Built-in CTYPE provider Noah Misch <noah@leadboat.com>
Re: Built-in CTYPE provider Laurenz Albe <laurenz.albe@cybertec.at>
Re: Built-in CTYPE provider Jeff Davis <pgsql@j-davis.com>
Re: Built-in CTYPE provider Jeff Davis <pgsql@j-davis.com>
Re: Built-in CTYPE provider Tom Lane <tgl@sss.pgh.pa.us>
Re: Built-in CTYPE provider Noah Misch <noah@leadboat.com>
Re: Built-in CTYPE provider Jeff Davis <pgsql@j-davis.com>
Re: Built-in CTYPE provider Laurenz Albe <laurenz.albe@cybertec.at>
Re: Built-in CTYPE provider Jeff Davis <pgsql@j-davis.com>
Re: Built-in CTYPE provider Jeff Davis <pgsql@j-davis.com>
Re: Built-in CTYPE provider Laurenz Albe <laurenz.albe@cybertec.at>
Re: Built-in CTYPE provider Jeremy Schneider <schneider@ardentperf.com>
Re: Built-in CTYPE provider Jeremy Schneider <schneider@ardentperf.com>
Re: Built-in CTYPE provider Peter Eisentraut <peter@eisentraut.org>
Re: Built-in CTYPE provider Jeff Davis <pgsql@j-davis.com>
Re: Built-in CTYPE provider Peter Eisentraut <peter@eisentraut.org>
Re: Built-in CTYPE provider Jeff Davis <pgsql@j-davis.com>
Re: Built-in CTYPE provider Peter Eisentraut <peter@eisentraut.org>
Re: Built-in CTYPE provider Jeff Davis <pgsql@j-davis.com>
Re: Built-in CTYPE provider "Daniel Verite" <daniel@manitou-mail.org>
Re: Built-in CTYPE provider Jeff Davis <pgsql@j-davis.com>
Re: Built-in CTYPE provider Alexander Lakhin <exclusion@gmail.com>
Re: Built-in CTYPE provider Jeff Davis <pgsql@j-davis.com>
Re: Built-in CTYPE provider Laurenz Albe <laurenz.albe@cybertec.at>
Re: Built-in CTYPE provider Peter Eisentraut <peter@eisentraut.org>
Re: Built-in CTYPE provider Jeff Davis <pgsql@j-davis.com>
Re: Built-in CTYPE provider Peter Eisentraut <peter@eisentraut.org>
Re: Built-in CTYPE provider Thomas Munro <thomas.munro@gmail.com>
Re: Built-in CTYPE provider Jeff Davis <pgsql@j-davis.com>
Re: Built-in CTYPE provider Jeff Davis <pgsql@j-davis.com>
Re: Built-in CTYPE provider Tom Lane <tgl@sss.pgh.pa.us>
Re: Built-in CTYPE provider Jeff Davis <pgsql@j-davis.com>
Re: Built-in CTYPE provider Tom Lane <tgl@sss.pgh.pa.us>
Re: Built-in CTYPE provider Jeff Davis <pgsql@j-davis.com>
Re: Built-in CTYPE provider Tom Lane <tgl@sss.pgh.pa.us>
Re: Built-in CTYPE provider Thomas Munro <thomas.munro@gmail.com>
Re: Built-in CTYPE provider Tom Lane <tgl@sss.pgh.pa.us>
Re: Built-in CTYPE provider Peter Eisentraut <peter@eisentraut.org>
Re: Built-in CTYPE provider Jeff Davis <pgsql@j-davis.com>
Re: Built-in CTYPE provider Jeff Davis <pgsql@j-davis.com>
Re: Built-in CTYPE provider Peter Eisentraut <peter@eisentraut.org>
Re: Built-in CTYPE provider Jeff Davis <pgsql@j-davis.com>
Re: Built-in CTYPE provider Peter Eisentraut <peter@eisentraut.org>
Re: Built-in CTYPE provider Jeff Davis <pgsql@j-davis.com>
Re: Built-in CTYPE provider "Daniel Verite" <daniel@manitou-mail.org>
Re: Built-in CTYPE provider "Daniel Verite" <daniel@manitou-mail.org>
Re: Built-in CTYPE provider Jeff Davis <pgsql@j-davis.com>
Re: Built-in CTYPE provider Jeff Davis <pgsql@j-davis.com>
Re: Built-in CTYPE provider "Daniel Verite" <daniel@manitou-mail.org>
Re: Built-in CTYPE provider Jeff Davis <pgsql@j-davis.com>
Re: Built-in CTYPE provider Robert Haas <robertmhaas@gmail.com>
Re: Built-in CTYPE provider Michael Paquier <michael@paquier.xyz>
Re: Built-in CTYPE provider Jeff Davis <pgsql@j-davis.com>
Re: Built-in CTYPE provider Robert Haas <robertmhaas@gmail.com>
Re: Built-in CTYPE provider Jeff Davis <pgsql@j-davis.com>
Re: Built-in CTYPE provider Robert Haas <robertmhaas@gmail.com>
Re: Built-in CTYPE provider "Daniel Verite" <daniel@manitou-mail.org>
Re: Built-in CTYPE provider Jeremy Schneider <schneider@ardentperf.com>
Re: Built-in CTYPE provider Jeremy Schneider <schneider@ardentperf.com>
Re: Built-in CTYPE provider Jeremy Schneider <schneider@ardentperf.com>
Re: Built-in CTYPE provider Jeff Davis <pgsql@j-davis.com>
Re: Built-in CTYPE provider Jeff Davis <pgsql@j-davis.com>
Re: Built-in CTYPE provider "Daniel Verite" <daniel@manitou-mail.org>
Re: Built-in CTYPE provider Jeff Davis <pgsql@j-davis.com>
Re: Built-in CTYPE provider Jeff Davis <pgsql@j-davis.com>
On Fri, 2024-03-22 at 15:51 +0100, Peter Eisentraut wrote:
> I think this might be too big of a compatibility break.  So far, 
> initcap('123abc') has always returned '123abc'.  If the new collation
> returns '123Abc' now, then that's quite a change.  These are not some
> obscure Unicode special case characters, after all.

It's a new collation, so I'm not sure it's a compatibility break. But
you are right that it is against documentation and expectations for
INITCAP().

> What is the ICU configuration incantation for this?  Maybe we could
> have 
> the builtin provider understand some of that, too.

https://unicode-org.github.io/icu-docs/apidoc/dev/icu4c/stringoptions_8h.html#a4975f537b9960f0330b233061ef0608d
https://unicode-org.github.io/icu-docs/apidoc/dev/icu4c/stringoptions_8h.html#afc65fa226cac9b8eeef0e877b8a7744e

> Or we should create a function separate from initcap.

If we create a new function, that also gives us the opportunity to
accept optional arguments to control the behavior rather than relying
on collation for every decision.

Regards,
	Jeff Davis



В списке pgsql-hackers по дате отправления
От: Tom Lane
Дата:
От: Robert Treat
Дата:
FAQ