Re: Selecting all variations of job title in a list
| От | Ron Johnson |
|---|---|
| Тема | Re: Selecting all variations of job title in a list |
| Дата | |
| Msg-id | CANzqJaAJWTjLjn2v3kTcephXx=oo6Wt+k-8wR_P4qbFpA3heyQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | Selecting all variations of job title in a list (Rich Shepard <rshepard@appl-ecosys.com>) |
| Ответы |
Re: Selecting all variations of job title in a list
|
| Список | pgsql-general |
On Tue, Nov 25, 2025 at 11:33 AM Rich Shepard <rshepard@appl-ecosys.com> wrote:
Companies can have slightly different titles for the same job; for example
(using abbreviations). 'Asst Gen Mgr.', 'Env Mgr,', 'Gen Mgr,'. 'Mgr,',
'Plant Mgr.'
I want to select all people table rows that contain these varieties. I know
the 'like' operator uses '%' as a wildcard, but is not accepted in an 'in'
list.
Is there a way to use a multicharacter wildcard in an 'in' list?
Maybe regex_match() with a bunch of OR clauses.
In bash, I'd do something like:
grep -E ' ^Asst Gen Mgr.*|^Env Mgr.*|^Gen Mgr.*|^Mgr.*|^Plant Mgr..*' foo.txt
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!
В списке pgsql-general по дате отправления: