Home > mailing lists

Re: Fault with initcap - Mailing list pgsql-sql

From	Pavel Stehule
Subject	Re: Fault with initcap
Date	October 13, 2021 10:03:45
Msg-id	CAFj8pRDPbOj8KvjFH7W_S9j5qEKTQVZ1PsHE9jTvPit+rKRr=Q@mail.gmail.com Whole thread Raw
In response to	Re: Fault with initcap (Metin Ulusinan <metin.ulusinan@ssicilian.net>)
List	pgsql-sql

st 13. 10. 2021 v 8:34 odesílatel Metin Ulusinan <metin.ulusinan@ssicilian.net> napsal:

I tried both on PostgreSQL 11.13 and yes "Sainsbury's bank" 's "S" is buggy, but notemachine is not.

Will anyone try @ 14?

It cannot to work everywhere - the word is defined (for this function) as sequence of alpha numeric chars. "'" is not alpha numeric char.

Theoretically it can work if you use ICU collation provider, if it is supported by ICU.

Regards

Pavel

From: Metin Ulusinan
Date: 13 October 2021, 09:33:43
Subject: Re: Fault with initcap

From: JP
Date: 13 October 2021, 10:04:41
Subject: Re: Removing JSONB key across all elements of nested array