Date: Tue, 25 Nov 2025 11:38:17 -0800 (PST)
From: Rich Shepard <rshepard@appl-ecosys.com>
To: pgsql-general <pgsql-general@postgresql.org>
Subject: Re: Selecting all variations of job title in a list
In-Reply-To: <CANzqJaCNFaGTdM9E93_28KMK-AaDSKfP9iq9gbhCNGKh0w8bEA@mail.gmail.com>
Message-ID: <4eafa1c0-7455-2225-5f18-94cfa6f52fb@appl-ecosys.com>
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>
 <CANzqJaCNFaGTdM9E93_28KMK-AaDSKfP9iq9gbhCNGKh0w8bEA@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII; format=flowed
Archived-At: <https://www.postgresql.org/message-id/4eafa1c0-7455-2225-5f18-94cfa6f52fb%40appl-ecosys.com>
Precedence: bulk

On Tue, 25 Nov 2025, Ron Johnson wrote:

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

Ron,

That's okay.

> 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="mumble".

That's impractical. The title table would be hundreds of rows long, most
having only 1 or 2 references. Companies don't have standard titles for
everyone.

Rich