Hi, Gregory,
"Gregory Williamson" <[EMAIL PROTECTED]> wrote:
> ST_ functions are modern variants of older functions -- they include the
> bounding box check that eliminates most unwanted candidates from a search.
>
> So try something like:
>
> SELECT * FROM asdfs_track_point where the_geom && 'BOX3D(? ?, ? ?)'::box3d
> AND
> within(the_geom,GeometryFromText('POLYGON((-180.0 -90.0,-180.0
> 90.0,180.0 90.0,180.0 -90.0,-180.0 -90.0))',4326));
You can simply use the geometry there directly:
SELECT * FROM asdfs_track_point where the_geom &&
GeometryFromText('POLYGON((-180.0 -90.0,-180.0 90.0,180.0 90.0,180.0
-90.0,-180.0 -90.0))',4326) AND
within(the_geom,GeometryFromText('POLYGON((-180.0 -90.0,-180.0
90.0,180.0 90.0,180.0 -90.0,-180.0 -90.0))',4326));
Regards,
Markus
--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf. | Software Development GIS
Fight against software patents in Europe! www.ffii.org
www.nosoftwarepatents.org
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
