Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 41479B5DC54 for ; Sun, 21 Aug 2011 16:43:03 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 40270-01-7 for ; Sun, 21 Aug 2011 19:42:55 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from acidenitrix.villemain.org (acidenitrix.villemain.org [91.121.90.165]) by mail.postgresql.org (Postfix) with ESMTP id A7746B5DF8F for ; Sun, 21 Aug 2011 16:35:06 -0300 (ADT) Received: from [89.157.192.174] (helo=DimIMac.local) by acidenitrix.villemain.org with esmtpsa (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:32) (Exim 4.69) (envelope-from ) id 1QvDnV-00062X-If; Sun, 21 Aug 2011 21:35:05 +0200 Received: by DimIMac.local (Postfix, from userid 501) id 25E03271B9DA; Sun, 21 Aug 2011 21:34:58 +0200 (CEST) From: Dimitri Fontaine To: Bill MacArthur Cc: pgsql-admin@postgresql.org Subject: Re: compare integer to inet Organization: 2ndQuadrant References: <4E4EE29F.2070209@dhs-club.com> User-Mail-Address: dimitri@2ndQuadrant.fr Date: Sun, 21 Aug 2011 21:34:58 +0200 In-Reply-To: <4E4EE29F.2070209@dhs-club.com> (Bill MacArthur's message of "Fri, 19 Aug 2011 18:24:31 -0400") Message-ID: User-Agent: Gnus/5.110018 (No Gnus v0.18) Emacs/24.0.50 (darwin) MIME-Version: 1.0 Content-Type: text/plain X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201108/190 X-Sequence-Number: 38177 Bill MacArthur writes: > The reason I ask for this is that we have a dataset that contains > ranges of IP addresses, associated with countries, where the addresses > are represented as integers (bigints). I would then use the ip4r extension, which is very very good for that kind of things. http://pgfoundry.org/projects/ip4r/ Regards, -- Dimitri Fontaine http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support