Search Postgresql Archives

Re: Select all invalid e-mail addresses

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hannes Dorbath <light@xxxxxxxxxxxxxxxxxxxx> writes:

> On 19.10.2005 21:18, Michael Fuhr wrote:
>> One possibility would be to write a plperlu function that uses the
>> Email::Valid module.  Here's a trivial example; see the Email::Valid
>> documentation to learn about its full capabilities:
>
> ..and if you don't mind installing pl/php, you can use this function:
>
> http://hannes.imos.net/validmail.html
>
> It performs a MX-lookup, which IMHO is the best way to check for validity.

But that's expensive and slow, and doesn't tell you whether the user
part of the address is valid (and in general, there's no way to
determine that short of actually sending a message).  So what's the
point?

-Doug

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux