[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [GENERAL] Build in function to verify email addresses
From:       Michael Nolan <htfoot () gmail ! com>
Date:       2017-11-16 15:45:29
Message-ID: CAOzAquLH-wFG2+0YQ4cLGeu3DtmonrYOfMgAbTL8chmCmxOXSQ () mail ! gmail ! com
[Download RAW message or body]

On Thu, Nov 16, 2017 at 1:56 AM, Nick Dro <postgresql@walla.co.il> wrote:

> I beleieve that every information system has the needs to send emails.
> Currently PostgreSQL doesn't have a function which gets TEXT and return
> true if it's valid email address (xxx@YYY.com / .co.ZZ)
> Do you believe such function should exist in PostgreSQL or it's best to
> let every user to implement his own function?
>

There's a world of difference between an email address that is well-formed
and one that actually works.

In the systems I administer there's a lot of time spent dealing with
bounced mail to make sure that the email addresses we have actually reach
someone, hopefully the intended target.  And in the US, bulk emailers also
have to deal with the CAN-SPAM act, which specifies procedures that must be
in place to allow easy administrative options to remove one'e email address
from mailing lists.

Procedures to verify that an email address works and to administer its use
under rules like CAN_SPAM cannot exist solely within the database itself.
And as others have noted, what makes for a 'well-formed' email address has
always been a bit complicated.
--
Mike Nolan

[Attachment #3 (text/html)]

<div dir="ltr"><br><div class="gmail_extra"><br><div class="gmail_quote">On Thu, Nov \
16, 2017 at 1:56 AM, Nick Dro <span dir="ltr">&lt;<a \
href="mailto:postgresql@walla.co.il" \
target="_blank">postgresql@walla.co.il</a>&gt;</span> wrote:<br><blockquote \
class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex"><div dir="rtl"><div dir="ltr">I beleieve that every \
information system has the needs to send emails.</div> <div dir="ltr">Currently \
PostgreSQL doesn&#39;t have a function which gets TEXT and return true if it&#39;s \
valid email address (xxx@YYY.com / .co.ZZ)</div> <div dir="ltr">Do you believe such \
function should exist in PostgreSQL or it&#39;s best to let every user to implement \
his own function?</div></div></blockquote></div></div><div \
class="gmail_extra"><br></div><div class="gmail_extra">There&#39;s a world of \
difference between an email address that is well-formed and one that actually works.  \
<br></div><div class="gmail_extra"><br></div><div class="gmail_extra">In the systems \
I administer there&#39;s a lot of time spent dealing with bounced mail to make sure \
that the email addresses we have actually reach someone, hopefully the intended \
target.   And in the US, bulk emailers also have to deal with the CAN-SPAM act, which \
specifies procedures that must be in place to allow easy administrative options to \
remove one&#39;e email address from mailing lists.   <br></div><div \
class="gmail_extra"><br></div><div class="gmail_extra">Procedures to verify that an \
email address works and to administer its use under rules like CAN_SPAM cannot exist \
solely within the database itself.   And as others have noted, what makes for a \
&#39;well-formed&#39; email address has always been a bit complicated.   \
<br></div><div class="gmail_extra">--</div><div class="gmail_extra">Mike \
Nolan<br></div></div>



[prev in list] [next in list] [prev in thread] [next in thread]