SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-09-2008, 11:22 PM
| ||||
| ||||
 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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general      |
Linear Mode
