agora inbox for pgsql-sql@postgresql.org  

help / color / mirror / Atom feed

From: stan <stanb@panix.com>
To: pgsql-sql@lists.postgresql.org
Subject: FW: Re: type for storing emails?
Date: Tue, 12 Nov 2019 10:07:47 -0500
Message-ID: <20191112150747.GA4004@panix.com> (raw)


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

view thread (7+ messages)  latest in thread

Message-ID: <20191112150747.GA4004@panix.com>
Permalink:  ../20191112150747.GA4004@panix.com/
Also on:    postgresql.org/message-id/20191112150747.GA4004@panix.com

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: stanb@panix.com, pgsql-sql@lists.postgresql.org
  Subject: Re: FW: Re: type for storing emails?
  In-Reply-To: <20191112150747.GA4004@panix.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox