Re: Select all invalid e-mail addresses - Mailing list pgsql-general

From Hannes Dorbath
Subject Re: Select all invalid e-mail addresses
Date
Msg-id dj81kk$1rm2$1@news.hub.org
Whole thread Raw
In response to Re: Select all invalid e-mail addresses  (Hannes Dorbath <light@theendofthetunnel.de>)
List pgsql-general
On 20.10.2005 14:00, Douglas McNaught wrote:
> But that's expensive and slow

Sure, that isn't meant to be used in a WHERE condition on a 100k row
table.. more to be bound via check constraint on a user table, so
incomming data is validated.

> and doesn't tell you whether the user part of the address is valid (and in general, there's no way to
> determine that short of actually sending a message). So what's the
> point?

The point is to validate as good as possible, and as you said yourself,
the user part can't be validated further.


--
Regards,
Hannes Dorbath

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Checking Multiplicity Constraints and Retrieving Data from Error Messages
Next
From: Jan Wieck
Date:
Subject: Re: [HACKERS] 'a' == 'a '