Best way to store/search phone numbers?

Поиск
Список
Период
Сортировка
От raiseexception@yahoo.com (Raise Exception)
Тема Best way to store/search phone numbers?
Дата
Msg-id 97706cb6.0110310752.13f441d5@posting.google.com
обсуждение исходный текст
Ответы Re: Best way to store/search phone numbers?  (Andrew Gould <andrewgould@yahoo.com>)
Список pgsql-general
I am doing a standard company info database, with phone numbers, and I
was wondering if there was a general concensus about the best way to
store phone numbers.  My problem is multiple users will be entering in
data via a web browser (PHP backend), and the formatting may not be
the same in all cases.  I'm not sure if I should store some sort of
standard formatting in a plain text field (e.g., "(555) 555-5555") or
strip out all the punctuation characters.  There is also the option of
storing the parts in different columns, but that seems a bit overkill
(but would make searching possibly faster).

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

Предыдущее
От: SuperDutyTA73@aol.com (Super Duty)
Дата:
Сообщение: two processors or more memory?
Следующее
От: Fran Fabrizio
Дата:
Сообщение: Can a PL/pgSQL function return a set of rows?