Can a delimiter be used with concat_agg?
The feature you’re thinking about is
string_agg(), a standard SQL aggregation function which does concatenation with a configurable delimiter.
Unfortunately currently CockroachDB cannot support aggregate functions with secondary arguments. That’s why we decided to introduce a non-standard function
concat_agg() which does not have a configurable delimiter, so that users can get half of the feature already.
We’ll add the fully-fledged
string_agg() when our aggregation engine is extended to support more arguments.
Just curious if there is a timeline for when your aggregation engine is extended, or a github issue I can follow?
Yes of course it’s here: https://github.com/cockroachdb/cockroach/issues/10495