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?
Should the telephone type be able to do something such as:
SELECT * from tableFOO where telephone.areacode = 555;
Or would regex be better?
regards,
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
