I have seen some interesting implementation using vertical tables.
http://weblogs.foxite.com/andykramek/archive/2009/05/03/8369.aspx
Paula Price
> -----Original Message-----
> From: pgsql-novice-owner@postgresql.org [mailto:pgsql-novice-
> owner@postgresql.org] On Behalf Of Daniel Staal
> Sent: Wednesday, July 06, 2011 2:14 PM
> To: pgsql-novice@postgresql.org
> Subject: [NOVICE] Best Practice for Address storage.
>
>
> I'm working on a new system that will (hopefully) need to store
> addresses
> for people from anywhere in the world. The system's still in the
> design
> stage, and I was wondering if anyone had ideas for a best-practice on
> how
> to store those addresses.
>
> Daniel T. Staal
>
> ---------------------------------------------------------------
> This email copyright the author. Unless otherwise noted, you
> are expressly allowed to retransmit, quote, or otherwise use
> the contents for non-commercial purposes. This copyright will
> expire 5 years after the author's death, or in 30 years,
> whichever is longer, unless such a period is in excess of
> local copyright law.
> ---------------------------------------------------------------
>
>
> --
> Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-novice