phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Julian Hyde (JIRA)" <>
Subject [jira] [Commented] (PHOENIX-2646) Extend VARCHAR matching with ~ regex syntax
Date Tue, 23 Feb 2016 18:59:18 GMT


Julian Hyde commented on PHOENIX-2646:

I'd only expect ANY and ALL to work for a small set of built-in operators. As you've noticed
it's extra work to get them to work for each new operator.

'= ANY (array)' is not standard; '= ANY (query)' is standard. Calcite doesn't implement either.
For the latter, we recommend that people manually rewrite to EXISTS. Not sure whether EXISTS
would work on an array.

> Extend VARCHAR matching with ~ regex syntax
> -------------------------------------------
>                 Key: PHOENIX-2646
>                 URL:
>             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|].

This message was sent by Atlassian JIRA

View raw message