[postgis-users] buggy operator && ?

strk strk at freek.keybit.net
Fri Nov 22 09:05:44 PST 2002


More over: does the transform() function work at all in version 0.7.3 ??
No matter what srid I give it, the resulting geometry is exactly the same
as the original one :?


strk wrote:
> I need to select geometries overlapping a BOX3D.
> I don't want to know the SRID of the source geometries,
> I DO KNOW the SRID of my selection BOX3D.
> 
> The following selects, though, gives me an error:
> 
> SELECT * FROM table
> WHERE
> 	transform("the_geom", 32631) &&
> 	setSRID('BOX3D(0 0 0, 10 10 0)'::BOX3D, 32631);
> 
> The error is:
> ERROR:  Operation on two GEOMETRIES with different SRIDs
> 
> Now, doesn't transform() return a geometry with the specified SRID ?
> and what about setSRID ?
> If both these sentences are true, the error is not justified !
> 
> Note that using
> GeometryFromText('BOX3D(0 0 0, 10 10 0)', 32631)
> gives the same result.
> 
> Any help with this ?
> I'm using postgis 0.7.3
> 
> --strk;
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users



More information about the postgis-users mailing list