2011/9/22 Brian Sherwood <bds...@gmail.com> > > select (xpath('/chassis-inventory/chassis/serial-number/text()', > data_xml, > ARRAY[ARRAY['junos', > 'http://xml.juniper.net/junos/9.6R4/junos-chassis']] > )) from xml_test; > > Can anyone suggest how I would go about getting the serial-number with > xpath? > >
http://www.postgresql.org/docs/9.1/static/functions-xml.html#FUNCTIONS-XML-PROCESSING- see "mydefns". This will work: select xpath( '/junos:chassis-inventory/junos:chassis/junos:serial-number/text()', data_xml, ARRAY[ARRAY['junos', 'http://xml.juniper.net/junos/9.6R4/junos-chassis' ]] ) from xml_test; cheers, Filip