Re: US Telephone Number Type

From: "Karen Hill" <karen_hill22(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: US Telephone Number Type
Date: 2006-07-10 23:19:19
Message-ID: 1152573559.449077.240600@m73g2000cwd.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jan Wieck 2006-07-10 23:41:09 Re: Notes on converting from MySQL 5.0.x to PostgreSQL
Previous Message SCassidy 2006-07-10 22:22:56 Re: US Telephone Number Type