Re: Problem in
Charles Sheridan <[email protected]> Fri, 17 May 2019 22:31:33 -0500
| Newsgroups | gmane.comp.db.postgresql.sql |
|---|---|
| Message-ID | <[email protected]> |
Hi, me too -- have tried proscribed steps before, to no avail. Regards, Charles On 5/17/19 22:13, Javin Paul wrote: > Hello All, > > I want to unsubscribe from this group, can anyone please guide? Sorry > for the trouble. > > Regards > Javin > > On Fri, Apr 26, 2019 at 3:24 PM Max Lipsky <[email protected] > <mailto:[email protected]>> wrote: > > Hello Tom! > > I think is too much for roundoff error > > Found funny post about it: > https://randomascii.wordpress.com/2014/10/09/intel-underestimates-error-bounds-by-1-3-quintillion/ > http://notabs.org/fpuaccuracy/index.htm > > > >> On 25 Apr 2019, at 19:56, Tom Lane <[email protected] >> <mailto:[email protected]>> wrote: >> >> Max Lipsky <[email protected] <mailto:[email protected]>> writes: >>> SELECT acos( >>> cos(radians(48.9193)) >>> * cos(radians(48.9193)) >>> * cos(radians(2.5431) - radians(2.5431)) >>> + sin(radians(48.9193)) >>> * sin(radians(48.9193)) >>> ) as result; >> >>> This returned [22003] ERROR: input is out of range >> >> Not too surprising, because (at least on my machine) >> >> regression=# select cos(radians(48.9193)) >> regression-# * cos(radians(48.9193)) + >> sin(radians(48.9193)) >> regression-# * sin(radians(48.9193)); >> ?column? >> -------------------- >> 1.0000000000000002 >> (1 row) >> >> Problems of this sort are inevitable when working with >> finite-precision >> math. >> >> https://en.wikipedia.org/wiki/Round-off_error >> >> regards, tom lane > > > > -- > Thanks > Javin > http://javarevisited.blogspot.com/ > Twitter : https://twitter.com/javinpaul > blog : http://java67.blogspot.com > blog : http://savingsfunda.blogspot.com