[postgis-users] overlapping of two geometries with different coordinatsystem

[strk at refractions.net]

On Tue, Jun 21, 2005 at 03:49:02PM +0200, Achim Weßling wrote:
> Hallo,
> 
> I've a postgis-table with some attributes and geometry-column with the
> SRID 25832. Now I want to make a spatialquery in which I use another
> SRID like follows:
> 
> SELECT * FROM pktlage
> WHERE point_etrs89 && setSRID('BOX3D(3439540.0 5766038.0,3440650.83
> 5767171.05)'::box3d, 31467);
> 
> The result is empty, but I know for sure there have to be some hits.
> Isn't it possible to use two different SRID's in one query?

What do SRID(point_etrs89) and extent(point_etrs89) return ?
--strk;

> 
> -- 
> Mit freundlichem Gruß
> 
> Achim Weßling
> ===========================================
> INFOKOM Gütersloh AöR
> Fachbereich II - Technische Anwendungen
> Herzebrocker Str. 140
> 33334 Gütersloh
> Tel.: 05241/85-2926
> Achim.Wessling at gt-net.de
> http://www.infokom-gt.de
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users