Re: Best way to store/search phone numbers?

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: Best way to store/search phone numbers?
Дата
Msg-id Pine.LNX.4.30.0111022111230.874-100000@peter.localdomain
обсуждение исходный текст
Ответ на Re: Best way to store/search phone numbers?  (Andrew Gould <andrewgould@yahoo.com>)
Список 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@gmx.net   http://funkturm.homeip.net/~peter


В списке pgsql-general по дате отправления:

Предыдущее
От: Justin Clift
Дата:
Сообщение: Sourceforge moving from PostgreSQL to Oracle
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Sourceforge moving from PostgreSQL to Oracle