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
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
