Request a Demo
Home   >   mailing lists

Re: Selecting all variations of job title in a list - Mailing list pgsql-general

From David G. Johnston
Subject Re: Selecting all variations of job title in a list
Date
Msg-id CAKFQuwZF2m5GVp-VqoZcZ953NZt83MVQyhsWqq0ADuK5xMUf-Q@mail.gmail.com
Whole thread Raw
In response to Selecting all variations of job title in a list  (Rich Shepard <rshepard@appl-ecosys.com>)
List pgsql-general
Tree view
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.

pgsql-general by date:

Previous
From: Jan Claeys
Date:
Subject: Re: Schema design: user account deletion vs. keeping family tree data
Next
From: Adrian Klaver
Date:
Subject: Re: Restore Windows dump to Linux (locale issue)