You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@calcite.apache.org by "Norman Jordan (Jira)" <ji...@apache.org> on 2024/07/02 16:52:00 UTC

[jira] [Created] (CALCITE-6454) Implement array comparison operators

Norman Jordan created CALCITE-6454:
--------------------------------------

             Summary: Implement array comparison operators
                 Key: CALCITE-6454
                 URL: https://issues.apache.org/jira/browse/CALCITE-6454
             Project: Calcite
          Issue Type: Improvement
          Components: core
            Reporter: Norman Jordan


The comparison operators <, <=, >, >=, =, <> are not implemented for arrays. Here is an example query:

 
{code:java}
SELECT array[2, 2] > array[1, 1]; {code}
[This page|https://popsql.com/learn-sql/postgresql/how-to-compare-arrays-in-postgresql] describes how the comparisons  work in PostgreSQL.

 

Check if the comparison operators for arrays exist in other DB engines.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)