Re: Regular expression for lower case to upper case. - Mailing list pgsql-general

From Eagna
Subject Re: Regular expression for lower case to upper case.
Date
Msg-id 7EOY6xZE-t6VXu6ozkVJYGeHODc3-_PBubDAGaSXRP_JznkELzYdQJriJsWaIS2nTJ0Esyh0htfsdfEIUrnUUHh--58QQwTpo5y6wQKzrfU=@protonmail.com
Whole thread Raw
In response to Re: Regular expression for lower case to upper case.  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: Regular expression for lower case to upper case.  ("Peter J. Holzer" <hjp-pgsql@hjp.at>)
Re: Regular expression for lower case to upper case.  (Alban Hertroys <haramrae@gmail.com>)
List pgsql-general
Hi, and thanks for your input.


> RegExp by itself cannot do this. You have to match all parts of the input into different capturing groups, then use
lower()combined with format() to build a new string. Putting the capturing groups into an array is the most useful
option.


OK - I *_kind_* of see what you're saying.

There's a small fiddle here (https://dbfiddle.uk/rhw1AdBY) if you'd care to give an outline of the solution that you
propose.

Thanks again,

E.

> David J.





pgsql-general by date:

Previous
From: Eagna
Date:
Subject: Re: Regular expression for lower case to upper case.
Next
From: Eagna
Date:
Subject: Re: Regular expression to UPPER() a lower case string