Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 4E729B5DBC1 for ; Fri, 19 Aug 2011 21:20:23 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 46661-06 for ; Sat, 20 Aug 2011 00:20:16 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail1.sea5.speakeasy.net (mail1.sea5.speakeasy.net [69.17.117.39]) by mail.postgresql.org (Postfix) with ESMTP id 7DA97B5D803 for ; Fri, 19 Aug 2011 21:20:15 -0300 (ADT) Received: (qmail 27072 invoked from network); 20 Aug 2011 00:20:14 -0000 Received: from 25-76-42-72.skybeam.com (HELO [192.168.2.16]) (sribe@elevated-dev.com@[72.42.76.25]) (envelope-sender ) by mail1.sea5.speakeasy.net (qmail-ldap-1.03) with AES128-SHA encrypted SMTP for ; 20 Aug 2011 00:20:14 -0000 Subject: Re: compare integer to inet Mime-Version: 1.0 (Apple Message framework v1084) Content-Type: text/plain; charset=us-ascii From: Scott Ribe In-Reply-To: <4E4EE29F.2070209@dhs-club.com> Date: Fri, 19 Aug 2011 18:20:13 -0600 Cc: pgsql-admin@postgresql.org Content-Transfer-Encoding: 7bit Message-Id: References: <4E4EE29F.2070209@dhs-club.com> To: Bill MacArthur X-Mailer: Apple Mail (2.1084) 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, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201108/188 X-Sequence-Number: 38175 On Aug 19, 2011, at 4:24 PM, Bill MacArthur wrote: > select case when '41.224.0.0'::inet = 702545920 then true else false end; If addition works, maybe subtraction works. So subtract 0? -- Scott Ribe scott_ribe@elevated-dev.com http://www.elevated-dev.com/ (303) 722-0567 voice