The function xmlagg is, unlike the other functions described here, an aggregate function.
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 4