Postgres Pro
Downloads
Home   >   mailing lists

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

From Stefano Salvador
Subject BUG #4749: trigonometric functions broken
Date
Msg-id 200904051044.n35Aib77063835@wwwmaster.postgresql.org
Whole thread Raw
Responses Re: BUG #4749: trigonometric functions broken  (Peter Eisentraut <peter_e@gmx.net>)
Re: BUG #4749: trigonometric functions broken  (Euler Taveira de Oliveira <euler@timbira.com>)
List pgsql-bugs
Tree view 
The following bug has been logged online:

Bug reference:      4749
Logged by:          Stefano Salvador
Email address:      stefano.salvador@gmail.com
PostgreSQL version: 8.3.7
Operating system:   Linux
Description:        trigonometric functions broken
Details:

try:

   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 suspect than tan() function is broken too.

pgsql-bugs by date:

Previous
From: Devrim GÜNDÜZ
Date:
Subject: Re: MD5 checksum or RPM for PostgreSQL 8.7.3
Next
From: Peter Eisentraut
Date:
Subject: Re: BUG #4749: trigonometric functions broken