Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id E5D219FB208 for ; Tue, 17 Oct 2006 16:11:18 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 04350-06 for ; Tue, 17 Oct 2006 19:11:13 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from ipmail02.adl2.internode.on.net (ipmail02.adl2.internode.on.net [203.16.214.141]) by postgresql.org (Postfix) with ESMTP id 1D5419FA5C8 for ; Tue, 17 Oct 2006 16:11:12 -0300 (ADT) Received: from ppp247-71.static.internode.on.net (HELO [192.168.8.200]) ([203.122.247.71]) by ipmail02.adl2.internode.on.net with ESMTP; 18 Oct 2006 04:41:10 +0930 X-IronPort-Anti-Spam-Filtered: true X-IronPort-Anti-Spam-Result: AQAAAAHGNEUNHA X-IronPort-AV: i="4.09,321,1157293800"; d="scan'208"; a="30653737:sNHT19600168" Message-ID: <45352ABE.4010409@007Marketing.com> Date: Wed, 18 Oct 2006 04:40:54 +0930 From: Shane Ambler User-Agent: Thunderbird 1.5.0.7 (Macintosh/20060909) MIME-Version: 1.0 To: Chris Browne CC: pgsql-performance@postgresql.org Subject: Re: Optimization of this SQL sentence References: <45349CDF.3090002@rentalia.com> <4534A35E.9030909@rentalia.com> <181E6D21-8326-4ED6-A9AE-6F9917C1C319@purefiction.net> <200610171729.19596.mweilguni@sime.com> <601wp695ts.fsf@dba2.int.libertyrms.com> In-Reply-To: <601wp695ts.fsf@dba2.int.libertyrms.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=2.012 tagged_above=0 required=5 tests=BIZ_TLD, SPF_HELO_PASS X-Spam-Level: ** X-Archive-Number: 200610/330 X-Sequence-Number: 21459 Chris Browne wrote: > In the case of a zip code? Sure. US zip codes are integer values > either 5 or 9 characters long. So your app will only work in the US? And only for US companies that only have US clients? Sorry had to dig at that ;-P -- Shane Ambler Postgres@007Marketing.com Get Sheeky @ http://Sheeky.Biz