Ignore:
Timestamp:
Jun 25, 2010 12:43:42 AM (6 years ago)
Author:
robe
Message:

#536 get rid of strict on ST_Intersects, ST_CoveredBy and ST_Covers because spatial index doesn't work with strict on

File:
1 edited

Legend:

Unmodified
Added
Removed
  • branches/1.5/postgis/geography.sql.in.c

    r5065 r5704  
    678678        RETURNS boolean AS
    679679        $$ SELECT ST_Covers($1::geometry, $2::geometry);  $$
    680         LANGUAGE 'SQL' IMMUTABLE STRICT;
     680        LANGUAGE 'SQL' IMMUTABLE ;
    681681
    682682-- Only implemented for polygon-over-point
     
    685685        RETURNS boolean
    686686        AS 'SELECT $1 && $2 AND _ST_Covers($2, $1)'
    687         LANGUAGE 'SQL' IMMUTABLE STRICT;
     687        LANGUAGE 'SQL' IMMUTABLE ;
    688688
    689689-- Availability: 1.5.0 - this is just a hack to prevent unknown from causing ambiguous name because of geography
     
    692692        RETURNS boolean AS
    693693        $$ SELECT ST_CoveredBy($1::geometry, $2::geometry);  $$
    694         LANGUAGE 'SQL' IMMUTABLE STRICT;
     694        LANGUAGE 'SQL' IMMUTABLE ;
    695695
    696696-- Availability: 1.5.0
     
    698698        RETURNS boolean
    699699        AS 'SELECT $1 && $2 AND _ST_Distance($1, $2, 0.0, false) < 0.00001'
    700         LANGUAGE 'SQL' IMMUTABLE STRICT;
     700        LANGUAGE 'SQL' IMMUTABLE;
    701701
    702702-- Availability: 1.5.0 - this is just a hack to prevent unknown from causing ambiguous name because of geography
     
    705705        RETURNS boolean AS
    706706        $$ SELECT ST_Intersects($1::geometry, $2::geometry);  $$
    707         LANGUAGE 'SQL' IMMUTABLE STRICT;
     707        LANGUAGE 'SQL' IMMUTABLE ;
    708708
    709709-- Availability: 1.5.0
Note: See TracChangeset for help on using the changeset viewer.