Search Postgresql Archives

Re: Email Verfication Regular Expression

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Tue, Sep 13, 2005 at 09:02:46PM +0200, Peter Eisentraut wrote:
> Steve Atkins wrote:
> > If you want to validate email addresses you _must_ check the TLD as
> > part of the sanity checking, as many of the typos that are
> > theoretically detectable are detectable by that check.
> 
> Your requirements may be different than mine, but I often make up "fake" 
> TLDs for testing or even internal subnets in production systems, so 
> having a system that hardcoded the list of "official" TLDs would be 
> significantly less useful to me.

It depends on the needs. For a purely internal application your needs
are defined by your local setup. Those are not "internet email
addresses", though.

If you're accepting email addresses from Joe Public with the
expectation of sending email to them, then you really want to do as
much validation as you can at data capture time, or if not then at
data import time.

It's very, very hard to validate email addresses, but avoiding the
usual typos, mistakes and misunderstandings is a very good idea
and can keep your set of email addresses at least somewhat clean.

(I pity the poor folks at noemail.com and aol.co, though...)

Cheers,
  Steve

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux