Re: psql method (initcap and also keep Roman number capitalized)

From: Martin Stöcker <martin(dot)stoecker(at)stb-datenservice(dot)de>
To: pgsql-sql(at)lists(dot)postgresql(dot)org
Subject: Re: psql method (initcap and also keep Roman number capitalized)
Date: 2018-04-30 11:22:31
Message-ID: de600de8-9f42-df27-b894-357fd88ae061@stb-datenservice.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi Emi,

I think you can do this only with knowledge about the meaning of these
strings.
It is no question of psql or any other database system but of language
an logic.

Take for example "Modern Music Mix".
This can be a mix-up of music but also the 1009th part of a collection.

Or for example the car Hyundai Tucson ix, where ix doesn't mean the
number 9.

Regards Martin

Am 27.04.2018 um 16:39 schrieb Emi:
> Hello,
>
> May I know is there a psql method that can do similar to initcap, and
> could also keep Roman numbers (II, IV, VI, etc) to be capitalized please?
>
> For example, string shows "Title II" but not "Title Ii".
>
> Thanks a lot.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Alvin D?az 2018-05-06 22:51:09 Access to table only through functions
Previous Message Emi 2018-04-27 14:39:54 psql method (initcap and also keep Roman number capitalized)