index for inet(ip address or ip range)

From: Tony Liao <tonyliao(at)yuehetone(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: index for inet(ip address or ip range)
Date: 2009-02-26 10:33:37
Message-ID: 8f750b7c0902260233q639be440qafce23613d9d77db@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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?

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Nagalingam, Karthikeyan 2009-02-26 12:02:53 postgresql with storage
Previous Message Tony Liao 2009-02-26 09:37:38 Re: String concatenation work in version 8.2.11 and 8.3.6