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 по дате отправления