If I correctly understood what you wanted based on the SO description
("Something like: select position ('/s/' or '/b/' or '/t/' in URL)"),you could do that by combining SUBSTRING with position. Something like: SELECT position(substring(URL FROM '/(s|b|t)/') IN URL); Cheers, Ken On Sun, Aug 19, 2018 at 11:27 PM Nick Dro <postgre...@walla.co.il> wrote: > Position function allows only string as pattern parameter: > > select position(sub-string in string) > > If you are looking for more than one sub-string you can't do it with a > single call to position. > More info: > > https://stackoverflow.com/questions/51925037/how-to-find-position-of-multiple-sub-string-in-postgresql > > > Required solution: make sub-string accept regular expression just like the > LIKE operator. > -- AGENCY Software A Free Software data system By and for non-profits *http://agency-software.org/ <http://agency-software.org/>* *https://demo.agency-software.org/client <https://demo.agency-software.org/client>* ken.tan...@agency-software.org (253) 245-3801 Subscribe to the mailing list <agency-general-requ...@lists.sourceforge.net?body=subscribe> to learn more about AGENCY or follow the discussion.
