PL/pgsql

Поиск
Список
Период
Сортировка
От Tuttle, Gene
Тема PL/pgsql
Дата
Msg-id 199F7F755B80D511877100B0D0F0B76CC3FDE3@mail.rottlundhomes.com
обсуждение исходный текст
Список pgsql-admin
I am new to Postgresql and am having problems getting functions working.

I have been following an example in the book "PostgreSQL" by Douglas &
Douglas Published by Developers Library.
I put the  code in as a function (see end of email)


When I execute it from psql I get the following:
dev=# select my_factorial(1);
server closed the connection unexpectedly
        This probably means the server terminated abnormally
        before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.

Can any one help me find the problem.  point me in the right direction?

Thanks
Gene Tuttle




-- Function: public.my_factorial(int4)

-- DROP FUNCTION public.my_factorial(int4);

CREATE OR REPLACE FUNCTION public.my_factorial(int4)
  RETURNS int4 AS
'
  DECLARE
    arg INTEGER;
  BEGIN

    arg := $1;

    IF arg IS NULL or arg < 0 THEN
        RAISE NOTICE \'Invalid Number\';
        RETURN NULL;
    ELSE
        IF arg = 1 THEN
            RETURN 1;
        ELSE
            DECLARE
                next_value INTEGER;
            BEGIN


                next_value := my_factorial(arg - 1) * arg;
                RETURN next_value;
            END;
        END IF;
    END IF;
END;
'
  LANGUAGE 'plpgsql' VOLATILE;

В списке pgsql-admin по дате отправления:

Предыдущее
От: Guido Barosio
Дата:
Сообщение: Re: pg_dump Error
Следующее
От: Vincent van der Locht
Дата:
Сообщение: diskspace bigger after a vacuum