Dear Markus, it works now. Thanx. On Tue, Oct 12, 2010 at 2:22 AM, Markus Schatten <markus.schat...@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.bojo...@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