US Telephone Number Type

Поиск
Список
Период
Сортировка
Hello,

How would one go about creating a US telephone type in the format of
"(555)-555-5555" ?  I am at a loss on how it could be accomplished in
the most correct way possible while not going into the various
different country styles e.g. +01 (555) 555-5555.

Is the difficulty of creating a telephone type the reason it is not in
postgresql already?

Should the telephone type be able to do something such as:

SELECT * from tableFOO where telephone.areacode = 555;

Or would regex be better?


regards,


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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Aim of --enable-thread-safety ?
Следующее
От: marcelo Cortez
Дата:
Сообщение: encoding bug or feature?