Re: Selecting all variations of job title in a list
Rich Shepard <rshepard@appl-ecosys.com>
From: Rich Shepard <rshepard@appl-ecosys.com>
To: pgsql-general@lists.postgresql.org
Date: 2025-11-25T19:05:34Z
Lists: pgsql-general
On Tue, 25 Nov 2025, Ron Johnson wrote: > Maybe regex_match() with a bunch of OR clauses. > > In bash, I'd do something like: > grep -E ' ^Asst Gen Mgr.*|^Env Mgr.*|^Gen Mgr.*|^Mgr.*|^Plant Mgr..*' > foo.txt Ron, I've not used regex in postgres before, only in emacs and small languages. So I'll learn how to do this. I was trying to avoid multiple OR clauses, but that script will not be run often so it should not matter. Thanks, Rich