<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.