public inbox for [email protected]help / color / mirror / Atom feed
Re: Selecting all variations of job title in a list 3+ messages / 2 participants [nested] [flat]
* Re: Selecting all variations of job title in a list @ 2025-11-25 20:46 Adrian Klaver <[email protected]> 0 siblings, 1 reply; 3+ messages in thread From: Adrian Klaver @ 2025-11-25 20:46 UTC (permalink / raw) To: Rich Shepard <[email protected]>; [email protected] On 11/25/25 11:08, Rich Shepard wrote: > 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.' :-) You will need to be clearer about what you want. If it is to fetch titles with Mgr in the name then it would be simple: select * from people_table where title ilike '%mgr%'; If it is something more selective you will need to provide a more detailed example. > > Thanks, > > Rich > > -- Adrian Klaver [email protected] ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Selecting all variations of job title in a list @ 2025-11-25 20:53 Rich Shepard <[email protected]> parent: Adrian Klaver <[email protected]> 0 siblings, 1 reply; 3+ messages in thread From: Rich Shepard @ 2025-11-25 20:53 UTC (permalink / raw) To: [email protected] On Tue, 25 Nov 2025, Adrian Klaver wrote: > You will need to be clearer about what you want. > > If it is to fetch titles with Mgr in the name then it would be simple: > > select * from people_table where title ilike '%mgr%'; > > If it is something more selective you will need to provide a more detailed > example. Adrian, I thought my example was clear: there are modifiers to job titles such as 'Manager,' 'Vice President,' 'Engineer.' That's why I asked if the `like/ilike' modifier would work in a list passed to the `in' command. Rich ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Selecting all variations of job title in a list @ 2025-11-25 20:58 Adrian Klaver <[email protected]> parent: Rich Shepard <[email protected]> 0 siblings, 0 replies; 3+ messages in thread From: Adrian Klaver @ 2025-11-25 20:58 UTC (permalink / raw) To: Rich Shepard <[email protected]>; [email protected] On 11/25/25 12:53, Rich Shepard wrote: > On Tue, 25 Nov 2025, Adrian Klaver wrote: > >> You will need to be clearer about what you want. >> >> If it is to fetch titles with Mgr in the name then it would be simple: >> >> select * from people_table where title ilike '%mgr%'; >> >> If it is something more selective you will need to provide a more >> detailed example. > > Adrian, > > I thought my example was clear: there are modifiers to job titles such as > 'Manager,' 'Vice President,' 'Engineer.' That's why I asked if the > `like/ilike' modifier would work in a list passed to the `in' command. So what are you searching on, the title, the modifier or both? > > Rich > > -- Adrian Klaver [email protected] ^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2025-11-25 20:58 UTC | newest] Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2025-11-25 20:46 Re: Selecting all variations of job title in a list Adrian Klaver <[email protected]> 2025-11-25 20:53 ` Rich Shepard <[email protected]> 2025-11-25 20:58 ` Adrian Klaver <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox