On 10 Jul 2006 10:33:52 -0700, Karen Hill <[EMAIL PROTECTED]> wrote:
Hello,
How would one go about creating a US telephone type in the format of
"(555)-555-5555" ? I am at a loss on how it could be accomplished in
the most correct way possible while not going into the various
different country styles e.g. +01 (555) 555-5555.
Is the difficulty of creating a telephone type the reason it is not in
postgresql already?
if it was me, i would keep a telephone type to simple text field.
while there is some merit to throwing a domain constraint on it,
history tells me this is more troulbe than it's worth :).
otoh, you could make a small immutable sql based regex function to
attempt to extract the area code or some other number from the text
field. You could then index this if desired.
merlin
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
