Re: FW: Re: type for storing emails?

Поиск
Список
Период
Сортировка
От Steve Midgley
Тема Re: FW: Re: type for storing emails?
Дата
Msg-id CAJexoSK2164CXFF_82u=OufPTh0Hk2F_YLSKE6_4hq4-TN2e-A@mail.gmail.com
обсуждение исходный текст
Ответ на Sv: FW: Re: type for storing emails?  (Andreas Joseph Krogh <andreas@visena.com>)
Ответы Re: FW: Re: type for storing emails?  (Andreas Joseph Krogh <andreas@visena.com>)
Список pgsql-sql


On Tue, Nov 12, 2019 at 7:21 AM Andreas Joseph Krogh <andreas@visena.com> wrote:
På tirsdag 12. november 2019 kl. 16:07:47, skrev stan <stanb@panix.com>:
[...]
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.
 
 
Note that it's only possible to verify that the email-address is correctly structured and a syntactically correct. There is no way to verify that an email-address actually exists, ie. that a recipient will receive emails sent to it.

Not to be pedantic but in the data model, you could have a couple of verification data fields (e.g. verification_code; email_verified), and actually send an email and record if the user comes back with the correct verification code. It's obviously not something that can be handled solely via specs or database, but a data model can accommodate actual email verification (as I know you know, but thought I should make clear for future readers of the archives).
 
Вложения

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

Предыдущее
От: Andreas Joseph Krogh
Дата:
Сообщение: Sv: FW: Re: type for storing emails?
Следующее
От: Andreas Joseph Krogh
Дата:
Сообщение: Re: FW: Re: type for storing emails?