Get closest numbers between intervals

From: xaviergxf <xaviergxf(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Get closest numbers between intervals
Date: 2009-09-01 16:16:25
Message-ID: 089cefd7-8803-45ec-994e-525f399cd07d@q35g2000vbi.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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!

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Broersma 2009-09-01 19:20:30 Any former bugs that loose duplicates after a sort
Previous Message Josef Wolf 2009-09-01 14:47:25 Re: pg_ctl with unix domain socket?