Thx Tom!!
Yep, I focused on all trigonometric functions take arguments and return
values of type double precision. Looking for the error I lost focus on
numeric values directly on the select and diff inner calculations.
I think best approach will be maintain double precision on trigonometric
calc
=?ISO-8859-1?Q?Daniel_V=E1zquez?= writes:
> Please can someone tell me why this behavior? Thx!!
You're confusing numeric and double precision; in particular this
calculation is *not* being done in float8, but numeric:
> # select (0.766238989559398 * 0.766238989559398 * 1 + 0.642555686986733 *
>