Re: issue with postgres/xml

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Cindy Moore <ctmoore(at)uci(dot)edu>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: issue with postgres/xml
Date: 2008-09-10 10:01:50
Message-ID: 48C79B0E.5060908@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Cindy Moore wrote:
> I looked through the lists and couldn't figure out where else to put
> this. I'm trying to create indices on xpath expressions for columns
> of type xml.
> I'm running postgres version 8.3.3, running on solaris.
>
> Text=# create index trclass on lsj_xml ((xpath
> ('//span[(at)class="tr"]/text()', entry)::text));
> ERROR: functions in index expression must be marked IMMUTABLE

xpath returns an array. I'm not sure offhand why the cast from array to
text is not immutable, but if you select an array element, it works:

create index trclass on lsj_xml (((xpath('//span[(at)class="tr"]/text()',
entry))[1]::text));

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Rudolf Leitgeb 2008-09-10 11:12:58 BUG #4414: PQescapeByteaInternal very slow/inefficient
Previous Message Tom Lane 2008-09-09 21:21:00 Re: BUG #4413: LEFT JOIN not working as expected