"Jasbinder Singh Bali" <[EMAIL PROTECTED]> 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

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Reply via email to