[
https://issues.apache.org/jira/browse/CALCITE-5634?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17710239#comment-17710239
]
Julian Hyde commented on CALCITE-5634:
--------------------------------------
Please update the description to match the discussion in the PR.
Please change the summary to "Enable GREATEST, LEAST functions in Postgres
library".
BigQuery, Postgres, Oracle and MySQL agree on one thing: any number of
arguments greater than 1 is allowed. So please update the javadoc for GREATEST
and LEAST.
Postgres GREATEST and LEAST ignore NULL arguments (returning NULL only if all
arguments are NULL,).
Please also enable for MySQL. MySQL seems to be identical to Oracle and
BigQuery (NULL if any argument is NULL).
> Add LEAST, GREATEST for PostgreSQL
> ----------------------------------
>
> 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: Dmitry Sysolyatin
> Priority: Major
> Labels: pull-request-available
> Time Spent: 50m
> 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]
> [1]
> https://www.postgresql.org/docs/15/functions-conditional.html#FUNCTIONS-GREATEST-LEAST
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
