Re: Best Practice for Address storage.

Поиск
Список
Период
Сортировка
От Daniel Staal
Тема Re: Best Practice for Address storage.
Дата
Msg-id 417A3DAAE06A4CCB181BCB2B@mac-pro.magehandbook.com
обсуждение исходный текст
Ответ на Re: Best Practice for Address storage.  (Paula Price <paula.price@issinc.com>)
Список 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 по дате отправления:

Предыдущее
От: James David Smith
Дата:
Сообщение: Beginner Question...
Следующее
От: Michael Wood
Дата:
Сообщение: Re: Beginner Question...