pg.ddx.io pgsql-performance@postgresql.org mailing list archivehelp / color / mirror / Atom feed
From: Shane Ambler <pgsql@007Marketing.com>
To: Christopher Browne <cbbrowne@acm.org>
Cc: pgsql-performance@postgresql.org
Subject: Re: Optimization of this SQL sentence
Date: Wed, 18 Oct 2006 05:11:03 +0930
Message-ID: <453531CF.9060104@007Marketing.com> (raw)
In-Reply-To: <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>
<EFB9AB5E-C089-4314-BD32-BCEDDFD3EA02@purefiction.net>
<601wp695ts.fsf@dba2.int.libertyrms.com>
<45352ABE.4010409@007Marketing.com>
<874pu2agr3.fsf@wolfe.cbbrowne.com>
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
view thread (24+ messages) latest in thread
Message-ID: <453531CF.9060104@007Marketing.com> Permalink: ../453531CF.9060104@007Marketing.com/ Also on: postgresql.org/message-id/453531CF.9060104@007Marketing.com ·
reply
Reply instructions: You may reply publicly to this message via plain-text email using any one of the following methods: * Reply to all the recipients using the --to and --cc options: reply via email To: pgsql-performance@postgresql.org Cc: pgsql@007Marketing.com, cbbrowne@acm.org Subject: Re: Optimization of this SQL sentence In-Reply-To: <453531CF.9060104@007Marketing.com> * Save the following mbox file, import it into your mail client, and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox