[
https://issues.apache.org/jira/browse/CALCITE-3796?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17039065#comment-17039065
]
Stamatis Zampetakis commented on CALCITE-3796:
----------------------------------------------
It seems that queries with comparison operators on arrays already pass from the
parser and validator so it doesn't bother me if we provide an enumerable
implementation that follows Postgres semantics. As [~julianhyde] said, it would
be even better if this is somehow configurable. Have you looked what are the
semantics in other DBMS?
Apart from that maybe we want to introduce a new method in SqlConformance to
indicate if comparison operators are allowed between arrays.
> Support Array operator <, <=, >, >=
> -----------------------------------
>
> Key: CALCITE-3796
> URL: https://issues.apache.org/jira/browse/CALCITE-3796
> Project: Calcite
> Issue Type: Improvement
> Reporter: Rui Wang
> Assignee: Rui Wang
> Priority: Major
> Labels: pull-request-available
> Time Spent: 20m
> Remaining Estimate: 0h
>
> Seems like Calcite has an =, <> support for array type. But it does not have
> <, <=, >, >= support.
> Postgresql array operators:
> https://www.postgresql.org/docs/9.6/functions-array.html
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
