Jefffrey commented on issue #1429:
URL:
https://github.com/apache/arrow-datafusion/issues/1429#issuecomment-1313463517
If we are using PostgreSQL as baseline, then supplying `g` flag to
`regexp_match()` should indeed result in an error.
```
psql (15.1 (Debian 15.1-1.pgdg110+1))
Type "help" for help.
postgres=# select regexp_match('a', '[a-z]', 'g');
ERROR: regexp_match() does not support the "global" option
HINT: Use the regexp_matches function instead.
postgres=#
```
Reference:
https://www.postgresql.org/docs/current/functions-matching.html#FUNCTIONS-POSIX-REGEXP
Supported flags:
https://www.postgresql.org/docs/current/functions-matching.html#POSIX-EMBEDDED-OPTIONS-TABLE
Seems its `regexp_matches()` which is the one supporting `g` flag, but
doesn't seem to be implemented in Datafusion yet (could raise an issue for
this?)
--
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]
