Date: Wed, 26 Nov 2025 07:10:16 -0800 (PST)
From: Rich Shepard <rshepard@appl-ecosys.com>
To: pgsql-general@lists.postgresql.org
Subject: Re: Selecting all variations of job title in a list
In-Reply-To: <20251126154844.e6e3d5c7f476cc966fc201f4@wanadoo.fr>
Message-ID: <29ffee7e-40a8-f911-4419-24ba8558f5db@appl-ecosys.com>
References: <c5296761-2f10-a59b-ad16-a0189e57cd5a@appl-ecosys.com> <20251126154844.e6e3d5c7f476cc966fc201f4@wanadoo.fr>
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII; format=flowed
Archived-At: <https://www.postgresql.org/message-id/29ffee7e-40a8-f911-4419-24ba8558f5db%40appl-ecosys.com>
Precedence: bulk

On Wed, 26 Nov 2025, Vincent Veyron wrote:

> As Ron wrote, a regexp would do it, I guess?
>
> SELECT * FROM people WHERE title ~ 'Asst Gen Mgr|Env Mgr|Gen Mgr|Mgr|Plant Mgr';
>
> Although in your example, you would get the same result with just:
>
> SELECT * FROM people WHERE title ~ 'Mgr';
>
> https://www.postgresql.org/docs/current/functions-matching.html#FUNCTIONS-POSIX-REGEXP

Vincent,

Learning postgres regexp is at the top of my list.

Thanks,

Rich