On Thu, Aug 20, 2009 at 21:52, Jasen Betts<[email protected]> wrote:
> On 2009-08-19, Clemens Schwaighofer <[email protected]> wrote:
>> On Wed, Aug 19, 2009 at 02:11, Randal L. Schwartz<[email protected]>
>> wrote:
>>>>>>>> "Andre" == Andre Lopes <[email protected]> writes:
>>>
>>> Andre> I'm developing a function with some checks, for example... to check
>>> if the
>>> Andre> e-mail is valid or not.
>>>
>>> How are you hoping to do this? The regex to validate an email
>>> address syntactically is pretty large:
>>>
>>> http://ex-parrot.com/~pdw/Mail-RFC822-Address.html
>>>
>>> And no, I'm not kidding. If your regex is smaller than that, you aren't
>>> validating email... you're validating something "kinda like email".
>>
>> Just in my opinion, this regex is completely too large. For basic
>> validating something like:
>> ^[A-Za-z0-9!#$%&'*+-\/=?^_`{|}~][A-Za-z0-9!#$%&'*+-\/=?^_`{|}~\.]{0,6...@[a-za-z0-9-]+(\.[a-zA-Z0-9-]{1,})*\.([a-zA-Z]{2,4}){1}$
>> works very well
>
> not good: eg:
>
> fails this valid address* : [email protected]
yes it does, but all I need to change is {2,4}, to {2,6} or {2,}
> accepts this invalid one : [email protected]
and not it does not. I just tested it here.
The regex helps to avoid stuff like this:
[email protected]
foo@@bar.com
[email protected]
f...@bar
etc
>
> "musedoma" replaced with several x to protect the innocent from spam
>
> in some contexts email adrresses with no domain part are valid
> addresses with [bracketed] mx servers instead of a domain and/or bang
> paths are also allowed (but not in common use and often not desirable)
>
>
>
>
> --
> Sent via pgsql-general mailing list ([email protected])
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
★ Clemens 呉 Schwaighofer
★ IT Engineer/Web Producer/Planning
★ E-Graphics Communications SP Digital
★ 6-17-2 Ginza Chuo-ku, Tokyo 104-8167, JAPAN
★ Tel: +81-(0)3-3545-7706
★ Fax: +81-(0)3-3545-7343
★ http://www.e-gra.co.jp
This e-mail is intended only for the named person or entity to which it is
addressed and contains valuable business information that is privileged,
confidential and/or otherwise protected from disclosure. If you received this
e-mail in error, any review, use, dissemination, distribution or copying of
this e-mail is strictly prohibited. Please notify us immediately of the error
via e-mail to [email protected] and please delete the e-mail from your
system, retaining no copies in any media. We appreciate your cooperation.
--
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
