Re: cast problem 8.3.1

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