index for inet(ip address or ip range)

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: index for inet(ip address or ip range)
From: Tony Liao <tonyliao@xxxxxxxxxxxxx>
Date: Thu, 26 Feb 2009 18:33:37 +0800
Sender: pgsql-admin-owner@xxxxxxxxxxxxxx

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?

Follow-Ups:
- Re: index for inet(ip address or ip range)
  - From: Lee Azzarello

Prev by Date: Re: String concatenation work in version 8.2.11 and 8.3.6
Next by Date: postgresql with storage
Previous by thread: String concatenation work in version 8.2.11 and 8.3.6
Next by thread: Re: index for inet(ip address or ip range)
Index(es):
- Date
- Thread

[Index of Archives] [KVM ARM] [KVM ia64] [KVM ppc] [Virtualization Tools] [Spice Development] [Libvirt] [Libvirt Users] [Linux USB Devel] [Linux Audio Users] [Yosemite Questions] [Linux Kernel] [Linux SCSI] [XFree86]

Powered by Linux