| From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
|---|---|
| To: | Nick Dro <postgresql(at)walla(dot)co(dot)il> |
| Cc: | "pgsql-general(at)postgresql(dot)org >> PG-General Mailing List" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Build in function to verify email addresses |
| Date: | 2017-11-16 08:05:00 |
| Message-ID: | CAFj8pRDK5VyD295foQVfQiqmv+AbuL0O2Sot5T2pnAotizC3ww@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi
2017-11-16 8:56 GMT+01:00 Nick Dro <postgresql(at)walla(dot)co(dot)il>:
> 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?
>
I don't think so this functionality should be in upstream - but it is good
use for some extension and placing it in PGXN or PostgreSQL community
repository.
Postgres has good regexp support and this case can be implemented by one
regexp.
you can use PLPerlu and use some modules from CPAN
http://search.cpan.org/~rjbs/Email-Valid-1.202/lib/Email/Valid.pm
Regards
Pavel
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Chris Withers | 2017-11-16 14:55:18 | Re: Build in function to verify email addresses |
| Previous Message | Nick Dro | 2017-11-16 07:56:42 | Build in function to verify email addresses |