[
https://issues.apache.org/jira/browse/CALCITE-3796?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17039411#comment-17039411
]
Julian Hyde commented on CALCITE-3796:
--------------------------------------
Review comments:
* Rather than {{lt}}, {{le}} etc. why not add a single function {{int
compare}}? {{a1 < a2}} would be implemented as {{compare(a1, a2) < 0}}.
* Please check that it works if there are null entries in the arrays.
* I don't know whether {{array [1, 2, 0, null] < array [1, 3, 0, 4]}} should
evaluate to {{TRUE}} or {{UNKNOWN}}. In particular, I don't know whether you
can quit comparing when you have seen {{2 < 3}}, or whether you have to carry
on to check for NULL values.
> 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: 40m
> 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)
