Re: type for storing emails?

--0000000000001a7c7b0597164f1a
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Mon, Nov 11, 2019 at 11:59 AM stan <[email protected]> wrote:

> Does anyone have a type they have developed for storing emails. I need
> to do that, and the things that are in my thoughts on this are storing it
> as
> a derived type of citext, as case should not matter, and enforcing the at
> sign with pretty much anything on the left side of it, and something that
> looks like a domain on the right side of it.
>
>
> --
> "They that would give up essential liberty for temporary safety deserve
> neither liberty nor safety."
>                                                 -- Benjamin Franklin
>
>
>
How are you going to handle invalid / non existent emails?

--=20
El genio es 1% inspiraci=C3=B3n y 99% transpiraci=C3=B3n.
Thomas Alva Edison

--0000000000001a7c7b0597164f1a
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><br></div><div class=3D"gmail_quote"><div=
 dir=3D"ltr" class=3D"gmail_attr">On Mon, Nov 11, 2019 at 11:59 AM stan &lt=
;<a href=3D"mailto:[email protected]">[email protected]</a>&gt; wrote:<br></div=
><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border=
-left:1px solid rgb(204,204,204);padding-left:1ex">Does anyone have a type =
they have developed for storing emails. I need<br>
to do that, and the things that are in my thoughts on this are storing it a=
s<br>
a derived type of citext, as case should not matter, and enforcing the at<b=
r>
sign with pretty much anything on the left side of it, and something that<b=
r>
looks like a domain on the right side of it.<br>
<br>
<br>
-- <br>
&quot;They that would give up essential liberty for temporary safety deserv=
e<br>
neither liberty nor safety.&quot;<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =
=C2=A0 =C2=A0 =C2=A0 -- Benjamin Franklin<br>
<br>
<br>
</blockquote></div><div><br></div>How are you going to handle invalid / non=
 existent emails?<br clear=3D"all"><div><br></div>-- <br><div dir=3D"ltr" c=
lass=3D"gmail_signature">El genio es 1% inspiraci=C3=B3n y 99% transpiraci=
=C3=B3n.<br>Thomas Alva Edison<br><br><div style=3D"padding:0px;margin-left=
:0px;margin-top:0px;overflow:hidden;color:black;font-size:10px;text-align:l=
eft;line-height:130%"></div><div><br></div></div></div>

--0000000000001a7c7b0597164f1a--