Re: type for storing emails?

--000000000000cc2bf90597162d4b
Content-Type: text/plain; charset="UTF-8"

https://github.com/petere/pgemailaddr

On Mon, 11 Nov 2019, 20:59 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
>
>
>

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

<div dir=3D"auto"><a href=3D"https://github.com/petere/pgemailaddr">https:/=
/github.com/petere/pgemailaddr</a></div><br><div class=3D"gmail_quote"><div=
 dir=3D"ltr" class=3D"gmail_attr">On Mon, 11 Nov 2019, 20:59 stan, &lt;<a h=
ref=3D"mailto:[email protected]">[email protected]</a>&gt; wrote:<br></div><blo=
ckquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #c=
cc solid;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>

--000000000000cc2bf90597162d4b--