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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
