> sp_dev=# create index test_idx on test ((xpath('//rms:xsid/text()',udh,array[array['rms','http://www.example.com']]))[1]::text); > ERROR: syntax error at or near "[" > LINE 1: ...udh,array[array['rms','http://www.example.com']]))[1]::text)... > ^ > It looks like it doesn't like the array subscript. What might I be missing?
You're missing a set of parentheses around the entire expression.
create index test_idx on test (((xpath('//rms:xsid/text()',udh,array[array['rms','http://www.example.com']]))[1]::text));