The following bug has been logged online:
Bug reference: 3289
Logged by: Daniel Kastenholz
Email address: mail(at)danielkastenholz(dot)de
PostgreSQL version: 8.1, 8.2.4
Operating system: Linux, Windows
Description: SIN(PI()) expected to return 0, but returns garbage
Details:
Trouble case:
Action:
Type in SELECT SIN(PI())
Expected output:
0
Actual output:
* Windows, using 8.2.4:
garbage (-2.2......)
* Linux, using 8.1:
garbage (1.22.......)
--
Comments:
SIN(3.1414) and SIN(3.1417) come close to 0 and work on both platforms.
SIN(3.1415) and SIN(3.1416) produce the same garbage output as using PI() on
both platforms.