Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id BAE22475E13 for ; Fri, 30 Aug 2002 10:08:35 -0400 (EDT) Received: from webmail6.nyc.untd.com (outbound-20.nyc.untd.com [64.136.20.100]) by postgresql.org (Postfix) with ESMTP id C3BC7475DD0 for ; Fri, 30 Aug 2002 10:08:34 -0400 (EDT) Received: from cookie.juno.com by cookie.juno.com for <"/TkDBi7JJ2b6tmw2z88AABzRWb1LNlC8mMQdHzkCxo+4cfqTTuXdiw=="> Received: (from pricem@juno.com) by webmail6.nyc.untd.com (jqueuemail) id HBGEWF2K; Fri, 30 Aug 2002 10:08:12 EDT X-Original-From: "Matthew Price" Date: Fri, 30 Aug 2002 14:07:28 GMT To: pgsql-sql@postgresql.org Cc: Subject: RFC822 Checker X-Mailer: Juno Webmail Version 1.0 From: Matthew Price Message-Id: <20020830.100812.20767.2685@webmail6.nyc.untd.com> X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200208/423 X-Sequence-Number: 9269 Howdy, 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. Thanks, Matthew ________________________________________________________________ GET INTERNET ACCESS FROM JUNO! Juno offers FREE or PREMIUM Internet access for less! Join Juno today! For your FREE software, visit: http://dl.www.juno.com/get/web/.