Skip site navigation (1) Skip section navigation (2)

Re: Re: plpgsql locate provider by zip code

From: Shay Moreno <moreno(at)tdk(dot)dk>
To: "'Joel Burton'" <jburton(at)scw(dot)org>, Phill Kenoyer <phill(at)kenoyer(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Re: plpgsql locate provider by zip code
Date: 2001-04-27 17:29:21
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
On Fri, 27 Apr 2001, Phill Kenoyer wrote:

> >    "zip" int8 NOT NULL,
>    then 00315. Using VARCHAR() also gives you some breathing room
>    if you add non-US postal codes, since practically every country
>    uses alphanumeric systems.

	I couldn't agree more.  It is very annoying not to be able to input
Brazilian zip codes in US systems.  Even if they accept letters, our system
is in the form 99.999-999 -- that's 10 characters, or 9 if you omit the dot,
but omiting the hyphen is so unusual it goes against the grain.  Even if we
use just the numbers it's still 8 numbers, and most US systems do not accept
more than six, which force us to use, not the first six numbers (that would
be a mistake and then the letter might take weeks more to arrive than usual)
but only the first five numbers - while it isn't a gross error it is still a
serious omission and will delay the correspondence for some days.

 / \  	 Leandro GuimarĂ£es Faria Corcete Dutra        +55 (11) 3040 8913
 \ /  	 Amdocs Brasil Ltda at Tele Danmark                +45 3387 5214
  X       mailto:leandrod(at)amdocs(dot)com
 / \     Campanha fita ASCII                        mailto:moreno(at)tdk(dot)dk

pgsql-novice by date

Next:From: Stephen M. FordDate: 2001-04-27 19:21:04
Subject: last install question (I hope)
Previous:From: Johan DaineDate: 2001-04-27 15:33:42
Subject: Re: RV: How to delete a table in Postgres ???

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group