On 19.10.2005 21:18, Michael Fuhr wrote:
One possibility would be to write a plperlu function that uses the Email::Valid module. Here's a trivial example; see the Email::Valid documentation to learn about its full capabilities:
..and if you don't mind installing pl/php, you can use this function: http://hannes.imos.net/validmail.html It performs a MX-lookup, which IMHO is the best way to check for validity. -- Regards, Hannes Dorbath ---------------------------(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