[postgis-users] buggy operator && ?

Paul Ramsey pramsey at refractions.net
Fri Nov 22 09:05:34 PST 2002


Did you include Proj4 support when you compiled PostGIS? If not, then 
transform is just an identity operator. (Dave, could we raise an error 
instead?)

P.

strk wrote:
> 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
> 
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users


-- 
       __
      /
      | Paul Ramsey
      | Refractions Research
      | Email: pramsey at refractions.net
      | Phone: (250) 885-0632
      \_




More information about the postgis-users mailing list