Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id C73329F9DAD for ; Tue, 17 Oct 2006 16:38:44 -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 07609-10 for ; Tue, 17 Oct 2006 19:38:41 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from floppy.pyrenet.fr (floppy.pyrenet.fr [194.116.145.2]) by postgresql.org (Postfix) with ESMTP id 073A89F98FA for ; Tue, 17 Oct 2006 16:38:41 -0300 (ADT) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id 0713430E09; Tue, 17 Oct 2006 21:38:40 +0200 (MET DST) From: Christopher Browne X-Newsgroups: pgsql.performance Subject: Re: Optimization of this SQL sentence Date: Tue, 17 Oct 2006 15:23:28 -0400 Organization: cbbrowne Computing Inc Lines: 23 Message-ID: <874pu2agr3.fsf@wolfe.cbbrowne.com> 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> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Complaints-To: usenet@news.hub.org X-message-flag: Outlook is rather hackable, isn't it? X-Home-Page: http://www.cbbrowne.com/info/ X-Affero: http://svcs.affero.net/rm.php?r=cbbrowne User-Agent: Gnus/5.1007 (Gnus v5.10.7) XEmacs/21.4.19 (linux) Cancel-Lock: sha1:o+W8dQvaKitIMQAq3WSj58oj9/g= To: pgsql-performance@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.273 tagged_above=0 required=5 tests=INFO_TLD X-Spam-Level: * X-Archive-Number: 200610/331 X-Sequence-Number: 21460 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. -- (reverse (concatenate 'string "gro.mca" "@" "enworbbc")) http://linuxfinances.info/info/finances.html Rules of the Evil Overlord #159. "If I burst into rebel headquarters and find it deserted except for an odd, blinking device, I will not walk up and investigate; I'll run like hell."