ב אוג׳ 20, 2018 10:31, Ken Tanzer כתב: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,
KenOn Sun, Aug 19, 2018 at 11:27 PM Nick Dro <postgresql@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:Required solution: make sub-string accept regular expression just like the LIKE operator.--AGENCY SoftwareA Free Software data systemBy and for non-profits(253) 245-3801learn more about AGENCY orfollow the discussion.