Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125])
	by mail.postgresql.org (Postfix) with ESMTP id 0645655C5A5
	for <pgsql-sql@postgresql.org>; Mon, 16 Jul 2012 16:43:39 -0300 (ADT)
Received: from ppp248107867.ambra.ro ([86.107.248.7] helo=caido.ro)
	by makus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <victor@caido.ro>) id 1SqrCk-0007Kv-5G
	for pgsql-sql@postgresql.org; Mon, 16 Jul 2012 19:43:39 +0000
Received: from localhost (localhost [127.0.0.1])
	by caido.ro (Postfix) with ESMTP id C719414280B
	for <pgsql-sql@postgresql.org>; Mon, 16 Jul 2012 22:56:32 +0300 (EEST)
X-Virus-Scanned: amavisd-new at caido.ro
Received: from caido.ro ([127.0.0.1])
	by localhost (caido.ro [127.0.0.1]) (amavisd-new, port 10024)
	with ESMTP id xhW6axsr4Pn2 for <pgsql-sql@postgresql.org>;
	Mon, 16 Jul 2012 22:56:29 +0300 (EEST)
Received: from caido.ro (caido.ro [127.0.1.1])
	by caido.ro (Postfix) with ESMTP id 35BD11427EA
	for <pgsql-sql@postgresql.org>; Mon, 16 Jul 2012 22:56:28 +0300 (EEST)
Date: Mon, 16 Jul 2012 15:56:27 -0400 (EDT)
From: Victor Sterpu <victor@caido.ro>
To: pgsql-sql@postgresql.org
Subject: Selecting data from XML
Message-ID: <a1dc56fc-9159-4f31-9c94-9c363757f031@caido>
In-Reply-To: <0ec35c82-c931-4cb5-b9d0-d4fc49a0ef1f@caido>
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
MIME-Version: 1.0
X-Originating-IP: [89.43.152.14]
X-Mailer: Zimbra 7.1.3_GA_3346 (ZimbraWebClient - FF3.0 (Win)/7.1.3_GA_3346)
X-Pg-Spam-Score: 2.1 (++)
X-Archive-Number: 201207/16
X-Sequence-Number: 36753

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