Re: standard schemas for addresses, others? - Mailing list pgsql-general

From will trillich
Subject Re: standard schemas for addresses, others?
Date
Msg-id 20030123205213.GB3251@mail.serensoft.com
Whole thread Raw
In response to Re: standard schemas for addresses, others?  (Dennis Gearon <gearond@cvc.net>)
List pgsql-general
On Thu, Jan 23, 2003 at 10:56:27AM -0800, Dennis Gearon wrote:
> Now THAT's a good idea, store a regex pattern for each country's zip code!

> 1/23/2003 10:01:19 AM, will trillich <will@serensoft.com> wrote:
> >    insert into nations ( abbr,name,zips )
> >        values ( 'USA','United States of America','\\d\\d\\d\\d\\d(-\\d\\d\\d\\d)?' );
> >    insert into nations ( by,abbr,name,zips )
> >        values ( 'CANADA','Canada',               '[A-Z]\\d[A-Z]\\s+\\d[A-Z]\\d' );

i only bother taking credit for ideas which don't seem obvious
to me. this one sure did.

i'll make an exception in this case. glad to have contributed!

:)

--
There are 10 kinds of people:
ones that get binary, and ones that don't.

will@serensoft.com
http://sourceforge.net/projects/newbiedoc -- we need your brain!
http://www.dontUthink.com/ -- your brain needs us!

Looking for a firewall? Do you think smoothwall sucks? You're
probably right... Try the folks at http://clarkconnect.org/ !

pgsql-general by date:

Previous
From: "codeWarrior"
Date:
Subject: Re: DBD::Pg & DBD::PgPP Cpan question
Next
From: Stephan Szabo
Date:
Subject: Re: Problem with plpgsql TRIGGER