Regular expression to UPPER() a lower case string

From: Eagna <eagna(at)protonmail(dot)com>
To: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Regular expression to UPPER() a lower case string
Date: 2022-12-10 10:32:23
Message-ID: 5C_J_wdWjnwxieBfiMQgeIXLQ5RYXN4-W5jIZyCpkAqlhGO8GxRqwb1jCHfh0EO9SvHYcysvVUXM-ocEBPSb9A-_iiSwfY0DKvljrZ50iA4=@protonmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all,

as per the subject, I want a regular expression to do what the UPPER() function does.

Obviously, I know about that function and it is not what I want.

This should be very (very) easy - I don't know what I'm missing - I've done quite complex regular expressions before and I don't know what I'm doing wrong. Brain burping this morning!

Here's a dbfiddle where I've tried a couple of things (https://dbfiddle.uk/G5c_CycU) - but I just can't seem to get it working...

Any input appreciated.

E.

Sent with [Proton Mail](https://proton.me/) secure email.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Gianni Ceccarelli 2022-12-10 10:41:41 Re: Regular expression to UPPER() a lower case string
Previous Message David G. Johnston 2022-12-10 10:29:02 Re: Regular expression for lower case to upper case.