The following expression works fine in a query:
sp_dev=# select (xpath('//rms:xsid/text()',udh,array[array['rms','http://www.example.com']]))[1]::text from test; xpath
----------------------
0000000125846
0000000125843
0000000125844
0000000125842
0000000125845
0000000125847
(10 rows)
However, when the same expression doesn't seem to work for creating an index:
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 "["
It looks like it doesn't like the array subscript. What might I be missing?
__________________________________________________________________________________
Mike Blackwell | Technical Analyst, Distribution Services/Rollout Management | RR Donnelley
1750 Wallace Ave | St Charles, IL 60174-3401
Office: 630.313.7818
Mike.Blackwell@rrd.com
http://www.rrdonnelley.com