Re: Best Practice for Address storage. - Mailing list pgsql-novice

From Daniel Staal
Subject Re: Best Practice for Address storage.
Date
Msg-id 417A3DAAE06A4CCB181BCB2B@mac-pro.magehandbook.com
Whole thread Raw
In response to Re: Best Practice for Address storage.  (Paula Price <paula.price@issinc.com>)
List pgsql-novice
--As of July 6, 2011 1:25:12 PM -0700, Paula Price is alleged to have said:

> I have seen some interesting implementation using vertical tables.
> http://weblogs.foxite.com/andykramek/archive/2009/05/03/8369.aspx

--As for the rest, it is mine.

Just wanted to say thanks.  It took some thinking on how that would work
with the rest of the system, but it looks like it should work very well.
It'll be a bit harder to search, (and a good bit less standardized), but it
should allow just about any address to work.

For reference, my current thought is to have a two-dimensional array in one
field of the 'users' table, which will hold the address.  One field of the
array will hold a tag, the other a the entry.  So a US address would end up
looking like this:

{{'street','1 Test Drive'},{'street','Apt.
2'}{'city','Springfield'},{'state','TI'},{'zip','99999'}}

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.
---------------------------------------------------------------

pgsql-novice by date:

Previous
From: James David Smith
Date:
Subject: Beginner Question...
Next
From: Michael Wood
Date:
Subject: Re: Beginner Question...