Re: [BUGS] MD5 checksum or RPM for PostgreSQL 8.7.3
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 MD5's anymore, since all RPMs are *signed* and one can check integrity with those signatures. Anyway, I added md5sums, which will appear in main FTP site in a few hours. Regards, -- Devrim GÜNDÜZ, RHCE devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org signature.asc Description: This is a digitally signed message part
[BUGS] BUG #4749: trigonometric functions broken
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()); 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. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] BUG #4749: trigonometric functions broken
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. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] BUG #4749: trigonometric functions broken
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.com/ -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
