"Mitch Vincent" <mitch@venux.net> writes:
> ERROR: Unable to identify an operator '=' for types 'numeric' and 'float8'
> You will have to retype this query using an explicit cast
> --- amount and total are both numeric(9,2),
Hm, then "(total - NEW.amount) = 0.00::numeric" should work, although
I don't see why you don't just write it as "total = NEW.amount".
regards, tom lane