Date: Tue, 3 Sep 2002 10:41:44 +0200
From: Hubert depesz Lubaczewski <depesz@depesz.pl>
To: Matthew Price <pricem@juno.com>, pgsql-sql@postgresql.org
Subject: Re: RFC822 Checker
Message-ID: <20020903084144.GA10453@depesz.pl>
Reply-To: depesz@depesz.pl
References: <20020830.100812.20767.2685@webmail6.nyc.untd.com>
Mime-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
	protocol="application/pgp-signature"; boundary="3V7upXqbjpZ4EhLz"
Content-Disposition: inline
In-Reply-To: <20020830.100812.20767.2685@webmail6.nyc.untd.com>
User-Agent: Mutt/1.4i

--3V7upXqbjpZ4EhLz
Content-Type: text/plain; charset=iso-8859-2
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

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

--=20
hubert depesz lubaczewski                          http://www.depesz.pl/
------------------------------------------------------------------------
M=F3j Bo=BFe, spraw abym milcza=B3, dop=F3ki si=EA nie upewni=EA,  =BFe  na=
prawd=EA  mam
co=B6 do powiedzenia.                                      (c) 1998 depesz


--3V7upXqbjpZ4EhLz
Content-Type: application/pgp-signature
Content-Disposition: inline

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.7 (GNU/Linux)

iD8DBQE9dHXIKBwKA0prOAkRApcoAKDQCf5DhyEtPx3SEDWsbC5WhIJUoQCdGcY5
mx2fTQkMxMef6O8kGlyaxOo=
=MyVg
-----END PGP SIGNATURE-----

--3V7upXqbjpZ4EhLz--