Re: US Telephone Number Type

Поиск
Список
Период
Сортировка
От Karen Hill
Тема Re: US Telephone Number Type
Дата
Msg-id 1152573559.449077.240600@m73g2000cwd.googlegroups.com
обсуждение исходный текст
Ответ на Re: US Telephone Number Type  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: US Telephone Number Type
Список pgsql-general
Tom Lane wrote:

> It doesn't seem particularly hard to make a type that stores just the
> digits (applying whatever amount of error-checking seems appropriate
> on the non-digit stuff it's throwing away) and on output regurgitates
> a standardized format.  Minimum support would just be an input function
> and an output function, and it doesn't seem like you need too many other
> functions besides them

I did a quick google and someone mentioned that input and output
functions need to be written in C.  Is that still the case?

Anyway, there could be multiple number types to choose from such as:

telephone-us-basic  : (555) 555-5555
telephone-us-extention : (555) 555-5555 ext 1234

Other locals (EU, etc) could create their own to their local
specifications. This would seem like a nice contrib package.


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

Предыдущее
От: Jan Wieck
Дата:
Сообщение: Re: Notes on converting from MySQL 5.0.x to PostgreSQL
Следующее
От: Chris Browne
Дата:
Сообщение: Re: US Telephone Number Type