Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 524A7632C27 for ; Thu, 26 Feb 2009 06:40:35 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 79640-03 for ; Thu, 26 Feb 2009 06:40:29 -0400 (AST) X-Greylist: delayed 00:06:49.912947 by SQLgrey-1.7.6 Received: from rv-out-0506.google.com (rv-out-0506.google.com [209.85.198.227]) by mail.postgresql.org (Postfix) with ESMTP id 8A859632231 for ; Thu, 26 Feb 2009 06:40:29 -0400 (AST) Received: by rv-out-0506.google.com with SMTP id f6so480829rvb.43 for ; Thu, 26 Feb 2009 02:40:28 -0800 (PST) MIME-Version: 1.0 Received: by 10.142.239.11 with SMTP id m11mr602645wfh.137.1235644417271; Thu, 26 Feb 2009 02:33:37 -0800 (PST) Date: Thu, 26 Feb 2009 18:33:37 +0800 Message-ID: <8f750b7c0902260233q639be440qafce23613d9d77db@mail.gmail.com> Subject: index for inet(ip address or ip range) From: Tony Liao To: pgsql-admin@postgresql.org Content-Type: multipart/alternative; boundary=000e0cd144948f678b0463cfe21b X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200902/232 X-Sequence-Number: 31453 --000e0cd144948f678b0463cfe21b Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit 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? --000e0cd144948f678b0463cfe21b Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable hello,everybody
=A0=A0=A0=A0=A0=A0=A0=A0=A0 I want to create index for c= olumn ip1 and ip2.I know there is a contrib name ip4r.but the column ip1(ip= 2) would be a ip address or ip range.
=A0=A0=A0=A0=A0=A0=A0=A0=A0 The qu= ery would do select ....... where ip1>>=3D'96.168.65.84' or i= p2>>=3D'96.168.65.84'.
=A0=A0=A0=A0=A0=A0=A0=A0=A0 does anyone have ideas?
--000e0cd144948f678b0463cfe21b--