Re: Allow Reg Expressions in Position function

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 <postgresql(at)walla(dot)co(dot)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(dot)tanzer(at)agency-software(dot)org
(253) 245-3801

Subscribe to the mailing list
<agency-general-request(at)lists(dot)sourceforge(dot)net?body=subscribe> to
learn more about AGENCY or
follow the discussion.