The following bug has been logged online: Bug reference: 4294 Logged by: Enrico Sirola Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3 Operating system: OSX, Linux (RHEL5) Description: XML support: name() xpath function not working Details:
it seems the name() xpath function doesn't work properly. Try, for example, the following sql script: create table test (test xml); insert into test values ('<a xmlns="http://myns.com/ns"><b>text1</b><c>text2</c></a>'); -- good select xpath('/my:a/*[last()]', test, ARRAY[ARRAY['my', 'http://myns.com/ns']]) from test; -- bad select xpath('name(/my:a/*[last()])', test, ARRAY[ARRAY['my', 'http://myns.com/ns']]) from test; It seems the libxml2 version and the OS used is not relevant. The problem affects all pgsql versions >= 8.3.0 Best regards, Enrico -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs