Re: Syntax problem with INDEX on expression

[Mike Blackwell <mike.blackwell@xxxxxxx>]

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.Blackwell@xxxxxxx
http://www.rrdonnelley.com

On Fri, Apr 5, 2013 at 4:18 PM, Kevin Grittner <kgrittn@xxxxxxxxx> wrote:

Mike Blackwell <mike.blackwell@xxxxxxx> 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