[
https://issues.apache.org/jira/browse/PHOENIX-2646?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15153416#comment-15153416
]
Nick Dimiduk commented on PHOENIX-2646:
---------------------------------------
bq. 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.
A conversation for elsewhere, but I think Postgres's openness to user-defined
operators and types is an empowering feature. Would be a shame to now allow
such things for a SQL interface on top of a semi-structured store like HBase.
> 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)
