From: | Markus Schatten <markus(dot)schatten(at)foi(dot)hr> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: get attribute from XML |
Date: | 2010-10-12 00:22:05 |
Message-ID: | AANLkTincUH=RzEuvzQ5BxE=_oDgWkWX9Vh8aVsHLL7L9@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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(dot)bojovic(at)gmail(dot)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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas | 2010-10-12 04:09:07 | Is there a conditional string-concatenation ? |
Previous Message | Viktor Bojović | 2010-10-11 23:03:34 | get attribute from XML |