Functions / Xml Functions

xmlagg

The function xmlagg is, unlike the other functions described here, an aggregate function.

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

xmlagg ( xml ) → xml

The function xmlagg is, unlike the other functions described here, an aggregate function. It concatenates the input values to the aggregate function call, much like xmlconcat does, except that concatenation occurs across rows rather than across expressions in a single row. See Section 9.21 for additional information about aggregate functions.

xmlagg ( xml ORDER BY input_sort_columns ) → xml

Concatenates the non-null XML input values (see Section 9.15.1.8).

Version history 7

18 → 19 changed
16 → 17 changed
12 → 13 changed
9.1 → 9.2 changed
8.4 → 9.0 changed
8.3 → 8.4 changed
8.2 → 8.3 added

Definition snapshot: b7bd9cda · English manual source