Omega359 opened a new issue, #9102: URL: https://github.com/apache/arrow-datafusion/issues/9102
### Is your feature request related to a problem or challenge? Currently there is regexp_match and regexp_replace however there isn't a corresponding regexp_like function that could be used in when(..) dataframe method or sql case statements. ### Describe the solution you'd like An implementation of regexp_like that matches the syntax and style of the [postgresql implementation](https://www.postgresql.org/docs/16/functions-string.html) as close as possible. Note that the Spark version of the [regexp_like function](https://spark.apache.org/docs/latest/api/sql/#regexp_like) is very similar but does not include any flags in the function signature. Not all of the flags that [postgresql supports](https://www.postgresql.org/docs/16/functions-matching.html#POSIX-EMBEDDED-OPTIONS-TABLE) may be included in the initial implementation - likely just 'i' may be implemented. It is noted that the implementation for the existing regexp_match currently resides in datafusion however with https://github.com/apache/arrow-rs/pull/5235 this functionality was moved into arrow_rs (but has yet to be removed from datafusion). The implementation for regexp_like may take a similar path - implement in datafusion first then move to arrow_rs if the community thinks that would be a good idea. ### Describe alternatives you've considered You can use regexp_match and test the return list for empty to imitate this function however that is not the most performant way to implement this as that methodology cannot return immediately after the first match. ### Additional context _No response_ -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
