[ 
https://issues.apache.org/jira/browse/CALCITE-3063?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Muhammad Gelbana updated CALCITE-3063:
--------------------------------------
    Labels: postgresql pull-requests-available  (was: postgresql 
pull-request-available)

> 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-requests-available
>          Time Spent: 10m
>  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)

Reply via email to