Horton
Menu

Re: Selecting all variations of job title in a list

David G. Johnston <david.g.johnston@gmail.com>

View thread
From: "David G. Johnston" <david.g.johnston@gmail.com>
To: Rich Shepard <rshepard@appl-ecosys.com>
Cc: "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Date: 2025-11-25T21:15:36Z
Lists: pgsql-general 
On Tuesday, November 25, 2025, Rich Shepard <rshepard@appl-ecosys.com>
wrote:

> Companies can have slightly different titles for the same job; for example
> (using abbreviations). 'Asst Gen Mgr.', 'Env Mgr,', 'Gen Mgr,'. 'Mgr,',
> 'Plant Mgr.'
>

Suggest encoding that knowledge in a table then using normal joins and
filters to query against whatever you;ve decided is the canonical spelling
of the relevant position.

David J.