Mike Blackwell <mike.blackw...@rrd.com> 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)...
> ^
> 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));
--
Kevin Grittner
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
