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?
pgsql-sql by date:
Соглашаюсь с условиями обработки персональных данных