[postgis-users] Help in making Complex Query

[Fred Lehodey]

Hi Reena,

SELECT t1.* FROM track_points1 as t1, track_points2 as t2
WHERE st_distance(t1.the_geom,t2.the_geom) <= a;

Is that help ?

Fred.


On 8/29/08, S.Reena <reena at indiamail.com> wrote:
>
>
> Hello,
>
> I have two tables track_points1 and track_points2 having wkb_geometry
> columns. I want to make a query that can do this:
>
> select * from track_points1 where wkb_geometry1 in ( select wkb_geometry2
> from track_points2 where wkb_geometry1= wkb_geometry2 (+/-) a );
>
> where a is any value (hexadecimal /integer)...
>
> [basically i want to select one geometry that is in some range of
> another....]
>
> Can any1 help?
>
> Cheers,
> Reena.
>
>
>
> --
> View this message in context:
> http://www.nabble.com/Help-in-making-Complex-Query-tp19217346p19217346.html
> Sent from the PostGIS - User mailing list archive at Nabble.com.
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20080902/074822bd/attachment.html>