[
https://issues.apache.org/jira/browse/CALCITE-3063?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
ASF GitHub Bot updated CALCITE-3063:
------------------------------------
Labels: postgresql pull-request-available (was: postgresql)
> Babel parse should parse PostgreSQL posix regular expressions
> -------------------------------------------------------------
>
> Key: CALCITE-3063
> URL: https://issues.apache.org/jira/browse/CALCITE-3063
> Project: Calcite
> Issue Type: Bug
> Components: babel
> Affects Versions: 1.19.0
> Reporter: Muhammad Gelbana
> Assignee: Muhammad Gelbana
> Priority: Major
> Labels: postgresql, pull-request-available
>
> Quoting from the referenced link below, posix operators are:
> ||Operator||Description||Example||
> |{{~}}|Matches regular expression, case sensitive|{{'thomas' ~ '.*thomas.*'}}|
> |{{~*}}|Matches regular expression, case insensitive|{{'thomas' ~*
> '.*Thomas.*'}}|
> |{{!~}}|Does not match regular expression, case sensitive|{{'thomas' !~
> '.*Thomas.*'}}|
> |{{!~*}}|Does not match regular expression, case insensitive|{{'thomas' !~*
> '.*vadim.*'}}|
>
> +Reference:+
> https://www.postgresql.org/docs/11/functions-matching.html#FUNCTIONS-POSIX-REGEXP
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
