type for storing emails?

Поиск
Список
Период
Сортировка
От stan
Тема type for storing emails?
Дата
Msg-id 20191111175920.GA16283@panix.com
обсуждение исходный текст
Ответы Re: type for storing emails?  (Dmitry Igrishin <dmitigr@gmail.com>)
Re: type for storing emails?  (Rene Romero Benavides <rene.romero.b@gmail.com>)
Список 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



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

Предыдущее
От: "Tchouante, Merlin"
Дата:
Сообщение: RE: Help with outer joins
Следующее
От: Dmitry Igrishin
Дата:
Сообщение: Re: type for storing emails?