Re: US Telephone Number Type - Mailing list pgsql-general

From Karen Hill
Subject Re: US Telephone Number Type
Date
Msg-id 1152573559.449077.240600@m73g2000cwd.googlegroups.com
Whole thread Raw
In response to Re: US Telephone Number Type  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: US Telephone Number Type
List 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 by date:

Previous
From: Jan Wieck
Date:
Subject: Re: Notes on converting from MySQL 5.0.x to PostgreSQL
Next
From: Chris Browne
Date:
Subject: Re: US Telephone Number Type