Re: Select all invalid e-mail addresses

From: Hannes Dorbath <light(at)theendofthetunnel(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Select all invalid e-mail addresses
Date: 2005-10-20 08:05:46
Message-ID: dj7j3v$17b9$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

--
Regards,
Hannes Dorbath

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Csaba Nagy 2005-10-20 08:08:50 Re: log_min_duration_statement oddity
Previous Message Richard Huxton 2005-10-20 07:47:30 Re: 'a' == 'a ' (Was: RE: [pgsql-advocacy] Oracle buysInnobase)