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
Please can someone tell me why this behavior? Thx!!
I know it's calculating over coordinates on same points, but the operations
of values (all double precision) differs even forcing with cast
(*) Here some double precision calculations and obtaining values
#Select
#
=?ISO-8859-1?Q?Daniel_V=E1zquez?= daniel2d2...@gmail.com 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 +