Re: Optimization of this SQL sentence - Mailing list pgsql-performance

From Shane Ambler
Subject Re: Optimization of this SQL sentence
Date
Msg-id 453531CF.9060104@007Marketing.com
Whole thread Raw
In response to Re: Optimization of this SQL sentence  (Christopher Browne <cbbrowne@acm.org>)
List pgsql-performance
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

pgsql-performance by date:

Previous
From: Christopher Browne
Date:
Subject: Re: Optimization of this SQL sentence
Next
From: "Rohit_Behl"
Date:
Subject: Jdbc/postgres performance