Selecting data from XML

From: Victor Sterpu <victor(at)caido(dot)ro>
To: pgsql-sql(at)postgresql(dot)org
Subject: Selecting data from XML
Date: 2012-07-16 19:56:27
Message-ID: a1dc56fc-9159-4f31-9c94-9c363757f031@caido
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Craig Ringer 2012-07-17 03:23:45 Re: Selecting data from XML
Previous Message Jasen Betts 2012-07-14 03:22:07 Re: Simple Upgrade from PostgreSQL version 8.1.11 (With schemas)