Re: RFC822 Checker - Mailing list pgsql-sql

From Hubert depesz Lubaczewski
Subject Re: RFC822 Checker
Date
Msg-id 20020903084144.GA10453@depesz.pl
Whole thread Raw
In response to RFC822 Checker  (Matthew Price <pricem@juno.com>)
List 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


pgsql-sql by date:

Previous
From: Oliver Elphick
Date:
Subject: Re: convert sum (interval) to seconds
Next
From: Tom Lane
Date:
Subject: Re: convert sum (interval) to seconds