将逗号分隔列表传递给以VARIDIAC参数为输入的函数

Question

我有一个用户定义的函数，它将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.

谢谢

Answer 1

请参阅ARRAY_AGG聚合函数：

select func('abc', select array_agg(double_col) from something)

还有数组构造函数array[value，…]和(value，…(