Postgres Pro
Downloads
Home   >   mailing lists

index for inet(ip address or ip range) - Mailing list pgsql-admin

From Tony Liao
Subject index for inet(ip address or ip range)
Date
Msg-id 8f750b7c0902260233q639be440qafce23613d9d77db@mail.gmail.com
Whole thread Raw
Responses Re: index for inet(ip address or ip range)  (Lee Azzarello <lee@dropio.com>)
List pgsql-admin
Tree view
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?

pgsql-admin by date:

Previous
From: Tony Liao
Date:
Subject: Re: String concatenation work in version 8.2.11 and 8.3.6
Next
From: "Nagalingam, Karthikeyan"
Date:
Subject: postgresql with storage