[
https://issues.apache.org/jira/browse/PHOENIX-2646?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15153188#comment-15153188
]
Julian Hyde commented on PHOENIX-2646:
--------------------------------------
CALCITE-1066 is a work in progress. It would allow extra sets of functions. But
a compatibility mode that affects the parser -- which you would need for {{~}}
-- would be a different task.
Postgres is wonderful but some of their ideas about syntax and in particular
user-defined operators and types reflect the heady days of the OO revolution
circa 1993 and IMHO are best left in 1993.
> Extend VARCHAR matching with ~ regex syntax
> -------------------------------------------
>
> Key: PHOENIX-2646
> URL: https://issues.apache.org/jira/browse/PHOENIX-2646
> Project: Phoenix
> Issue Type: New Feature
> Reporter: Nick Dimiduk
>
> We already support {{REGEXP}} functions for string manipulation. Let's add
> full regex matching support as well. For example, Postgres has the {{~}}
> operator for [POSIX regular expression
> matching|http://www.postgresql.org/docs/9.3/static/functions-matching.html#FUNCTIONS-POSIX-REGEXP].
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
