Details
-
Improvement
-
Resolution: Fixed
-
Major
-
6.5.0
Description
Given ARRAY of strings concat into single string with separator
CONCAT_XXXX (["abcd", "pqr","xyz"], "-");
"abcd-pqr-xyz"
Alternative is
SELECT REPLACE(TRIM(ENCODE_JSON(["abc","def","xyz"]), "[]\""), "\",\"", "-");
https://forums.couchbase.com/t/array-concatenate-in-n1ql/18874