Geographical indexing

[Ruslan Zasukhin]

On 4/19/09 11:14 AM, "Thomas Flemming" <tf at ttqv.com> wrote:

> 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?

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]