Postgres Pro
Downloads
Home   >   mailing lists

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

From merlyn@stonehenge.com (Randal L. Schwartz)
Subject Re: Postgre RAISE NOTICE and PHP
Date
Msg-id 86prat2gk1.fsf@blue.stonehenge.com
Whole thread Raw
In response to Postgre RAISE NOTICE and PHP  (Andre Lopes <lopes80andre@gmail.com>)
Responses Re: Postgre RAISE NOTICE and PHP  (Clemens Schwaighofer <clemens_schwaighofer@e-gra.co.jp>)
List pgsql-general
Tree view 
>>>>> "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".

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

--
Randal L. Schwartz - Stonehenge Consulting Services, Inc. - +1 503 777 0095
<merlyn@stonehenge.com> <URL:http://www.stonehenge.com/merlyn/>
Smalltalk/Perl/Unix consulting, Technical writing, Comedy, etc. etc.
See http://methodsandmessages.vox.com/ for Smalltalk and Seaside discussion

pgsql-general by date:

Previous
From: Devrim GÜNDÜZ
Date:
Subject: Re: 2 versions of Postgres on the same machine
Next
From: Michael Clark
Date:
Subject: PQgetlength vs. octet_length()