On Thu, Oct 20, 2005 at 09:54:13PM +0300, Andrus wrote: > How to write a WHERE clause which selects e-mail addresses which > are surely wrong ? Then I think the validating function someone else sent here (<http://www.databasejournal.com/img/email_val.sql>) is a good start. You probably want the opposite behaviour -- emailinvalidate(), I guess -- but that seems like a good "obviously wrong" tester. It might not be fast, though -- that loop at the special character check looks pretty painful. A -- Andrew Sullivan | ajs@xxxxxxxxxxxxxxx The fact that technology doesn't work is no bar to success in the marketplace. --Philip Greenspun ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
