Date: Tue, 25 Nov 2025 11:05:34 -0800 (PST)
From: Rich Shepard <rshepard@appl-ecosys.com>
To: pgsql-general@lists.postgresql.org
Subject: Re: Selecting all variations of job title in a list
In-Reply-To: <CANzqJaAJWTjLjn2v3kTcephXx=oo6Wt+k-8wR_P4qbFpA3heyQ@mail.gmail.com>
Message-ID: <8f256754-4ece-b67d-de5b-188b72b8a410@appl-ecosys.com>
References: <c5296761-2f10-a59b-ad16-a0189e57cd5a@appl-ecosys.com> <CANzqJaAJWTjLjn2v3kTcephXx=oo6Wt+k-8wR_P4qbFpA3heyQ@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset=US-ASCII
Archived-At: <https://www.postgresql.org/message-id/8f256754-4ece-b67d-de5b-188b72b8a410%40appl-ecosys.com>
Precedence: bulk

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