yiguolei commented on code in PR #2721: URL: https://github.com/apache/doris-website/pull/2721#discussion_r2293431560
########## i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/array-functions/array-product.md: ########## @@ -5,36 +5,133 @@ } --- +## array_product + +<version since="2.0.0"> + +</version> + ## 描述 -计算数组中所有元素的乘积 +计算数组中所有元素的乘积。函数会遍历数组中的所有元素，将它们相乘并返回结果。 ## 语法 ```sql -ARRAY_PRODUCT(<arr>) +array_product(ARRAY<T> arr) +``` + +### 参数 + +- `arr`：ARRAY<T> 类型，要计算乘积的数组 + +**T 支持的类型：** +- 数值类型：TINYINT、SMALLINT、INT、BIGINT、LARGEINT、FLOAT、DOUBLE、DECIMAL +- 布尔类型：BOOLEAN（true 转换为 1，false 转换为 0） + +### 返回值 + +返回类型：DOUBLE 或 DECIMAL Review Comment: int 相乘也是返回double？ 如果溢出了怎么办？ -- 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. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
