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

-- 
Sent via pgsql-general mailing list (pgsql-general@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general