Re: BUG #4749: trigonometric functions broken - Mailing list pgsql-bugs

On Sunday 05 April 2009 13:44:37 Stefano Salvador wrote:
>    select sin(pi());
>
> returns: 1.2246
>
> or:
>
>    select cos(pi()/2);
>
> returns: 6.123
>
> but sin and cos are limited between -1 and 1 !!!

I get

=> select sin(pi());
         sin
----------------------
 1.22460635382238e-16
(1 row)

=> select cos(pi()/2);
         cos
----------------------
 6.12303176911189e-17
(1 row)

Apparently, your interface is truncating the output.