Re: Regular expression to UPPER() a lower case string

From: Eagna <eagna(at)protonmail(dot)com>
To: Gianni Ceccarelli <dakkar(at)thenautilus(dot)net>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Regular expression to UPPER() a lower case string
Date: 2022-12-10 11:03:38
Message-ID: PBBDM2FhmXWAycOqgjpICsUhj9Maw4OXlQAzUXVgXHKbfM6uHOlQiKcotY_eNv9nS4XcTAWnRaeGIbUIKUHUzfr9c22pvDvt5pWir2FBRn0=@protonmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ciao and thanks for your input.

> * `regexp_replace` doesn't work like that, at all
> * your logic only works by accident for some languages (try to upcase
> a `ß` or a `ı`)

If you have any ideas how it could be done indirectly/different strategy - I'm all ears.

You can assume all English characters [a-z][A-Z].

E.


> Dakkar - <Mobilis in mobile>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Gianni Ceccarelli 2022-12-10 12:06:54 Re: Regular expression to UPPER() a lower case string
Previous Message Eagna 2022-12-10 11:00:48 Re: Regular expression for lower case to upper case.