Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 0CBD09F9DAD for ; Tue, 17 Oct 2006 16:41:13 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 89232-07 for ; Tue, 17 Oct 2006 16:41:10 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from smtp3.adl2.internode.on.net (smtp3.adl2.internode.on.net [203.16.214.203]) by postgresql.org (Postfix) with ESMTP id 820C89F98FA for ; Tue, 17 Oct 2006 16:41:09 -0300 (ADT) Received: from [192.168.8.200] (ppp247-71.static.internode.on.net [203.122.247.71]) by smtp3.adl2.internode.on.net (8.13.6/8.13.5) with ESMTP id k9HJf3Ef001012; Wed, 18 Oct 2006 05:11:04 +0930 (CST) (envelope-from pgsql@007Marketing.com) Message-ID: <453531CF.9060104@007Marketing.com> Date: Wed, 18 Oct 2006 05:11:03 +0930 From: Shane Ambler User-Agent: Thunderbird 1.5.0.7 (Macintosh/20060909) MIME-Version: 1.0 To: Christopher 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> <45352ABE.4010409@007Marketing.com> <874pu2agr3.fsf@wolfe.cbbrowne.com> In-Reply-To: <874pu2agr3.fsf@wolfe.cbbrowne.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=1.961 tagged_above=0 required=5 tests=AWL, BIZ_TLD, SPF_HELO_PASS X-Spam-Level: * X-Archive-Number: 200610/332 X-Sequence-Number: 21461 Christopher Browne wrote: > The world rejoiced as pgsql@007Marketing.com (Shane Ambler) wrote: >> 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 > > Heh. I'm not in the US, so that's not the sort of mistake I'd be > likely to make... > > The thing is, the only place where they call this sort of thing a "zip > code" is the US. Elsewhere, it's called a postal code. Same meaning/use different name (that's a locale issue for the client displaying the data) they will all use the same column for that data. -- Shane Ambler Postgres@007Marketing.com Get Sheeky @ http://Sheeky.Biz