Re: Selecting all variations of job title in a list

Rich Shepard <rshepard@appl-ecosys.com>

From: Rich Shepard <rshepard@appl-ecosys.com>
To: pgsql-general@lists.postgresql.org
Date: 2025-11-25T19:08:23Z
Lists: 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