[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