| From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
|---|---|
| To: | Metin Ulusinan <metin(dot)ulusinan(at)ssicilian(dot)net> |
| Cc: | Shaozhong SHI <shishaozhong(at)gmail(dot)com>, pgsql-sql <pgsql-sql(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Fault with initcap |
| Date: | 2021-10-13 07:03:45 |
| Message-ID: | CAFj8pRDPbOj8KvjFH7W_S9j5qEKTQVZ1PsHE9jTvPit+rKRr=Q@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-sql |
st 13. 10. 2021 v 8:34 odesílatel Metin Ulusinan <
metin(dot)ulusinan(at)ssicilian(dot)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 | Date | Subject | |
|---|---|---|---|
| Next Message | Simon Riggs | 2021-10-13 07:40:08 | Re: Avg/max size of these JSON docs in Postgres |
| Previous Message | Metin Ulusinan | 2021-10-13 06:33:43 | Re: Fault with initcap |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | JP | 2021-10-13 07:04:41 | Re: Removing JSONB key across all elements of nested array |
| Previous Message | Metin Ulusinan | 2021-10-13 06:33:43 | Re: Fault with initcap |