On Wed, Sep 07, 2005 at 12:21:45PM -0700,
Steve Atkins [EMAIL PROTECTED] wrote
a message of 26 lines which said:
/[EMAIL PROTECTED]@(?:[EMAIL
On Thu, Sep 08, 2005 at 12:16:36PM -0600,
Cristian Prieto [EMAIL PROTECTED] wrote
a message of 66 lines which said:
res = res_query(name, C_IN, T_MX, answer, sizeof(answer));
Besides Randal Schwartz' excellent remark (do not forget the
records, too), remember that the Internet is not
On Tue, Sep 13, 2005 at 12:59:43PM +0200, Stephane Bortzmeyer wrote:
On Wed, Sep 07, 2005 at 12:21:45PM -0700,
Steve Atkins [EMAIL PROTECTED] wrote
a message of 26 lines which said:
/[EMAIL PROTECTED]@(?:[EMAIL
Steve Atkins wrote:
If you want to validate email addresses you _must_ check the TLD as
part of the sanity checking, as many of the typos that are
theoretically detectable are detectable by that check.
Your requirements may be different than mine, but I often make up fake
TLDs for testing or
On Tue, Sep 13, 2005 at 09:02:46PM +0200, Peter Eisentraut wrote:
Steve Atkins wrote:
If you want to validate email addresses you _must_ check the TLD as
part of the sanity checking, as many of the typos that are
theoretically detectable are detectable by that check.
Your requirements
Well, I guess this could be a hard-expensive way to do it but I've done this
little Stored Function, it doesn't use a regular expresion (you could pass
your email first to one to check it out I guess).
#include postgres.h
#include fmgr.h
#include netinet/in.h
#include arpa/nameser.h
#include
Cristian == Cristian Prieto [EMAIL PROTECTED] writes:
Cristian res = res_query(name, C_IN, T_MX, answer, sizeof(answer));
This incorrectly fails if an address has an A record but no MX
record. According to RFC 2821 Section 5:
The lookup first attempts to locate an MX record associated
Does anybody have regular expression handy to verfiy email addresses?
--
Brad Nicholson
Database Administrator, Afilias Canada Corp.
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an
Am Mittwoch, den 07.09.2005, 11:17 -0400 schrieb Brad Nicholson:
Does anybody have regular expression handy to verfiy email addresses?
^([a-zA-Z0-9._-]+)\@(([a-zA-Z0-9-]+[.]?){1,}[a-zA-Z0-9-]*+\.){1,}[a-zA-Z]{2,4}$
but i don't think, it's really complete.
best regards,
Markus
On Sep 8, 2005, at 12:17 AM, Brad Nicholson wrote:
Does anybody have regular expression handy to verfiy email addresses?
http://www.ex-parrot.com/~pdw/Mail-RFC822-Address.html
:)
Michael Glaesemann
grzm myrealbox com
---(end of
Brad Nicholson [EMAIL PROTECTED] writes:
Does anybody have regular expression handy to verfiy email addresses?
It's harder than you think. For one that handles it in fairly full
generality, see Jeffrey Friedl's book _Mastering Reguar Expressions_.
The regex he comes up with is quite a beast.
Subject: Re: [GENERAL] Email Verfication Regular Expression
On Sep 8, 2005, at 12:17 AM, Brad Nicholson wrote:
Does anybody have regular expression handy to verfiy email addresses?
http://www.ex-parrot.com/~pdw/Mail-RFC822-Address.html
:)
Michael Glaesemann
grzm myrealbox com
Markus == Markus Rebbert [EMAIL PROTECTED] writes:
Markus Am Mittwoch, den 07.09.2005, 11:17 -0400 schrieb Brad Nicholson:
Does anybody have regular expression handy to verfiy email addresses?
Markus
^([a-zA-Z0-9._-]+)\@(([a-zA-Z0-9-]+[.]?){1,}[a-zA-Z0-9-]*+\.){1,}[a-zA-Z]{2,4}$
Markus but i
!
- Original Message - From: Michael Glaesemann
[EMAIL PROTECTED]
To: Brad Nicholson [EMAIL PROTECTED]
Cc: pgsql-general@postgresql.org
Sent: Wednesday, September 07, 2005 9:41 AM
Subject: Re: [GENERAL] Email Verfication Regular Expression
On Sep 8, 2005, at 12:17 AM, Brad Nicholson wrote
Randal L. Schwartz wrote:
Absolutely not. It rejects fred[EMAIL PROTECTED] which is a perfectly
valid email address. (Try it, you'll get my autoresponder.)
Google for RFC 822 and RFC 2822 to see the *real* rules. An
actual regex for an email address is rather large.
there's an extended
# [EMAIL PROTECTED] / 2005-09-07 11:17:10 -0400:
Does anybody have regular expression handy to verfiy email addresses?
This is what I have. The comment notes the caveats.
-- CREATE FUNCTION IS_EMAILADDRESS {{{
-- returns TRUE if $1 matches the rules for RFC2822 addr-spec token,
-- ignoring
On Wed, Sep 07, 2005 at 11:17:10AM -0400, Brad Nicholson wrote:
Does anybody have regular expression handy to verfiy email addresses?
It's not possible to validate an email address with a regex. If
you're prepared to handwave over things like whitespace and
embedded comments you can validate
On Wed, Sep 07, 2005 at 12:21:45 -0700,
Steve Atkins [EMAIL PROTECTED] wrote:
/[EMAIL PROTECTED]@(?:[EMAIL
Steve == Steve Atkins [EMAIL PROTECTED] writes:
Steve But, depending on what you're doing, validation may not be a good
Steve idea. There are email addresses that are syntactically invalid that
Steve are deliverable and in active use.
Really? Name one. Or maybe it's just your idea of syntax
On Wed, Sep 07, 2005 at 03:52:11PM -0500, Bruno Wolff III wrote:
On Wed, Sep 07, 2005 at 12:21:45 -0700,
Steve Atkins [EMAIL PROTECTED] wrote:
/[EMAIL PROTECTED]@(?:[EMAIL
On Wed, Sep 07, 2005 at 01:33:51PM -0700, Randal L. Schwartz wrote:
Steve == Steve Atkins [EMAIL PROTECTED] writes:
Steve But, depending on what you're doing, validation may not be a good
Steve idea. There are email addresses that are syntactically invalid that
Steve are deliverable and in
Steve == Steve Atkins [EMAIL PROTECTED] writes:
Steve So I consider any use of characters outside that set in a hostname or
Steve domain name to be invalid. Specifically an underscore is not a valid
Steve character, so any use of an underscore in the domain-part of an
Steve address that is
Brad Nicholson wrote:
Does anybody have regular expression handy to verfiy email addresses?
There are Perl modules on CPAN to verify just about anything.
Email::Valid comes to mind here. These can of course be plugged into a
PL/Perl function.
--
Peter Eisentraut
23 matches
Mail list logo