Re: Select all invalid e-mail addresses - Mailing list pgsql-general

From Hannes Dorbath
Subject Re: Select all invalid e-mail addresses
Date
Msg-id dj7j3v$17b9$1@news.hub.org
Whole thread Raw
In response to Re: Select all invalid e-mail addresses  (Michael Fuhr <mike@fuhr.org>)
Responses Re: Select all invalid e-mail addresses  (Douglas McNaught <doug@mcnaught.org>)
Re: Select all invalid e-mail addresses  (Hannes Dorbath <light@theendofthetunnel.de>)
List 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

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: 'a' == 'a ' (Was: RE: [pgsql-advocacy] Oracle buysInnobase)
Next
From: Csaba Nagy
Date:
Subject: Re: log_min_duration_statement oddity