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

From Oliver Vecernik
Subject Re: standard schemas for addresses, others?
Date
Msg-id 3E30A42E.4020209@aon.at
Whole thread Raw
In response to standard schemas for addresses, others?  (Dennis Gearon <gearond@cvc.net>)
List pgsql-general
Dennis Gearon schrieb:


>> Are there any sites with 'standard schemas' for certain, repetitive
>> database needs? For
>> example, addresses and their components. Does anyone have a schema for
>> addresses that will
>> work for the USA *AND* internation addresses?
>
>


There is a great source of information on:

http://www.upu.int/post_code/en/addressing_formats_guide.shtml

But it also shows how difficult the actual situation is. Even if you're
sending to the same addressee the format is depending on the origin from
where it is sent. Refer to:

http://www.upu.int/post_code/en/formatting_international_address_en.pdf

If you're interested I can post the structure of Mozilla address book.
It seems to be sufficent for my needs.

HTH
Oliver

--
VECERNIK Datenerfassungssysteme
A-2560 Hernstein, Hofkogelgasse 17
Tel.: +43 2633 47530, Fax: DW 50
http://members.aon.at/vecernik



pgsql-general by date:

Previous
From: "Magnus Naeslund(f)"
Date:
Subject: Re: Inherited tables and NOT NULL (pg 7.2.1)
Next
From: "CN LIOU"
Date:
Subject: Re: Stable function Repeatedly Called