2009/8/17 David Fetter :
> On Mon, Aug 17, 2009 at 07:50:14AM +0200, Pavel Stehule wrote:
>> 2009/8/17 David Fetter :
>> > On Mon, Aug 17, 2009 at 06:43:54AM +0200, Pavel Stehule wrote:
>> >> Hello
>> >>
>> >> 2009/8/16 Andre Lopes :
>> >> > Hi,
>> >> >
>> >> > I need a plpgsql function to validade
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.postgres
On Mon, Aug 17, 2009 at 07:50:14AM +0200, Pavel Stehule wrote:
> 2009/8/17 David Fetter :
> > On Mon, Aug 17, 2009 at 06:43:54AM +0200, Pavel Stehule wrote:
> >> Hello
> >>
> >> 2009/8/16 Andre Lopes :
> >> > Hi,
> >> >
> >> > I need a plpgsql function to validade e-mail addresses. I have google
>
2009/8/17 David Fetter :
> On Mon, Aug 17, 2009 at 06:43:54AM +0200, Pavel Stehule wrote:
>> Hello
>>
>> 2009/8/16 Andre Lopes :
>> > Hi,
>> >
>> > 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 valid
On Mon, Aug 17, 2009 at 06:43:54AM +0200, Pavel Stehule wrote:
> Hello
>
> 2009/8/16 Andre Lopes :
> > Hi,
> >
> > 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?
> >
> > Best Regards,
Hello
2009/8/16 Andre Lopes :
> Hi,
>
> 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?
>
> Best Regards,
> André.
>
You don't need plpgsql. Important is only an using of regular expression.
Tom Lane wrote:
Andre Lopes writes:
My question: Anyone have a function to validate e-mails?
Check the PG archives --- this has been discussed before. IIRC you
can't *really* validate them, short of actually sending mail.
And getting a reply.
But there are partial solutions in the archiv
Andre Lopes writes:
> My question: Anyone have a function to validate e-mails?
Check the PG archives --- this has been discussed before. IIRC you
can't *really* validate them, short of actually sending mail.
But there are partial solutions in the archives.
regards, tom l
On 16/08/2009 21:10, 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?
There are lots of regular expressions which Google will find for you,
which you can then use with on
