subject:"\[SQL\] Selecting data from XML"

Re: [SQL] Selecting data from XML

2012-07-16 Thread Craig Ringer

On 07/17/2012 03:56 AM, Victor Sterpu wrote: If I have a XML like this 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 http://www.postgresql.org/docs/9.1/s

[SQL] Selecting data from XML

2012-07-16 Thread Victor Sterpu

If I have a XML like this 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 ch