[
https://issues.apache.org/jira/browse/CALCITE-5634?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17861082#comment-17861082
]
xiong duan commented on CALCITE-5634:
-------------------------------------
The PostgreSQL can support:
{code:java}
SELECT greatest(ARRAY [10000, 10000], ARRAY [500, 500], ARRAY [5000, 500],
ARRAY [10000, 20000],ARRAY [8000, 20000, 1000] ) AS x;
SELECT least(ARRAY [10000, 10000], ARRAY [500, 500], ARRAY [5000, 500], ARRAY
[10000, 20000]) AS x;{code}
[~njordan] We plan to implement this in this PR ？ If don't maybe we can create
another issue for this.
> Enable GREATEST, LEAST functions in PostgreSQL library
> ------------------------------------------------------
>
> Key: CALCITE-5634
> URL: https://issues.apache.org/jira/browse/CALCITE-5634
> Project: Calcite
> Issue Type: Bug
> Components: core
> Affects Versions: 1.34.0
> Reporter: Dmitry Sysolyatin
> Assignee: Norman Jordan
> Priority: Major
> Labels: pull-request-available
> Time Spent: 1h
> Remaining Estimate: 0h
>
> The LEAST and GREATEST functions have been implemented for BigQuery and
> Oracle, but haven't been added for PostgreSQL. PostgreSQL supports LEAST,
> GREATEST as well [1].
> Also PostgreSQL's LEAST, GREATEST functions behave differently with NULL
> values than ORACLE or BigQuery.
> From PostgreSQL documentation [1]:
> ??The result will be NULL only if all the expressions evaluate to NULL.??
> From BigQuery documentation [2]:
> ??They return NULL if any of the input parameters is NULL.??
> [1]
> [https://www.postgresql.org/docs/15/functions-conditional.html#FUNCTIONS-GREATEST-LEAST]
> [2]
> [https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions]
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
