Date: Tue, 12 Nov 2019 10:07:47 -0500
From: stan <stanb@panix.com>
To: pgsql-sql@lists.postgresql.org
Subject: FW: Re: type for storing emails?
Message-ID: <20191112150747.GA4004@panix.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
User-Agent: Mutt/1.12.1 (2019-06-15)
Precedence: bulk


On Mon, Nov 11, 2019 at 12:29:03PM -0600, Rene Romero Benavides wrote:
> 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?
> 

For the moment, I am just going to verify that what is entered is a valid
email format. Verifying that the email exists, may come later.

Thanks for making me think about this, though.

-- 
"They that would give up essential liberty for temporary safety deserve
neither liberty nor safety."
						-- Benjamin Franklin