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