Re: Variable-length Types
| От | Josh Berkus |
|---|---|
| Тема | Re: Variable-length Types |
| Дата | |
| Msg-id | 39E9F80C.D9BE2054@agliodbs.com обсуждение исходный текст |
| Ответ на | Variable-length Types (Itai Zukerman <zukerman@math-hat.com>) |
| Ответы |
Re: Variable-length Types
|
| Список | pgsql-sql |
Folks,
I'm a bit confused on custom type declarations, actually. I'd like to
create a custom type for American phone numbers, such that:
It takes a string and returns something that looks like Varchar(22);
If someone types in 10 digits, it returns output like (###) ###-####
If a user enters 7 digits, it picks a default area code and returns
(415) ###-####,
and if they type more than 10 digits or enter any digits after an "x",
they get (###) ###-#### x###
My questions are as follows:
1. Can I reference a custom function (phoneformat) in a type definition?
2. If 1. is "no", is there a way to do the above without programming the
type in C?
3. What sort of trouble am I going to get into trying to pull data from
a custom type into an external interface (i.e. PHP4)?
Thanks for your thoughts!
-Josh Berkus
--
______AGLIO DATABASE SOLUTIONS___________________________ Josh Berkus Complete
informationtechnology josh@agliodbs.com and data management solutions (415) 436-9166 for law firms, small
businesses fax 436-0137 and non-profit organizations. pager 338-4078 San
Francisco
В списке pgsql-sql по дате отправления: