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

From Rich Shepard
Subject Re: Selecting all variations of job title in a list
Date
Msg-id 9172514f-c267-6160-4b2a-7bd4eaf5be4@appl-ecosys.com
Whole thread Raw
In response to Selecting all variations of job title in a list  (Rich Shepard <rshepard@appl-ecosys.com>)
Responses Re: Selecting all variations of job title in a list
List pgsql-general
On Tue, 25 Nov 2025, Adrian Klaver wrote:

> Something like?:
> 
> select 'Env mgr.' ilike  ANY(ARRAY['Asst Gen Mgr.', 'Env Mgr.', 'Gen Mgr.', 
> 'Mgr.','Plant Mgr.']);

Adrian,

Hadn't thought of this.

Your, and Ron's, answers taught me that the answer to my question is 'no,
there is no shortcut.' :-)

Thanks,

Rich



pgsql-general by date:

Previous
From: Rich Shepard
Date:
Subject: Re: Selecting all variations of job title in a list
Next
From: Pavel Suderevsky
Date:
Subject: Commit LSN after Redo Done At LSN applied during recovery