| From: | 2trax <2trax(at)salterprojects(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | OT: Address Fields |
| Date: | 2003-07-31 09:39:35 |
| Message-ID: | pan.2003.07.31.09.39.34.792868@salterprojects.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi everyone,
Just wondering if anyone has any tips on the best way to represent
international addresses (ie from any country) in a database?
It seems to me that the most flexible way is to use a text field to hold
everything, apart from the country which suits a varchar? and perhaps have
another dedicated varchar field to hold USA ZIP codes / UK post codes for
easy searching?
Advice from those who have successfully created a scheme with enough
flexibility and structure to be useful would be greatly appreciated.
Thanks,
Sam.
---
Posted via news://freenews.netfront.net
Complaints to news(at)netfront(dot)net
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David W Noon | 2003-07-31 10:19:25 | Re: OT: Address Fields |
| Previous Message | Michael Govorun | 2003-07-31 08:18:46 | Re: Don't removes/recycles WAL files at all |