| From: | Hubert depesz Lubaczewski <depesz(at)depesz(dot)pl> |
|---|---|
| To: | Matthew Price <pricem(at)juno(dot)com>, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: RFC822 Checker |
| Date: | 2002-09-03 08:41:44 |
| Message-ID: | 20020903084144.GA10453@depesz.pl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Doppelganger | 2002-09-03 10:45:33 | convert sum (interval) to seconds |
| Previous Message | tp | 2002-09-03 08:37:27 | Re: UPDATE & LIMIT together? |