On Fri, Aug 30, 2002 at 02:07:28PM +0000, Matthew Price wrote:
> Does anyone know of an SQL function that will check a string for
> compliance with the RFC822 mail address spec? I have a script that
> sends mail from a db (no, I am not a spammer) but I often have mails
> sitting in my queue because the MTA (correctly) refuses to process
> some of the bogus things that users enter by mistake.
you might want to check:
ftp://ftp.cpan.org/CPAN/authors/Tom_Christiansen/scripts/ckaddr.gz
since this is in pure perl, making a pl/perl function should be pretty
simple.
depesz
--
hubert depesz lubaczewski http://www.depesz.pl/
------------------------------------------------------------------------
Mój Boże, spraw abym milczał, dopóki się nie upewnię, że naprawdę mam
coś do powiedzenia. (c) 1998 depesz