Re: BUG #14184: Function is running correct but not showing output

On Mon, Jun 13, 2016 at 8:40 AM,  <zzia88@gmail.com> wrote:

> -----<<<<<<My function Coding>>>>----
> CREATE OR REPLACE FUNCTION FACTORIAL(IN NUM BIGINT,OUT FACT BIGINT) AS $$
> DECLARE
>         FACT BIGINT;
>  BEGIN
>         FOR I IN REVERSE 1..NUM LOOP
>                 FACT:=FACT*I;
>         END LOOP;
> END;
> $$ LANGUAGE plpgsql;
> -----<<<<<<<<<<<<>>>>>>>>>>>>>-----
> SELECT* FROM FACTORIAL(5);
>
> IT SHOWING NULL VALUE...

FACT is NULL on declaration.  NULL (unknown) multiplied by anything is NULL.

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company