Closed james-johnston-thumbtack closed 7 months ago
Thank you for your suggestion. The use case for this feature looks very reasonable, and we will prioritize it and implement it as soon as possible.
@TennyZhuang it is not urgent for me, as I did find a workaround. But will be nice if it exists in the future. :)
Is your feature request related to a problem? Please describe.
While looking for a workaround for https://github.com/risingwavelabs/risingwave/issues/14704 to parse ISO 8601 intervals, I thought to try regular expressions to parse an ISO 8601 string myself. This seemed easy enough, especially since my source (Debezium) always outputs the intervals in a very rigid format. A regexp that captures each ISO 8601 interval element, and then uses it in a format string:
PostgreSQL SQL
RisingWave SQL
It seems that RisingWave does not understand the VARIADIC keyword used by PostgreSQL for unpacking an array into function arguments, as described at https://www.postgresql.org/docs/16/xfunc-sql.html#XFUNC-SQL-VARIADIC-FUNCTIONS
It seems there was a special case recently added for some JSON functions at https://github.com/risingwavelabs/risingwave/issues/13016 but I think it was not generalized for any variadic function support?
Describe the solution you'd like
PostgreSQL-compatible support of the
VARIADIC
keyword when calling functions with variadic parameters.Describe alternatives you've considered
I can't think of a cleaner-looking alternative than what PostgreSQL is doing.
For my immediate problem, this, um... finally does the trick.... 😞
Additional context
No response