MIME-Version: 1.0
From: Bo Guo <bo.guo@gisticinc.com>
Date: Sat, 2 Dec 2023 12:03:45 -0700
Message-ID: 
 <CADHFRch1=ND1TpiOidJELBdJJSugn-H1d3vyjg9gh9Nw1dZCgg@mail.gmail.com>
Subject: Overcoming Initcap Function limitations?
To: pgsql-sql@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000f3fc88060b8b8bac"
Archived-At: 
 <https://www.postgresql.org/message-id/CADHFRch1%3DND1TpiOidJELBdJJSugn-H1d3vyjg9gh9Nw1dZCgg%40mail.gmail.com>
Precedence: bulk

--000000000000f3fc88060b8b8bac
Content-Type: text/plain; charset="UTF-8"

Hi there,

The Initcap function does not have the option to support the title casing
where articles/prepositions are left in lowercase. Neither does it handle
cultural names such as "MacDonald."

Please kindly advise any options we may have.

Cheers,

Bo

--000000000000f3fc88060b8b8bac
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div><div dir=3D"ltr" class=3D"gmail_signature" data-smart=
mail=3D"gmail_signature"><div dir=3D"ltr"><div><div>Hi there,</div><div><br=
></div><div>The Initcap function does not have the option to support the ti=
tle casing where articles/prepositions are left in lowercase. Neither does =
it handle cultural names such as &quot;MacDonald.&quot;=C2=A0 <br></div><di=
v><br></div><div>Please kindly advise any options we may have.</div><div><b=
r></div><div>Cheers,</div><div><br></div><div>Bo<br></div></div></div></div=
></div></div>

--000000000000f3fc88060b8b8bac--