Re: Select all invalid e-mail addresses

From: Douglas McNaught <doug(at)mcnaught(dot)org>
To: Hannes Dorbath <light(at)theendofthetunnel(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Select all invalid e-mail addresses
Date: 2005-10-20 12:00:56
Message-ID: m2ll0otn2f.fsf@Douglas-McNaughts-Powerbook.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hannes Dorbath <light(at)theendofthetunnel(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2005-10-20 12:06:05 Re: versions of oDBC driver
Previous Message Ledina Hido 2005-10-20 11:44:53 Re: Checking Multiplicity Constraints and Retrieving Data from Error Messages