I'm pretty sure this isn't as simple as you think it is, I'd suggest
having a good read of:
https://stackoverflow.com/a/201378/216229
Chris
On 16/11/2017 07:56, Nick Dro wrote:
> I beleieve that every information system has the needs to send emails.
> Currently PostgreSQL doesn't have a function which gets TEXT and
> return true if it's valid email address (xxx(at)YYY(dot)com / .co.ZZ)
> Do you believe such function should exist in PostgreSQL or it's best
> to let every user to implement his own function?