Geographical indexing

[Thomas Flemming]

>> So I set up some tables with indexed fields:
>> obj_id, ext_north, ext_south, ext_east, ext_west
>>
>> So my select is for example:
>>
>> (select obj_id from tableidx_1 where not ((ext_north < 48903994) Or
>>                                            (ext_south > 49146819) or
>>                                            (ext_east  < 8998828)  or
>>                                            (ext_west  > 9366460)))
>> union
>> (select obj_id from tableidx_2 where not ((ext_north < 48903994) Or
>>                                            (ext_south > 49146819) or
>>                                            (ext_east  < 8998828)  or
>>                                            (ext_west  > 9366460)))
>> ...
> 
> What is type of ext_north, ext_south, ext_east, ext_west  numbers ?
>     short? Long?
> 
Its Long.

Tom



-- 
/****************************************
**   Dipl.-Ing. Thomas Flemming
**   Software Development
**
**   Touratech AG
**   Auf dem Zimmermann 7-9
**   D-78078 Niedereschach
**
**   mail  tf at ttqv.com
**   fon   +49 (0) 7728 9279-206
**   fax   +49 (0) 7728 9279-29
**
**   http://www.ttqv.com
**   http://www.touratech.de
**
**   ... und immer dem Pfeil nach!
***************************************/