US Telephone Number Type

Поиск
Список
Период
Сортировка
От Karen Hill
Тема US Telephone Number Type
Дата
Msg-id 1152552832.166587.5980@b28g2000cwb.googlegroups.com
обсуждение исходный текст
Ответы Re: US Telephone Number Type  (Martijn van Oosterhout <kleptog@svana.org>)
Re: US Telephone Number Type  (Vivek Khera <vivek@khera.org>)
Re: US Telephone Number Type  (Jorge Godoy <jgodoy@gmail.com>)
Re: US Telephone Number Type  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: US Telephone Number Type  ("Merlin Moncure" <mmoncure@gmail.com>)
Re: US Telephone Number Type  (Guy Fraser <guy@incentre.net>)
Список pgsql-general
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?