Re: Regular expression for lower case to upper case.

From: Eagna <eagna(at)protonmail(dot)com>
To: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Regular expression for lower case to upper case.
Date: 2022-12-10 11:00:48
Message-ID: 7EOY6xZE-t6VXu6ozkVJYGeHODc3-_PBubDAGaSXRP_JznkELzYdQJriJsWaIS2nTJ0Esyh0htfsdfEIUrnUUHh--58QQwTpo5y6wQKzrfU=@protonmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Eagna 2022-12-10 11:03:38 Re: Regular expression to UPPER() a lower case string
Previous Message Eagna 2022-12-10 10:57:32 Re: Regular expression for lower case to upper case.