Re: Regular expression for lower case to upper case.
Eagna <eagna@protonmail.com>
From: Eagna <eagna@protonmail.com>
To: "David G. Johnston" <david.g.johnston@gmail.com>
Cc: "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Date: 2022-12-10T11:00:48Z
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.