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
Attachments
For Gerrit Dashboard: MB-31737 | ||||||
---|---|---|---|---|---|---|
# | Subject | Branch | Project | Status | CR | V |
103215,3 | MB-31737, MB-27281. Add CONCAT2(separator, arg1, arg2,...) - concat strings into single string with separator | master | query | Status: MERGED | +2 | +1 |