If I have a XML like this <?xml version="1.0" encoding="UTF-8"?> <Errors> <Error code="CLIN102" validFrom="1980-02-23"/> <Error code="CLIN103" validFrom="1980-02-23" validTo="2012-01-01"/> </Errors>
can I write a query that will output the columns names and values like this? code;validFrom;validTo ------------------------------ CLIN102;1980-02-23; CLIN103;1980-02-23;2012-01-01 Thank you -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql