[postgis-devel] ST_Equals, immutable strict

[Nicklas Avén]

2010-08-31 strk wrote:

On Tue, Aug 31, 2010 at 12:30:39PM +0200, Nicklas Avén wrote:
>> Hallo ST_Equals is marked as "immutable strict", other functions like ST_Intersects, ST_Within and so on is only marked "immutable" I guess that is why I have problems getting the index used for ST_Equals. Is there a reason for immutable strict on st_equals or is it a mistake? It is the same in trunk and 1.5.1 /Nicklas
>
>STRICT means that if any argument is NULL, then the result
>should also be NULL. Most likely ST_Intersects, ST_Within
>and others should be marked as strict too.
>
>--strk; 
> Ok, but that seems to stop the index from working in st_equals. If I remove strict the index works as expected, but with strict it doesn't use the index. /Nicklas
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20100831/6dfb3da1/attachment.html>