US Telephone Number Type - Mailing list pgsql-general

From Karen Hill
Subject US Telephone Number Type
Date
Msg-id 1152552832.166587.5980@b28g2000cwb.googlegroups.com
Whole thread Raw
Responses Re: US Telephone Number Type  (Martijn van Oosterhout <kleptog@svana.org>)
Re: US Telephone Number Type  (Vivek Khera <vivek@khera.org>)
Re: US Telephone Number Type  (Jorge Godoy <jgodoy@gmail.com>)
Re: US Telephone Number Type  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: US Telephone Number Type  ("Merlin Moncure" <mmoncure@gmail.com>)
Re: US Telephone Number Type  (Guy Fraser <guy@incentre.net>)
List 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,


pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Aim of --enable-thread-safety ?
Next
From: marcelo Cortez
Date:
Subject: encoding bug or feature?