type for storing emails?

From: stan <stanb(at)panix(dot)com>
To: pgsql-sql(at)lists(dot)postgresql(dot)org
Subject: type for storing emails?
Date: 2019-11-11 17:59:20
Message-ID: 20191111175920.GA16283@panix.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Dmitry Igrishin 2019-11-11 18:19:45 Re: type for storing emails?
Previous Message Tchouante, Merlin 2019-11-11 15:21:54 RE: Help with outer joins