MIME-Version: 1.0
References: <c5296761-2f10-a59b-ad16-a0189e57cd5a@appl-ecosys.com>
 <CANzqJaAJWTjLjn2v3kTcephXx=oo6Wt+k-8wR_P4qbFpA3heyQ@mail.gmail.com> <8f256754-4ece-b67d-de5b-188b72b8a410@appl-ecosys.com>
In-Reply-To: <8f256754-4ece-b67d-de5b-188b72b8a410@appl-ecosys.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Tue, 25 Nov 2025 14:29:41 -0500
Message-ID: <CANzqJaCNFaGTdM9E93_28KMK-AaDSKfP9iq9gbhCNGKh0w8bEA@mail.gmail.com>
Subject: Re: Selecting all variations of job title in a list
To: pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000cc27060644704d1b"
Archived-At: <https://www.postgresql.org/message-id/CANzqJaCNFaGTdM9E93_28KMK-AaDSKfP9iq9gbhCNGKh0w8bEA%40mail.gmail.com>
Precedence: bulk

--000000000000cc27060644704d1b
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Tue, Nov 25, 2025 at 2:05=E2=80=AFPM Rich Shepard <rshepard@appl-ecosys.=
com>
wrote:

> 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.
>

Failed clarity on my part.  The "OR clauses" are within the regex string.

Note that The Relational Way of doing this is for everyone to have
title_code in their "person" record, and the "title" table will have, in
addition to the title_code PK column, the title_description,
title_abbreviation ( 'Asst Gen Mgr.', 'Env Mgr,', 'Gen Mgr,'. 'Mgr,',
'Plant Mgr.') and title_group columns.  All those manager titles would be
in the same group.  You'd then join "person" to "title" and filter where
title_group=3D"mumble".

--=20
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

--000000000000cc27060644704d1b
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">On Tue, Nov 25, 2025 at 2:05=E2=80=AFPM R=
ich Shepard &lt;<a href=3D"mailto:rshepard@appl-ecosys.com">rshepard@appl-e=
cosys.com</a>&gt; wrote:</div><div class=3D"gmail_quote gmail_quote_contain=
er"><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;bor=
der-left:1px solid rgb(204,204,204);padding-left:1ex">On Tue, 25 Nov 2025, =
Ron Johnson wrote:<br>
<br>
&gt; Maybe regex_match() with a bunch of OR clauses.<br>
&gt;<br>
&gt; In bash, I&#39;d do something like:<br>
&gt; grep -E &#39; ^Asst Gen Mgr.*|^Env Mgr.*|^Gen Mgr.*|^Mgr.*|^Plant Mgr.=
.*&#39;<br>
&gt; foo.txt<br>
<br>
Ron,<br>
<br>
I&#39;ve not used regex in postgres before, only in emacs and small languag=
es.<br>
So I&#39;ll learn how to do this. I was trying to avoid multiple OR clauses=
, but<br>
that script will not be run often so it should not matter.<br></blockquote>=
<div><br></div><div></div></div><div>Failed clarity on my part.=C2=A0 The &=
quot;OR clauses&quot; are within the regex string.</div><div><br></div><div=
>Note that The Relational Way of doing this is for everyone to have title_c=
ode in their &quot;person&quot; record, and the &quot;title&quot; table wil=
l have, in addition to the title_code PK column, the title_description, tit=
le_abbreviation ( &#39;Asst Gen Mgr.&#39;, &#39;Env Mgr,&#39;, &#39;Gen Mgr=
,&#39;. &#39;Mgr,&#39;, &#39;Plant Mgr.&#39;) and title_group columns.=C2=
=A0 All those manager=C2=A0titles would be in the same group.=C2=A0 You&#39=
;d then join &quot;person&quot; to &quot;title&quot; and filter where title=
_group=3D&quot;mumble&quot;.</div><div><br></div><span class=3D"gmail_signa=
ture_prefix">-- </span><br><div dir=3D"ltr" class=3D"gmail_signature"><div =
dir=3D"ltr">Death to &lt;Redacted&gt;, and butter sauce.<div>Don&#39;t boil=
 me, I&#39;m still alive.<br><div><div>&lt;Redacted&gt; lobster!</div></div=
></div></div></div></div>

--000000000000cc27060644704d1b--