"Jasbinder Singh Bali" <jsbali@gmail.com> 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