On Tue, Oct 25, 2005 at 11:20:53AM +0300, Andrus wrote: > This regex allows email addresses containing two dots without any letters, > like eeta..soft@xxxxxxxxx > I havent seen any email of such kind. That's because the regular expression is wrong: it simply checks the local part for zero or more non-@ characters instead of checking against the RFC822/RFC2822 specification. Use a search engine to find a more complete regular expression (beware: it's long). -- Michael Fuhr ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match