Fault with initcap

From: Shaozhong SHI <shishaozhong(at)gmail(dot)com>
To: pgsql-sql <pgsql-sql(at)lists(dot)postgresql(dot)org>
Subject: Fault with initcap
Date: 2021-10-12 16:30:26
Message-ID: CA+i5JwZNEkm_geK6wSfc03D-qCaccOsW+_O2Dcc0h1VOBQfz2Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

I tried initcap and found a major problem with it.

Initcap of notemachine is NoteMachine.

Initcap of Sainsbury's Bank is Sainsbury'S bank.

This is not expected.

Anyway to get around this problem?

Regards,

David

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Shaozhong SHI 2021-10-12 16:31:02 Fault with initcap
Previous Message Simon Riggs 2021-10-12 07:43:25 Re: Avg/max size of these JSON docs in Postgres

Browse pgsql-sql by date

  From Date Subject
Next Message Shaozhong SHI 2021-10-12 16:31:02 Fault with initcap
Previous Message Steve Midgley 2021-10-11 19:09:37 Re: Removing JSONB key across all elements of nested array