Re: Executing dynamic procedure call

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