Re: Select all invalid e-mail addresses

Поиск
Список
Период
Сортировка
От Douglas McNaught
Тема Re: Select all invalid e-mail addresses
Дата
Msg-id m2ll0otn2f.fsf@Douglas-McNaughts-Powerbook.local
обсуждение исходный текст
Ответ на Re: Select all invalid e-mail addresses  (Hannes Dorbath <light@theendofthetunnel.de>)
Ответы Re: Select all invalid e-mail addresses  (Brian Mathis <brian.mathis@gmail.com>)
Список pgsql-general
Hannes Dorbath <light@theendofthetunnel.de> 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

В списке pgsql-general по дате отправления:

Предыдущее
От: Ledina Hido
Дата:
Сообщение: Re: Checking Multiplicity Constraints and Retrieving Data from Error Messages
Следующее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: Checking Multiplicity Constraints and Retrieving Data from Error Messages