[ https://issues.apache.org/jira/browse/CALCITE-3063?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16877336#comment-16877336 ]
Muhammad Gelbana commented on CALCITE-3063: ------------------------------------------- Understood. Sorry I didn't know that. Thanks :) > 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: pull-request-available > Fix For: 1.21.0 > > Time Spent: 1h > Remaining Estimate: 0h > > 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)