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 Ave | St Charles, IL 60174-3401 Office: 630.313.7818 mike.blackw...@rrd.com http://www.rrdonnelley.com <http://www.rrdonnelley.com/> * <mike.blackw...@rrd.com>* On Fri, Apr 5, 2013 at 4:18 PM, Kevin Grittner <kgri...@ymail.com> wrote: > 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 >
