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

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' );
>