Re: Allow Reg Expressions in Position function

[Ken Tanzer <ken.tanzer@xxxxxxxxx>]

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@xxxxxxxxxxx> 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/

https://demo.agency-software.org/client

ken.tanzer@xxxxxxxxxxxxxxxxxxx

(253) 245-3801

Subscribe to the mailing list to

learn more about AGENCY or

follow the discussion.