Re: plpgsql function to validate e-mail

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Andre Lopes <lopes80andre(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: plpgsql function to validate e-mail
Date: 2009-08-17 07:20:58
Message-ID: 1250493658.7637.3.camel@fsopti579.F-Secure.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sun, 2009-08-16 at 21:10 +0100, Andre Lopes wrote:
> I need a plpgsql function to validade e-mail addresses. I have google
> but I can't find any.
>
> My question: Anyone have a function to validate e-mails?

I recommend something based on the following recipe in PL/Perl.

http://wiki.postgresql.org/wiki/Email_address_parsing

Rewriting that complete logic in PL/pgSQL will probably be very tricky.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Albe Laurenz 2009-08-17 07:25:59 Re: Database Security
Previous Message David Fetter 2009-08-17 06:58:36 Re: plpgsql function to validate e-mail