"D'Arcy J.M. Cain" wrote:
> PostgreSQL could use a
> phone number type. I have been meaning to write a user defined type
> for some time but never seem to get around to it. Maybe you could
> give this a shot. The examples in contrib should get you started.
> Once finished you can make the phone # one column and split out parts
> with various functions. Don't forget to have a place for country code
> and extension.
i messed around with one a while back, but i dropped it before i
if i recall correctly, it was mostly working, but i don't know if i
broke it again after that or not. i'll put a copy of it on my web site
-- you can download it, clean it up and put it in contrib if you want.
i just tarred up the files, there's no documentation for it & barely any
copyright info in it. put whatever license you want on it if you want
to reuse it.
the files located at:
In response to
pgsql-sql by date
|Next:||From: Tom Lane||Date: 2000-06-23 15:52:25|
|Subject: Re: Using substr with user defined types |
|Previous:||From: Mitch Vincent||Date: 2000-06-23 14:53:41|
|Subject: Re: Need to improve performance|