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

From stan
Subject FW: Re: type for storing emails?
Date
Msg-id 20191112150747.GA4004@panix.com
Whole thread Raw
Responses Sv: FW: Re: type for storing emails?  (Andreas Joseph Krogh <andreas@visena.com>)
List pgsql-sql
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



pgsql-sql by date:

Previous
From: Martin Edlman
Date:
Subject: Re: type for storing emails?
Next
From: Andreas Joseph Krogh
Date:
Subject: Sv: FW: Re: type for storing emails?