Обсуждение: Get closest numbers between intervals

Hi,

   I have one table that has this structure:

city_code, start_ip, end_ip

I´m searching for the city that its between two ip´s. But, i would
like to get the nearest´s cities too.

Any ideas how can i search for the city proximity?

thanks!

xaviergxf <xaviergxf@gmail.com> writes:
> city_code, start_ip, end_ip
>
> I´m searching for the city that its between two ip´s. But, i would
> like to get the nearest´s cities too.

I'd have a look at ip4r rather than having both the start and end ip
there. The GiST index on ip4r allow for quick lookup:

  SELECT * FROM ... WHERE iprange >>= '1.2.3.4'::ip4;

  http://pgfoundry.org/projects/ip4r/

> Any ideas how can i search for the city proximity?

I'd have a look at earthdistance contrib, then maybe PostGIS:

  http://www.postgresql.org/docs/8.4/static/earthdistance.html

Regards,
--
dim