Home > mailing lists

Re: plpgsql function to validate e-mail - Mailing list pgsql-general

From	Peter Eisentraut
Subject	Re: plpgsql function to validate e-mail
Date	August 17, 2009 07:21:13
Msg-id	1250493658.7637.3.camel@fsopti579.F-Secure.com Whole thread Raw
In response to	plpgsql function to validate e-mail (Andre Lopes <lopes80andre@gmail.com>)
List	pgsql-general

Tree view

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.

pgsql-general by date:

From: David Fetter
Date: 17 August 2009, 06:58:43
Subject: Re: plpgsql function to validate e-mail

From: "Albe Laurenz"
Date: 17 August 2009, 07:26:50
Subject: Re: Database Security

Re: plpgsql function to validate e-mail - Mailing list pgsql-general

Previous

Next