Re: Select all invalid e-mail addresses

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Andrus <eetasoft(at)online(dot)ee>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Select all invalid e-mail addresses
Date: 2005-10-25 15:09:44
Message-ID: 20051025150944.GA41449@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Oct 25, 2005 at 11:20:53AM +0300, Andrus wrote:
> This regex allows email addresses containing two dots without any letters,
> like eeta(dot)(dot)soft(at)online(dot)ee
> I havent seen any email of such kind.

That's because the regular expression is wrong: it simply checks
the local part for zero or more non-@ characters instead of checking
against the RFC822/RFC2822 specification. Use a search engine to
find a more complete regular expression (beware: it's long).

--
Michael Fuhr

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jared Evans 2005-10-25 15:10:51 Re: Quickly calculating row size of a table?
Previous Message WireSpot 2005-10-25 15:01:37 Re: Deleting vs foreign keys