[GitHub] [calcite] jinxing64 commented on a change in pull request #1755: CALCITE-3731 : Add IF function for BigQuery, Hive and Spark Dialects

[GitBox <gi...@apache.org>]

jinxing64 commented on a change in pull request #1755: CALCITE-3731 : Add IF function for BigQuery, Hive and Spark Dialects
URL: https://github.com/apache/calcite/pull/1755#discussion_r365844024
 
 

 ##########
 File path: site/_docs/reference.md
 ##########
 @@ -2331,6 +2334,7 @@ semantics.
 | o p | TO_TIMESTAMP(string, format)                 | Converts *string* to a timestamp using the format *format*
 | o p | TRANSLATE(expr, fromString, toString)        | Returns *expr* with all occurrences of each character in *fromString* replaced by its corresponding character in *toString*. Characters in *expr* that are not in *fromString* are not replaced
 | o | XMLTRANSFORM(xml, xslt)                        | Returns a string after applying xslt to supplied xml.
+| b h s | IF(boolean, object, object)                  | Return one value if a logical expression is 'TRUE' and another if it is a 'FALSE'
 
 Review comment:
   It's also supported in mysql.

----------------------------------------------------------------
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