[
https://issues.apache.org/jira/browse/PHOENIX-2646?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15152828#comment-15152828
]
Julian Hyde commented on PHOENIX-2646:
--------------------------------------
Calcite has {{SIMILAR TO}}, which is standard and (per the standard) uses POSIX
regexps. I'd prefer not to add {{~}} operator (or any other operators based on
punctuation) to Calcite unless we can do it in a "Postgres mode", optional and
disabled by default.
> 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)
