Re: Selecting all variations of job title in a list

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
Cc: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Selecting all variations of job title in a list
Date: 2025-11-25 21:15:36
Message-ID: CAKFQuwZF2m5GVp-VqoZcZ953NZt83MVQyhsWqq0ADuK5xMUf-Q@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tuesday, November 25, 2025, Rich Shepard <rshepard(at)appl-ecosys(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2025-11-25 21:20:04 Re: Restore Windows dump to Linux (locale issue)
Previous Message Jan Claeys 2025-11-25 21:08:40 Re: Schema design: user account deletion vs. keeping family tree data