Re: Email Verfication Regular Expression

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Steve Atkins <steve(at)blighty(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Email Verfication Regular Expression
Date: 2005-09-07 20:52:11
Message-ID: 20050907205211.GA10493@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Sep 07, 2005 at 12:21:45 -0700,
Steve Atkins <steve(at)blighty(dot)com> wrote:
>
> /^[^(at)]*@(?:[^(at)]*\(dot))?[a-z0-9-_]+\.(?:a[defgilmnoqrstuwz]|b[abdefghijmnorstvwyz]|c[acdfghiklmnoruvxyz]|d[ejkmoz]|e[ceghrst]|f[ijkmorx]|g[abdefhilmnpqrstuwy]|h[kmnrtu]|i[delnoqrst]|j[mop]|k[eghimnprwyz]|l[abcikrstuvy]|m[acdghklmnopqrstuvwxyz]|n[acefgilopruz]|om|p[aefghklmnrtwy]|qa|r[eouw]|s[abcdeghijklmnortvyz]|t[cdfghjkmnoprtvwz]|u[agkmsyz]|v[aceginu]|w[fs]|y[etu]|z[amw]|edu|com|net|org|gov|mil|info|biz|coop|museum|aero|name|pro)$/
>
> This'll exclude email addresses like tv(at)tv, but the owners of such are used
> to their being rejected, and it saves you from a lot of the usual miskeyed
> addresses.

Hard coding the top level domains seems like a bad idea. xxx might still get
added. It also doesn't take into account there are non-icann roots that
include other tlds.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jim C. Nasby 2005-09-07 21:15:01 Re: RAID0 and pg_xlog
Previous Message Randal L. Schwartz 2005-09-07 20:33:51 Re: Email Verfication Regular Expression