| From: | Shaozhong SHI <shishaozhong(at)gmail(dot)com> |
|---|---|
| To: | Metin Ulusinan <metin(dot)ulusinan(at)ssicilian(dot)net> |
| Cc: | pgsql-sql <pgsql-sql(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Fault with initcap |
| Date: | 2021-10-13 08:48:25 |
| Message-ID: | CA+i5JwaGGpAZeoSfUXXCFbOGMy31YWV8wgEvGO9fX6+c2sHG7w@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-sql |
On Wed, 13 Oct 2021 at 07:33, Metin Ulusinan <metin(dot)ulusinan(at)ssicilian(dot)net>
wrote:
> I tried both on PostgreSQL 11.13 and yes "Sainsbury's bank" 's "S" is
> buggy, but notemachine is not.
>
> Will anyone try @ 14?
>
>
> n s version
> Notemachine Sainsbury'S Bank PostgreSQL 11.13 (Debian 11.13-0+deb10u1) on
> x86_64-pc-linux-gnu, compiled by gcc (Debian 8.3.0-6) 8.3.0, 64-bit
>
>
> Hello, Metin Ulusinan,
>
I can confirm that you pin-out the issue.
There is a INITCAP2. Alternative function to PostgreSQL builtin
initcap(text) with support for accented words. · GitHub
<https://gist.github.com/pv8/8291531>
Can this be adapted to capitalise the first letter of each work in a string?
Regards,
David
| From | Date | Subject | |
|---|---|---|---|
| Next Message | celati Laurent | 2021-10-13 09:04:42 | Grant select for all tables of the 12 schemas of my one db ? |
| Previous Message | Simon Riggs | 2021-10-13 07:40:08 | Re: Avg/max size of these JSON docs in Postgres |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Metin Ulusinan | 2021-10-13 09:38:59 | Re: Fault with initcap |
| Previous Message | JP | 2021-10-13 07:04:41 | Re: Removing JSONB key across all elements of nested array |