[postgis-devel] [PostGIS] #490: raster casts to geometry and box2d should be assignment not implicit?

PostGIS trac at osgeo.org
Mon Apr 5 05:28:11 PDT 2010


#490: raster casts to geometry and box2d should be assignment not implicit?
-----------------------+----------------------------------------------------
 Reporter:  robe       |       Owner:  pracine        
     Type:  defect     |      Status:  new            
 Priority:  low        |   Milestone:  WKTRaster 0.1.6
Component:  wktraster  |     Version:  trunk          
 Keywords:             |  
-----------------------+----------------------------------------------------
 It appears I can do this:


 {{{
 SELECT ST_SRID(rast) As srid, ST_AsText(ST_Union(rast)) AS wktrast
 FROM dummy_rast
 GROUP BY ST_SRID(rast);

 SELECT ST_SRID(rast) As srid, ST_Extent(rast) AS extrast
 FROM dummy_rast
 GROUP BY ST_SRID(rast);
 }}}

 Which at first glance I thought was cool, but then realized its probably
 not cool.
 I'm still thinking about why this is bad.  For geography we decided this
 was bad because geography aren't cartesian coords so the answer is
 technically wrong.  In case of raster its not quite so clear.  I guess I
 think all non-trivial implicit casts are bad, but that's the database
 purist in me talking.

 So consider this just a flagging of questionable behavior.  Not
 necessarily that I am disagreeing with it.

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/490>
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