"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,
Thanks!
-Mitch
- Original Message -
From: "Tom Lane" <[EMAIL PROTECTED]>
To: "Mitch Vincent" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, January 23, 2001 11:05 AM
Subject: Re: [GENERAL] Another plpgsql question..
> "Mitch Vincent&
"Mitch Vincent" <[EMAIL PROTECTED]> writes:
> is_paid is never updated...
It's not possible that is_paid is never updated; that command *will*
replace the total, updated, and is_paid columns with *something*.
It may be that in the cases you've checked, it gets updated to the
same value it had bef
