Functions / String Functions And Operators

concat_ws

Concatenates all but the first argument, with separators.

Reading PG 18current·documented in 17 of 27 versions, 9.1 to 20

7.1 7.2 7.3 7.4 8.0 8.1 8.2 8.3 8.4 9.0 9.1 9.2 9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19 20

Signatures & examples

concat_ws ( sep text, val1 "any" [, val2 "any" [, ...] ] ) → text

Concatenates all but the first argument, with separators. The first argument is used as the separator string, and should not be NULL. Other NULL arguments are ignored.

concat_ws(',', 'abcde', 2, NULL, 22) → abcde,2,22

Version history 3

12 → 13 changed
9.2 → 9.3 changed
9.0 → 9.1 added

Definition snapshot: 2026-09-14T13:14:25.684213+00:00@99e6866c · English manual source