Re: cast problem 8.3.1

<snip>
|>
|> postgres error log:
|> ERROR:  operator does not exist: text = integer
|> HINT:  No operator matches the given name and argument type(s). You
|> might need to add explicit type casts.
|> STATEMENT:  update T_MON_DEVICE_STATUS set device_ip  =  $1  :: inet
|>   , status  =  $2  :: integer  , status_date  = now () ,
|> last_event_log_no  = case  $3  when 0 then null else  $4  :: integer
|> end  where unit_serial_no =  $5  :: text   and device_name =
|>  $6  :: text
|>
</snip>

You're not casting your $3.