Re: Select all invalid e-mail addresses - Mailing list pgsql-general

From Michael Fuhr
Subject Re: Select all invalid e-mail addresses
Date
Msg-id 20051025150944.GA41449@winnie.fuhr.org
Whole thread Raw
In response to Re: Select all invalid e-mail addresses  ("Andrus" <eetasoft@online.ee>)
Responses Re: Select all invalid e-mail addresses
List 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..soft@online.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

pgsql-general by date:

Previous
From: WireSpot
Date:
Subject: Re: Deleting vs foreign keys
Next
From: Csaba Nagy
Date:
Subject: Re: Deleting vs foreign keys