So, one set to mark the parameter and one for the expression? It's
starting to look like Lisp. ^_^
Thanks!
__
*Mike Blackwell | Technical Analyst, Distribution Services/Rollout
Management | RR Donnelley*
1750 Wallace
Mike Blackwell wrote:
> 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)...
>
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
--
000125846
000125843
000125844
000125842
000125845
000125847
(10 rows)
