Re: type for storing emails? - Mailing list pgsql-sql

From Rene Romero Benavides
Subject Re: type for storing emails?
Date
Msg-id CANaGW09diQ3wQ5XTDGj4crX_Dg3QKKTQr+ANp4aUH+8G-kSAYw@mail.gmail.com
Whole thread Raw
In response to type for storing emails?  (stan <stanb@panix.com>)
List pgsql-sql

On Mon, Nov 11, 2019 at 11:59 AM stan <stanb@panix.com> 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?

--
El genio es 1% inspiración y 99% transpiración.
Thomas Alva Edison


pgsql-sql by date:

Previous
From: Dmitry Igrishin
Date:
Subject: Re: type for storing emails?
Next
From: Martin Edlman
Date:
Subject: Re: type for storing emails?