Charles Simard wrote:
> <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.
>
>
thanks Charles and Rodrigo - that fixed it.
Steve