Postgres Pro
Downloads
Home   >   mailing lists

Syntax problem with INDEX on expression - Mailing list pgsql-general

From Mike Blackwell
Subject Syntax problem with INDEX on expression
Date
Msg-id CANPAkguZ2MTqTNhkVwOrkdTxvdCsiY-1wmQkut__OfKS-2qJvw@mail.gmail.com
Whole thread Raw
Responses Re: Syntax problem with INDEX on expression
List pgsql-general
Tree view
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 "["
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?

__________________________________________________________________________________
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


pgsql-general by date:

Previous
From: Kevin Grittner
Date:
Subject: Re: BEFORE UPDATE trigger doesn't change column value
Next
From: Kevin Grittner
Date:
Subject: Re: Syntax problem with INDEX on expression