[EMAIL PROTECTED] wrote:
INTERSECT would give you x=5 AND y=7. For x=5 OR y=7 you want UNION.
Oops, yes of course.
I was thinking of the higher level problem with circles where
intersection could be used to find a small subset of the table that
would then be scanned to locate the points in the circle using the exact
distance calculation.
select * from ex4 where rowid in
(
select rowid from ex4 where x between :x_center - :radius and
:x_center + :radius
intersect
select rowid from ex4 where y between :y_center - :radius and
:y_center + :radius
)
This will find points in a circumscribed square around the center of the
circle. The distance calculation would eliminate those points outside
the circle (i.e. the points in the corners of the squares).
Dennis Cote
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------