我有一个用户定义的函数,它接受VARIADIC参数作为输入:
func(name string, VARIADIC values double) returns Blob
Example: select func('abc', 35.2,35.3,35.5)如何在TEIID中将基于行的浮点数/双精度值传递给逗号分隔的双精度类型
From:
35.2
35.3
35.5
To:
35.2,35.3,35.5
as a single double/float comma separated variable.谢谢
发布于 2020-12-05 05:36:34
请参阅ARRAY_AGG聚合函数:
select func('abc', select array_agg(double_col) from something)还有数组构造函数ARRAYvalue,...and (值,...)
https://stackoverflow.com/questions/65149839
复制相似问题