Home > mailing lists

get attribute from XML - Mailing list pgsql-sql

From	Viktor Bojović
Subject	get attribute from XML
Date	October 11, 2010 23:03:42
Msg-id	AANLkTinAMcqZdCE0jvhekcH0oBMkiu-Qb4v8KJkQy5ox@mail.gmail.com Whole thread Raw
Responses	Re: get attribute from XML (Markus Schatten <markus.schatten@foi.hr>)
List	pgsql-sql

Hi,

while parsing this type of XML:

i tried this query to get the modified attribute

select xpath('//entry/modified/text()',xml) from xml_sprot limit 10;

but it doesn't work.

So im asking if anyone can help me with that.

Thanx in advance
--
---------------------------------------
Viktor Bojović
---------------------------------------
Wherever I go, Murphy goes with me

From: James Cloos
Date: 09 October 2010, 07:52:07
Subject: Re: counting related rows

From: Markus Schatten
Date: 12 October 2010, 00:22:17
Subject: Re: get attribute from XML