Here is a partial solution to the problem I encountered (the full solution
uses a UNION ALL and the same statement four times):
SELECT
xmlelement( name "bakeware",
xmlconcat(
array_to_string( array_agg(
xmlelement( name "object",
xmlattributes( e.abridge AS "alias" ),
Hi,
Data in a table called 'equipment_group' (eg) contains various equipment
categories:
bakeware
cookware
kitchenware
utensils
I would like to use these values as elements within an XML document.
Something like:
xmlelement( name eg.label )
Each of these data element can have multiple objects
