On Wednesday, November 26, 2025, Vincent Veyron <
vv.lists@wanadoo.fr> wrote:
On Wed, 26 Nov 2025 07:10:16 -0800 (PST)
Rich Shepard <rshepard@appl-ecosys.com> wrote:
>
> Learning postgres regexp is at the top of my list.
>
https://perldoc.perl.org/perlre
Read the first few pages and you'll be good to go.
I was using this tool a while back when I was doing heavy regex work.
Keep in mind the native flavor of regex in PostgreSQL is TCL, not Perl.
But I’d still say regexp is not the best solution here - unless you encapsulate the logic in a function. I suspect you’ll want to use this logic in more than just a single query and with a literal regexp you have to rely on manual synchronization. Note, you could combine the lookup table with regexes. Though beware of ensure you don’t produce duplicate matches if you go that route.
David J.
