Re: Broken acos in PL/PGSQL?

Seems to work fine here

oss=> select acos(1);
 acos
------
    0
(1 row)

oss=> create function stest(integer) returns integer as '
oss'> declare
oss'>  _num alias for $1;
oss'> begin
oss'>  return acos(_num);
oss'> end;' language 'plpgsql';
CREATE
oss=> select stest(1);
 stest
-------
     0
(1 row)

Version information

oss=> select version();
                           version
-------------------------------------------------------------
 PostgreSQL 7.2.1 on i686-pc-linux-gnu, compiled by GCC 2.96
(1 row)

What version are you running???



On Mon, 5 Aug 2002, pgsql-gen Newsgroup wrote:

> Subject: [GENERAL] Broken acos in PL/PGSQL?
> From: Milo Hyson <milo@cyberlifelabs.com>
>  ===
> I just ran into a show stopper exception on one of my systems. It seems the
> acos() function in PL/PGSQL throws an exception if it's called with a 1. All
> other acos() implementations I've ever used return a zero. I did some poking
> around and every acos() reference I could find for other software returns a
> zero. Is Postgres' implementation intentional or an oversight? In the context
> of my application, zero is the correct value to return in this case.
>
>

--
Darren Ferguson