Re: Looking for types: phone number, email addresses

Remember to allow quotes and spaces as well. This is a valid address (no,
not that I actually defined it as an alias):

"Josh Jore"@greentechnologist.org

Joshua b. Jore ; http://www.greentechnologist.org

On Fri, 19 Jul 2002, Stephane Bortzmeyer wrote:

> On Fri, Jul 19, 2002 at 03:27:19PM +0100,
> Lee Kindness <lkindness(at)csl(dot)co(dot)uk> wrote
> a message of 20 lines which said:
>
> 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\+\(dot)\_\-]+(at)[a-zA-Z0-9\(dot)\-]+$'),
> phone TEXT CHECK (phone ~ '^\\+[0-9]+[ 0-9]+$'),
> fax TEXT CHECK (fax ~ '^\\+[0-9]+[ 0-9]+$'),
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>