Re: [GENERAL] cast problem 8.3.1

2008-03-21 Thread Steve Clark
Charles Simard wrote: |> |> 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 |> , s

Re: [GENERAL] cast problem 8.3.1

2008-03-20 Thread Charles Simard
|> |> 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

Re: [GENERAL] cast problem 8.3.1

2008-03-20 Thread Rodrigo Gonzalez
Steve Clark escribió: Hello List, I can't seem to figure out what is this code that worked on 7.4.x. I've added cast to everything but still get: postgres error log: ERROR: operator does not exist: text = integer HINT: No operator matches the given name and argument type(s). You might need