Re: Selecting all variations of job title in a list

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Selecting all variations of job title in a list
Date: 2025-11-25 19:08:23
Message-ID: 9172514f-c267-6160-4b2a-7bd4eaf5be4@appl-ecosys.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Suderevsky 2025-11-25 19:10:13 Commit LSN after Redo Done At LSN applied during recovery
Previous Message Rich Shepard 2025-11-25 19:05:34 Re: Selecting all variations of job title in a list