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.