Re: [BUGS] MD5 checksum or RPM for PostgreSQL 8.7.3

2009-04-05 Thread Devrim GÜNDÜZ
On Fri, 2009-04-03 at 11:31 -0500, P. Scott Hill wrote: > Sorry for the confusion and ambiguity of the request. The files we > are > requesting the MD5 checksum for are located here: > http://www.postgresql.org/ftp/binary/v8.3.7/linux/rpms/redhat/rhel-4-i386/ I'm not that much willing to push

[BUGS] BUG #4749: trigonometric functions broken

2009-04-05 Thread Stefano Salvador
The following bug has been logged online: Bug reference: 4749 Logged by: Stefano Salvador Email address: stefano.salva...@gmail.com PostgreSQL version: 8.3.7 Operating system: Linux Description:trigonometric functions broken Details: try: select sin(pi()); retu

Re: [BUGS] BUG #4749: trigonometric functions broken

2009-04-05 Thread Peter Eisentraut
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 ro

Re: [BUGS] BUG #4749: trigonometric functions broken

2009-04-05 Thread Euler Taveira de Oliveira
Stefano Salvador escreveu: >select sin(pi()); > > returns: 1.2246 > euler=# select sin(pi()); sin -- 1.22460635382238e-16 ^ It works for me. You didn't pay attention at the precision. -- Euler Taveira de Oliveira http://www.timbira.co