[postgis-devel] [PostGIS] #1635: [raster] Operator does not exist: raster ~ geometry

PostGIS trac at osgeo.org
Thu Mar 1 01:29:13 PST 2012


#1635: [raster] Operator does not exist: raster ~ geometry
---------------------+------------------------------------------------------
 Reporter:  nicklas  |       Owner:  pracine      
     Type:  defect   |      Status:  new          
 Priority:  medium   |   Milestone:  PostGIS 2.1.0
Component:  raster   |     Version:  trunk        
 Keywords:           |  
---------------------+------------------------------------------------------

Comment(by pracine):

 All we need is a set of

 {{{
 CREATE OPERATOR ~ (
     LEFTARG = raster, RIGHTARG = geometry, PROCEDURE = raster_contain,
     COMMUTATOR = '@',
     RESTRICT = contsel, JOIN = contjoinsel
     );
 }}}

 and

 {{{
 CREATE OR REPLACE FUNCTION raster_contain(raster, geometry)
     RETURNS bool
     AS 'select $1::geometry ~ $2'
     LANGUAGE 'SQL' IMMUTABLE STRICT;
 }}}

 right?

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/1635#comment:18>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.


More information about the postgis-devel mailing list