Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hRq5e-0004ed-Ev for pgsql-sql@arkaria.postgresql.org; Sat, 18 May 2019 03:32:54 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hRq4e-0006U3-0k for pgsql-sql@arkaria.postgresql.org; Sat, 18 May 2019 03:31:52 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hRq4d-0006Tw-9y for pgsql-sql@lists.postgresql.org; Sat, 18 May 2019 03:31:51 +0000 Received: from sonic311-20.consmr.mail.bf2.yahoo.com ([74.6.131.194]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hRq4T-0003Gf-QW for pgsql-sql@lists.postgresql.org; Sat, 18 May 2019 03:31:49 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=swbell.net; s=s2048; t=1558150297; bh=bZDwuLbiNrQod1f2ggUkrO2DQ2YeC+4QKipeaYOvbj0=; h=Subject:To:Cc:References:From:Date:In-Reply-To:From:Subject; b=md4yDbO2Sb+u7VmvZK3Uq6DUMOE0j3oRxBkbQS3GIxnFKTiAvekwC/QI6A/50ShVEgHHbYk1EPT5i4XG0PwLyt/KjxRpgaOmIUEM/DdKhN7MAwIRa4n5jd2Ngqkmg8aw3HiRWrlyAi0UAi7yn3jHDardjSJDmA7QUIi20GNSrP/sl0i1WxU/NS2O+LBr3deuqCm2KcWn33ZE3ysKP6nYuWNenqZC6BVD3/WjmRMU3xKpcz8rOagZZIBpiI4/OF5qolkaG8W/4APARfVLD51b0q+aGp8Dt7Wx1s0+xNk41X70+6LRSCyleh7Hk+vvc1Gfx6tyWUMXFnCfppyJl7hRxw== X-YMail-OSG: 2z7WmOgVM1kTGXq8jrCbtiHi9nclKAR3.5pYZyJvYWom.HlD3AAJFwngy5g9JV1 BSAO0XdwTROALOBH9zVSZ4cnQWVAq_UVkaIOrbMtPrVG_zz1gapYuT2UH8Ylk2UpkaqByGZ2Uw96 y6QnVaozEv5wQWnNfQDDPhSBI0uwHfn_Fukhqdes957leHc7lVYGqY81DiyY9vrREf5Bi6hmg0Rx vLsEUpdmHQ2KyWGoYvTC3Fk5hNjWhKyNCxAqLs_FsbC_kTPxRx8425dr8Y5fOidi.f0GHBgZTG6S TTdl_Tuoq70SAjejktWszI_eqZATJVJ1wAJoEN6tNTmEyxVMfNEhnklKcbt7OxW1Vwro12Esw8T0 a5Q8mlh.F8CM14WWyuD1.Qliyt3EoaAUuDLrDojN2xm87OYkSgA0gJEEqmQc7xLNjaGazvpLcqe7 yr0p4Xl0o45Fsk_s4HDeHa6bvNoEDkqLjF06iaps0sPoleuClzdIlUEi27TTRQ3zNzpQo4TrZ9Eh hLV5sXZdiK0x9999hi8qhDG5p2uKTkNO3PTpXe2ooNNMeHduThQ_ySpa0I0jLyzyoUZB1f4vnPm4 sIvEpQe23HXVi021etFgLf47ljZatjakcZZv9qnIKpeSgASRcian9AXlubZDZDR6ASLWYur_KDRi hTYP8nzxT11Vs3FuWhNnrPhdj64jq.QeXYouKGQtu6qd8Wt_n8tmKzBVmICPk1eoUfgM4BdJiMkL lBa6wKjonlfdhVvCFf492thIGtmTMrMymRGpi.PJL7Rc0BHIVFzOrZhpuAsC92Aasym9Q3cDLk_m _.uuvZe.sh1iHgE_YpyoMbJXR0_i4BoHktGitI972Qzm3PJc9REinND7Z261oJ2UN4qC58nqua_X UZSKZBZo2i.qtK.JnHewufjHbPKHitEjFilUPYGlundJ3qjBqyYN6E.rMc0yIqsGyVXOGYpEWmC3 yusUp5JyVtrmjtzCd9j9LmQAQtlfXL587XSbfZNNLIlTlXPiYGJPOgNP41FwD1zi1T_MlPX0radN rSK1E22ivLlVawOBSdZm3LpyGVHNYdbqjwwdIh1s881Cq2dzocOKOKKKl3SCkzQKl539kdUwHLsv 9ipwcEjwlPUOlR8aC_.OZ.Nrnu.uhDsTdTwyDNn_WRvJHn3RYhh20E30C2q0fBA4bC_ccbUrsedP q06ibxM2CnDQ3cqe5rYaM9mBUKqDjXEozbKtMW3uxsXBX3i8Lu7PqwdnDCcPVHA5sjS7VBrAPq2l w37giifx2WkTbeA-- Received: from sonic.gate.mail.ne1.yahoo.com by sonic311.consmr.mail.bf2.yahoo.com with HTTP; Sat, 18 May 2019 03:31:37 +0000 Received: from adsl-75-19-2-17.dsl.irvnca.sbcglobal.net (EHLO [192.168.1.69]) ([75.19.2.17]) by smtp425.mail.bf1.yahoo.com (Oath Hermes SMTP Server) with ESMTPA ID 7b8a0259683a7de48e3cb7b84662a91f; Sat, 18 May 2019 03:31:34 +0000 (UTC) Subject: Re: Problem in To: Javin Paul , Max Lipsky Cc: Tom Lane , pgsql-sql@lists.postgresql.org References: <2164C531-EAA3-4CAF-996F-FEB0E5F73B32@gmail.com> <26108.1556211406@sss.pgh.pa.us> <32A34C31-946E-4946-8CD1-DB36F70160ED@gmail.com> From: Charles Sheridan Message-ID: <650b8237-2266-9faf-6927-139340d28c2e@swbell.net> Date: Fri, 17 May 2019 22:31:33 -0500 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.13; rv:60.0) Gecko/20100101 Thunderbird/60.6.1 MIME-Version: 1.0 In-Reply-To: Content-Type: multipart/alternative; boundary="------------01BE3DAD6805617D1B551411" Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is a multi-part message in MIME format. --------------01BE3DAD6805617D1B551411 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit 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 > 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 > > wrote: >> >> Max Lipsky > 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 --------------01BE3DAD6805617D1B551411 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 8bit
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 <maxlipsky@gmail.com> wrote:
Hello Tom!

I think is too much for roundoff error

Found funny post about it:



On 25 Apr 2019, at 19:56, Tom Lane <tgl@sss.pgh.pa.us> wrote:

Max Lipsky <maxlipsky@gmail.com> 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



--


--------------01BE3DAD6805617D1B551411--