Add strpos scalar string function.

[surister]

Problem Statement

Add strpos(string, substring) -> int function, as it exists in PostgreSQL, see https://www.postgresql.org/docs/current/functions-string.html

Example:
strpos('high', 'ig') -> 2

strpos('abracadabra', 'abra') -> 0

This would improve PostgreSQL and in my use case, Tableau integration.

Possible Solutions

No response

Considered Alternatives

No response

[DHRUV6029]

can i work on this?

[BaurzhanSakhariev]

Sure, assigned it to you

[DHRUV6029]

Hello,
Just a small clarification, in postgresql the index starts from 1 strpos('abracadabra', 'abra') -> 0 will be 1 if you run in postgresql db , output will be 0 if there is no match.

so question is do we want to keep 0 indexed or 1 indexed?

[surister]

I'd favor postgres compatibility, but core team should advice

[DHRUV6029]

I am done with the impl , please let me know if we are to follow postgres compatibility or want to go with 0 index?

[BaurzhanSakhariev]

Let's do it PG compatible, 1 based and 0 for no match.
Thanks!

[DHRUV6029]

ok

[matriv]

This has been closed by #15815
Thx again for the contribution @DHRUV6029 !