Not knowing your application, keep in mind that just because somebody
enters a syntactically correct email address doesn't mean they entered
the right one.
Cristian Prieto wrote:
> Does somebody could embed this regex into a pgsql ~ statement? (maybe
> in a DOMAIN type?)
>
> Thanks a lot!
>
> ----- Original Message ----- From: "Michael Glaesemann"
> <grzm@myrealbox.com>
> To: "Brad Nicholson" <bnichols@ca.afilias.info>
> Cc: <pgsql-general@postgresql.org>
> Sent: Wednesday, September 07, 2005 9:41 AM
> Subject: Re: [GENERAL] Email Verfication Regular Expression
>
>
>>
>> On Sep 8, 2005, at 12:17 AM, Brad Nicholson wrote:
>>
>>> Does anybody have regular expression handy to verfiy email addresses?
>>
>>
>> http://www.ex-parrot.com/~pdw/Mail-RFC822-Address.html
>>
>> :)
>>
>> Michael Glaesemann
>> grzm myrealbox com
>>
>>
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 4: Have you searched our list archives?
>>
>> http://archives.postgresql.org
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match