From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
---|---|
To: | Andrew Gould <andrewgould(at)yahoo(dot)com> |
Cc: | Raise Exception <raiseexception(at)yahoo(dot)com>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Best way to store/search phone numbers? |
Date: | 2001-11-04 13:05:13 |
Message-ID: | Pine.LNX.4.30.0111022111230.874-100000@peter.localdomain |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Andrew Gould writes:
> I'd use different fields (country code, area code,
> phone number, extension, etc.) and instruct the users
> not to use punctuation.
This will break down once someone from a different area/country tries to
enter his phone number.
You think it won't happen? I have tried to do business with quite a few
places that didn't think my business would happen. (I didn't actually end
up happening, too.)
OTOH, I once did work for an ISP that had a very specific interest in the
breakdown of phone numbers by area code, exchange, and such. I used a
text field with a couple of functional indexes, and it worked well for us.
--
Peter Eisentraut peter_e(at)gmx(dot)net http://funkturm.homeip.net/~peter
From | Date | Subject | |
---|---|---|---|
Next Message | kingking | 2001-11-04 15:47:05 | PostgreSQL Web Site |
Previous Message | Justin Clift | 2001-11-04 10:00:44 | Sourceforge moving from PostgreSQL to Oracle |