On Fri, Jul 19, 2002 at 03:27:19PM +0100,
Lee Kindness <lkindness@csl.co.uk> wrote
a message of 20 lines which said:
> Is the field going to be used by humans (in which case they can sort
> out minor formatting issues on the fly) or for automated dialing
> (in which case you'd probably want to strip out everything bar
> numerics)?
Mostly by humans (I don't foresee automatic use) but the idea was to
catch mispellings (such as typing O "o" instead of 0 "zero").
Email addresses, on the other hand, *will* be used automatically
(opt-in only, do not worry).
At the present time, I use:
-- Not perfectly RFC 2822-compliant :-(
email TEXT NOT NULL CHECK (email ~ '^[a-zA-Z0-9\+\.\_\-]+@[a-zA-Z0-9\.\-]+$'),
phone TEXT CHECK (phone ~ '^\\+[0-9]+[ 0-9]+$'),
fax TEXT CHECK (fax ~ '^\\+[0-9]+[ 0-9]+$'),