MIME-Version: 1.0
References: <c5296761-2f10-a59b-ad16-a0189e57cd5a@appl-ecosys.com>
In-Reply-To: <c5296761-2f10-a59b-ad16-a0189e57cd5a@appl-ecosys.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Tue, 25 Nov 2025 11:49:36 -0500
Message-ID: <CANzqJaAJWTjLjn2v3kTcephXx=oo6Wt+k-8wR_P4qbFpA3heyQ@mail.gmail.com>
Subject: Re: Selecting all variations of job title in a list
To: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000492eb606446e1116"
Archived-At: <https://www.postgresql.org/message-id/CANzqJaAJWTjLjn2v3kTcephXx%3Doo6Wt%2Bk-8wR_P4qbFpA3heyQ%40mail.gmail.com>
Precedence: bulk

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

On Tue, Nov 25, 2025 at 11:33=E2=80=AFAM Rich Shepard <rshepard@appl-ecosys=
.com>
wrote:

> Companies can have slightly different titles for the same job; for exampl=
e
> (using abbreviations). 'Asst Gen Mgr.', 'Env Mgr,', 'Gen Mgr,'. 'Mgr,',
> 'Plant Mgr.'
>
> I want to select all people table rows that contain these varieties. I kn=
ow
> the 'like' operator uses '%' as a wildcard, but is not accepted in an 'in=
'
> list.
>
> Is there a way to use a multicharacter wildcard in an 'in' list?
>

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

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

--000000000000492eb606446e1116
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 11:33=E2=80=AFAM =
Rich Shepard &lt;<a href=3D"mailto:rshepard@appl-ecosys.com">rshepard@appl-=
ecosys.com</a>&gt; wrote:</div><div class=3D"gmail_quote gmail_quote_contai=
ner"><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;bo=
rder-left:1px solid rgb(204,204,204);padding-left:1ex">Companies can have s=
lightly different titles for the same job; for example<br>
(using abbreviations). &#39;Asst Gen Mgr.&#39;, &#39;Env Mgr,&#39;, &#39;Ge=
n Mgr,&#39;. &#39;Mgr,&#39;,<br>
&#39;Plant Mgr.&#39;<br>
<br>
I want to select all people table rows that contain these varieties. I know=
<br>
the &#39;like&#39; operator uses &#39;%&#39; as a wildcard, but is not acce=
pted in an &#39;in&#39;<br>
list.<br>
<br>
Is there a way to use a multicharacter wildcard in an &#39;in&#39; list?<br=
></blockquote><div></div></div><div><br></div><div>Maybe regex_match() with=
 a bunch of OR clauses.</div><div><br></div><div>In bash, I&#39;d do someth=
ing like:</div><div>grep -E &#39; ^Asst Gen Mgr.*|^Env Mgr.*|^Gen Mgr.*|^Mg=
r.*|^Plant Mgr..*&#39; foo.txt</div><div><br></div><span class=3D"gmail_sig=
nature_prefix">-- </span><br><div dir=3D"ltr" class=3D"gmail_signature"><di=
v dir=3D"ltr">Death to &lt;Redacted&gt;, and butter sauce.<div>Don&#39;t bo=
il me, I&#39;m still alive.<br><div><div>&lt;Redacted&gt; lobster!</div></d=
iv></div></div></div></div>

--000000000000492eb606446e1116--