Обсуждение: get attribute from XML

Поиск
Список
Период
Сортировка

get attribute from XML

От
Viktor Bojović
Дата:
Hi,
while parsing this type of XML:
<entry version="21" modified="2009-07-07" dataset="S" created="2009-06-16">
<accession>Q91G55</accession>

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

Re: get attribute from XML

От
Markus Schatten
Дата:
Dear Viktor,

'modified' is an attribute node, so you need to use the @ sign to
acquire its value:

mschatte=# select xpath( '//entry/@modified', '<entry version="21"
modified="2009-07-07" dataset="S" created="2009-06-16" />' );   xpath
--------------{2009-07-07}
(1 row)

HTH

M.S.

On Tue, Oct 12, 2010 at 1:03 AM, Viktor Bojović
<viktor.bojovic@gmail.com> wrote:
> Hi,
> while parsing this type of XML:
> <entry version="21" modified="2009-07-07" dataset="S" created="2009-06-16">
> <accession>Q91G55</accession>
>
> 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
>

Re: get attribute from XML

От
Viktor Bojović
Дата:
Dear Markus,
it works now. Thanx.

On Tue, Oct 12, 2010 at 2:22 AM, Markus Schatten <markus.schatten@foi.hr> wrote:
Dear Viktor,

'modified' is an attribute node, so you need to use the @ sign to
acquire its value:

mschatte=# select xpath( '//entry/@modified', '<entry version="21"
modified="2009-07-07" dataset="S" created="2009-06-16" />' );
   xpath
--------------
 {2009-07-07}
(1 row)

HTH

M.S.

On Tue, Oct 12, 2010 at 1:03 AM, Viktor Bojović
<viktor.bojovic@gmail.com> wrote:
> Hi,
> while parsing this type of XML:
> <entry version="21" modified="2009-07-07" dataset="S" created="2009-06-16">
> <accession>Q91G55</accession>
>
> 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
>

--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql



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