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@csl.co.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\+\.\_\-]+@[a-zA-Z0-9\.\-]+$'),
>  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
>