Functions / Array Functions And Operators

array_to_string

Converts each array element to its text representation, and concatenates those separated by the delimiter string.

Reading PG 18current·documented in 24 of 27 versions, 7.4 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

array_to_string ( array anyarray, delimiter text [, null_string text ] ) → text

Converts each array element to its text representation, and concatenates those separated by the delimiter string. If null_string is given and is not NULL, then NULL array entries are represented by that string; otherwise, they are omitted. See also string_to_array.

array_to_string(ARRAY[1, 2, 3, NULL, 5], ',', '*') → 1,2,3,*,5

Version history 6

14 → 15 changed
12 → 13 changed
9.0 → 9.1 changed
8.3 → 8.4 changed
7.4 → 8.0 changed
7.3 → 7.4 added

Definition snapshot: b7bd9cda · English manual source