tekwiz wrote:
> Result:
>
> DBD::Pg:st execute failed: ERROR: operator does not exist: money <>
> integer
> HINT: No operator matches the given name and argument type(s). You may
> need to add explicit type casts.
> CONTEXT: SQL statement "SELECT (( $1 - $2 - $3 - $4 - $%) <> 0)"
craig=# SELECT '0'::money <> 0;
ERROR: operator does not exist: money <> integer
LINE 1: SELECT '0'::money <> 0;
^
HINT: No operator matches the given name and argument type(s). You
might need to add explicit type casts.
You are trying to compare a value of `money' data type with a value of
`integer' data type. This is intentionally not permitted. Since, in your
case, it looks like the 0 is an integer literal you should be doing:
( moneyvar1 - moneyvar2 - moneyvar3etc ) <> '0'::money;
In the longer run you might want to look into using the NUMERIC data
type instead of the MONEY type.
--
Craig Ringer