pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Alban Hertroys <haramrae@gmail.com>
To: Eagna <eagna@protonmail.com>
Cc: David G. Johnston <david.g.johnston@gmail.com>
Cc: pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>
Subject: Re: Regular expression for lower case to upper case.
Date: Sun, 11 Dec 2022 11:41:06 +0100
Message-ID: <5C6EE9B5-477D-4206-8C36-D083CE54BED4@gmail.com> (raw)
In-Reply-To: <7EOY6xZE-t6VXu6ozkVJYGeHODc3-_PBubDAGaSXRP_JznkELzYdQJriJsWaIS2nTJ0Esyh0htfsdfEIUrnUUHh--58QQwTpo5y6wQKzrfU=@protonmail.com>
References: <yk4Ucm1Andim5urGdLDSwhTdytxgXWvHVd1PgUZht80zfEiK3Eo-Qz3YKFMI2D2cwhoLcNxY8mNoWbW_Plz65T6YdQpPSll1hPckh7WYeSA=@protonmail.com>
	<CAKFQuwbY3gxxtS9fYqDhog6SgOjx4jGE4s9JxZMcjO_YNosnZQ@mail.gmail.com>
	<7EOY6xZE-t6VXu6ozkVJYGeHODc3-_PBubDAGaSXRP_JznkELzYdQJriJsWaIS2nTJ0Esyh0htfsdfEIUrnUUHh--58QQwTpo5y6wQKzrfU=@protonmail.com>


> On 10 Dec 2022, at 12:00, Eagna <eagna@protonmail.com> wrote:
> 
> 
> 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.

If you put all the regexes and their replacements into a table[1], you could use an aggregate over them to combine all the replacements into the final string. It would need some aggregate like regex_replace_agg, which would probably be a custom aggregate.

[1]: If you stick to ASCII, you could just calculate them and even omit storing them in a physical table.

Alban Hertroys
--
If you can't see the forest for the trees,
cut the trees and you'll find there is no forest.






view thread (8+ messages)

Message-ID: <5C6EE9B5-477D-4206-8C36-D083CE54BED4@gmail.com>
Permalink:  ../5C6EE9B5-477D-4206-8C36-D083CE54BED4@gmail.com/
Also on:    postgresql.org/message-id/5C6EE9B5-477D-4206-8C36-D083CE54BED4@gmail.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-general@postgresql.org
  Cc: haramrae@gmail.com, eagna@protonmail.com, david.g.johnston@gmail.com
  Subject: Re: Regular expression for lower case to upper case.
  In-Reply-To: <5C6EE9B5-477D-4206-8C36-D083CE54BED4@gmail.com>
  References: <yk4Ucm1Andim5urGdLDSwhTdytxgXWvHVd1PgUZht80zfEiK3Eo-Qz3YKFMI2D2cwhoLcNxY8mNoWbW_Plz65T6YdQpPSll1hPckh7WYeSA=@protonmail.com> <CAKFQuwbY3gxxtS9fYqDhog6SgOjx4jGE4s9JxZMcjO_YNosnZQ@mail.gmail.com> <7EOY6xZE-t6VXu6ozkVJYGeHODc3-_PBubDAGaSXRP_JznkELzYdQJriJsWaIS2nTJ0Esyh0htfsdfEIUrnUUHh--58QQwTpo5y6wQKzrfU=@protonmail.com> <5C6EE9B5-477D-4206-8C36-D083CE54BED4@gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox