Re: Selecting all variations of job title in a list

On Wed, 26 Nov 2025, David G. Johnston wrote:

> I was using this tool a while back when I was doing heavy regex work.
>
> https://www.regexbuddy.com/
>
> 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,

Thanks,

Rich