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