From: Hubert depesz Lubaczewski <depesz@depesz.pl>
To: Matthew Price <pricem@juno.com>
To: pgsql-sql@postgresql.org
Subject: Re: RFC822 Checker
Date: Tue, 3 Sep 2002 10:41:44 +0200
Message-ID: <20020903084144.GA10453@depesz.pl> (raw)
In-Reply-To: <20020830.100812.20767.2685@webmail6.nyc.untd.com>
References: <20020830.100812.20767.2685@webmail6.nyc.untd.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: depesz@depesz.pl, pricem@juno.com
Subject: Re: RFC822 Checker
In-Reply-To: <20020903084144.GA10453@depesz.pl>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox