US Telephone Number Type

From: "Karen Hill" <karen_hill22(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: US Telephone Number Type
Date: 2006-07-10 17:33:52
Message-ID: 1152552832.166587.5980@b28g2000cwb.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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,

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2006-07-10 17:39:44 Re: Aim of --enable-thread-safety ?
Previous Message Joshua D. Drake 2006-07-10 16:36:26 Re: VACUUM FULL versus CLUSTER ON