Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group