[ https://issues.apache.org/jira/browse/CALCITE-3063?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Muhammad Gelbana reassigned CALCITE-3063: ----------------------------------------- Assignee: Muhammad Gelbana > 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 > > 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)