[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    [postgis-users] Help in making Complex Query
From:       "S.Reena" <reena () indiamail ! com>
Date:       2008-08-29 10:21:53
Message-ID: 19217346.post () talk ! nabble ! com
[Download RAW message or body]


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@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
[prev in list] [next in list] [prev in thread] [next in thread]