Problem in

11 messages
Open this post in threaded view
|

Problem in

Open this post in threaded view
|

Re: Problem in

 Max Lipsky <[hidden email]> 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
Open this post in threaded view
|

Re: Problem in

Open this post in threaded view
|

Re: Problem in

 Max Lipsky <[hidden email]> writes: > I think is too much for roundoff error The error in this example is one unit-in-the-last-place of a standard IEEE double, if I did the math correctly, so it couldn't be any smaller without being exact.                         regards, tom lane
Open this post in threaded view
|

Re: Problem in

Open this post in threaded view
|

Re: Problem in

Open this post in threaded view
|

Re: Problem in

Open this post in threaded view
|

Re: Problem in

Open this post in threaded view
|

Re: Problem in

Open this post in threaded view
|

Unsubscribing from list (was: Problem in

 On Fri, 17 May 2019 22:31:33 -0500, Charles Sheridan <[hidden email]> wrote abour Re: Problem in: > 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. In your mail headers you will see a line that looks like this: List-Unsubscribe: Follow the hypertext link and you can detach from the list. -- Regards, Dave  [RLU #314465] *-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-* [hidden email] (David W Noon) *-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*
Open this post in threaded view
|

Re: Unsubscribing from list (was: Problem in

 On Sat, 18 May 2019 16:33:13 +0100, David W Noon <[hidden email]> wrote abour Unsubscribing from list (was: Problem in: [snip] >>> I want to unsubscribe from this group, can anyone please guide? Sorry >>> for the trouble. > > In your mail headers you will see a line that looks like this: > > List-Unsubscribe: > > > Follow the hypertext link and you can detach from the list. Note that you are required to use the header line in *your* messages, not the ones in my messages. Somebody has tried to unsubscribe me from the list. -- Regards, Dave  [RLU #314465] *-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-* [hidden email] (David W Noon) *-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*