normanj-bitquill commented on PR #3801: URL: https://github.com/apache/calcite/pull/3801#issuecomment-2223905686
Updated with the following behaviour: ### Amazon Redshift * Can provide only two arguments. The replacement string will be the empty string. https://docs.aws.amazon.com/redshift/latest/dg/REGEXP_REPLACE.html ### PostgreSQL * With 3 arguments, only the first occurrence is replaced * With 4 arguments, the last argument is flags. If flags contains `g`, then all occurrences will be replaced. * Cannot provide more than 4 arguments ### BigQuery, MySQL, Oracle, Amazon Redshift * Must provide at least 3 arguments * No change to behaviour https://www.postgresql.org/docs/14/functions-matching.html#FUNCTIONS-POSIX-REGEXP -- 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]
