| From: | Rene Romero Benavides <rene(dot)romero(dot)b(at)gmail(dot)com> |
|---|---|
| To: | stan <stanb(at)panix(dot)com> |
| Cc: | pgsql-sql(at)lists(dot)postgresql(dot)org |
| Subject: | Re: type for storing emails? |
| Date: | 2019-11-11 18:29:03 |
| Message-ID: | CANaGW09diQ3wQ5XTDGj4crX_Dg3QKKTQr+ANp4aUH+8G-kSAYw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On Mon, Nov 11, 2019 at 11:59 AM stan <stanb(at)panix(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Martin Edlman | 2019-11-12 07:37:29 | Re: type for storing emails? |
| Previous Message | Dmitry Igrishin | 2019-11-11 18:19:45 | Re: type for storing emails? |