Re: [GENERAL] Another plpgsql question..

[Tom Lane]

"Mitch Vincent" <[EMAIL PROTECTED]> 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