agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedFrom: Charles Sheridan <cesheri@swbell.net>
To: Javin Paul <savingfunda@gmail.com>
To: Max Lipsky <maxlipsky@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-sql@lists.postgresql.org
Subject: Re: Problem in
Date: Fri, 17 May 2019 22:31:33 -0500
Message-ID: <650b8237-2266-9faf-6927-139340d28c2e@swbell.net> (raw)
In-Reply-To: <CAKGadqYnnvkiiR5cJXxJW1_3=sbr-g2xy455FA=XMDMr86We_A@mail.gmail.com>
References: <2164C531-EAA3-4CAF-996F-FEB0E5F73B32@gmail.com>
<26108.1556211406@sss.pgh.pa.us>
<32A34C31-946E-4946-8CD1-DB36F70160ED@gmail.com>
<CAKGadqYnnvkiiR5cJXxJW1_3=sbr-g2xy455FA=XMDMr86We_A@mail.gmail.com>
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
> <mailto:maxlipsky@gmail.com>> 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 <tgl@sss.pgh.pa.us
>> <mailto:tgl@sss.pgh.pa.us>> wrote:
>>
>> Max Lipsky <maxlipsky@gmail.com <mailto: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
>
>
>
> --
> Thanks
> Javin
> http://javarevisited.blogspot.com/
> Twitter : https://twitter.com/javinpaul
> blog : http://java67.blogspot.com
> blog : http://savingsfunda.blogspot.com
view thread (9+ messages)
Message-ID: <650b8237-2266-9faf-6927-139340d28c2e@swbell.net>
Permalink: ../650b8237-2266-9faf-6927-139340d28c2e@swbell.net/
Also on: postgresql.org/message-id/650b8237-2266-9faf-6927-139340d28c2e@swbell.net
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: cesheri@swbell.net, savingfunda@gmail.com, maxlipsky@gmail.com, tgl@sss.pgh.pa.us, pgsql-sql@lists.postgresql.org
Subject: Re: Problem in
In-Reply-To: <650b8237-2266-9faf-6927-139340d28c2e@swbell.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox