Overcoming Initcap Function limitations?

From: Bo Guo <bo(dot)guo(at)gisticinc(dot)com>
To: pgsql-sql(at)lists(dot)postgresql(dot)org
Subject: Overcoming Initcap Function limitations?
Date: 2023-12-02 19:03:45
Message-ID: CADHFRch1=ND1TpiOidJELBdJJSugn-H1d3vyjg9gh9Nw1dZCgg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Greg Sabino Mullane 2023-12-04 18:08:03 Re: Overcoming Initcap Function limitations?
Previous Message Jean-Marc Voillequin (MA) 2023-11-29 16:26:36 RE: Bad execution plan when joining partitioned tables