Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: brain teaser
rj wrote:
> what if you just use a whole lot of 'between' statements?
> eg
> select city from locations
> where lat between 23.***** and 21.*******
> and lon between 22.***** and 43.******
> etc etc
Doesn't work for non-rectangular coordinates.
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Tue Jun 26 2007 - 10:15:46 CDT