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.
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 |