"Jasbinder Singh Bali" <jsbali@xxxxxxxxx> writes: > I run this function using > select sp_insert_tbl_vrfy_mx(55,'jas','xyz.com','192.168.0.105', ' > mail.xyz.com,'mxrecoredmxjdlkfjdk') > and get the following error:- > CONTEXT: SQL statement "SELECT $1 =' '" > PL/pgSQL function "sp_insert_tbl_vrfy_mx" line 12 at if You didn't show us the actual error message, but I suppose it's unhappy that ' ' is not a legal inet value. regards, tom lane
