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

Posted to commits@calcite.apache.org by GitBox <gi...@apache.org> on 2019/12/31 07:09:23 UTC

[GitHub] [calcite] jinxing64 commented on a change in pull request #1694: [CALCITE-2935] Add support BOOL_AND/BOOL_OR Aggregate Function

jinxing64 commented on a change in pull request #1694: [CALCITE-2935] Add support BOOL_AND/BOOL_OR Aggregate Function
URL: https://github.com/apache/calcite/pull/1694#discussion_r362158878
 
 

 ##########
 File path: site/_docs/reference.md
 ##########
 @@ -1751,6 +1751,8 @@ and `LISTAGG`).
 | SUM( [ ALL &#124; DISTINCT ] numeric)         | Returns the sum of *numeric* across all input values
 | MAX( [ ALL &#124; DISTINCT ] value)           | Returns the maximum value of *value* across all input values
 | MIN( [ ALL &#124; DISTINCT ] value)           | Returns the minimum value of *value* across all input values
+| BOOL_AND( [ ALL &#124; DISTINCT ] value)      | Returns true if all *values* are true
+| BOOL_OR( [ ALL &#124; DISTINCT ] value)       | Returns true if at least one value of *value* is true
 | ANY_VALUE( [ ALL &#124; DISTINCT ] value)     | Returns one of the values of *value* across all input values; this is NOT specified in the SQL standard
 
 Review comment:
   Shall we use the word of value consistent with `MAX` & `MIN` ? -- it's a param of the function.

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


With regards,
Apache Git Services