Re: type for storing emails?

Поиск
Список
Период
Сортировка
От Rene Romero Benavides
Тема Re: type for storing emails?
Дата
Msg-id CANaGW09diQ3wQ5XTDGj4crX_Dg3QKKTQr+ANp4aUH+8G-kSAYw@mail.gmail.com
обсуждение исходный текст
Ответ на type for storing emails?  (stan <stanb@panix.com>)
Список pgsql-sql

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?

--
El genio es 1% inspiración y 99% transpiración.
Thomas Alva Edison


В списке pgsql-sql по дате отправления:

Предыдущее
От: Dmitry Igrishin
Дата:
Сообщение: Re: type for storing emails?
Следующее
От: Martin Edlman
Дата:
Сообщение: Re: type for storing emails?