Re: Postgre RAISE NOTICE and PHP - Mailing list pgsql-general

From Clemens Schwaighofer
Subject Re: Postgre RAISE NOTICE and PHP
Date
Msg-id fed954960908190200ia2e663ex85b15c34c8505763@mail.gmail.com
Whole thread Raw
In response to Re: Postgre RAISE NOTICE and PHP  (merlyn@stonehenge.com (Randal L. Schwartz))
List pgsql-general
On Wed, Aug 19, 2009 at 02:11, Randal L. Schwartz<merlyn@stonehenge.com> wrote:
>>>>>> "Andre" == Andre Lopes <lopes80andre@gmail.com> 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,63}@[a-zA-Z0-9-]+(\.[a-zA-Z0-9-]{1,})*\.([a-zA-Z]{2,4}){1}$
works very well

> For example, <fred&barney@stonehenge.com> is a valid email address.  (Go
> ahead, try it... it has an autoresponder.)

> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> 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
informationthat 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
immediatelyof the error via e-mail to disclaimer@tbwaworld.com and please delete the e-mail from your  system,
retainingno copies in any media.    We appreciate your cooperation. 


pgsql-general by date:

Previous
From: Arturo Pérez
Date:
Subject: Problem with bacula and 8.3/8.4
Next
From: "Andrus Moor"
Date:
Subject: Re: index "pg_authid_rolname_index" is not a btree