On Thu, Feb 26, 2009 at 5:33 AM, Tony Liao <tonyliao(at)yuehetone(dot)com> wrote:
> hello,everybody
> I want to create index for column ip1 and ip2.I know there is a
> contrib name ip4r.but the column ip1(ip2) would be a ip address or ip range.
> The query would do select ....... where ip1>>='96.168.65.84' or
> ip2>>='96.168.65.84'.
> does anyone have ideas?
The ipv4 type can accept CIDR blocks. Would that work for you?
-lee