Can a delimiter be used with concat_agg?
From the docs, it doesn’t look like it can.
@knz may have more details in case I’m missing something.
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?