Get closest numbers between intervals - Mailing list pgsql-general

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!