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 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

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());

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

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 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

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.com/

-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs