Create Function... ERROR: language "plpgsql" does not exist

Поиск
Список
Период
Сортировка
От Thomas LeBlanc
Тема Create Function... ERROR: language "plpgsql" does not exist
Дата
Msg-id Law9-F78SH3ZIrqTIov0000f92d@hotmail.com
обсуждение исходный текст
Ответы Re: Create Function... ERROR: language "plpgsql" does
Re: Create Function... ERROR: language "plpgsql" does
Список pgsql-general
I copied an example from the help:

CREATE FUNCTION somefunc() RETURNS integer AS '
DECLARE
    quantity integer := 30;
BEGIN
    RAISE NOTICE ''Quantity here is %'', quantity;  -- Quantity here is 30
    quantity := 50;
    --
    -- Create a subblock
    --
    DECLARE
        quantity integer := 80;
    BEGIN
        RAISE NOTICE ''Quantity here is %'', quantity;  -- Quantity here is
80
    END;

    RAISE NOTICE ''Quantity here is %'', quantity;  -- Quantity here is 50

    RETURN quantity;
END;
' LANGUAGE plpgsql


Ran it is a SQL window from pgAdmin and got this error:

ERROR:  language "plpgsql" does not exist

Thanks,
Thomas LeBlanc

_________________________________________________________________
Share your photos without swamping your Inbox.  Get Hotmail Extra Storage
today! http://join.msn.com/?PAGE=features/es


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: libreadline.so.4 problems on solaris
Следующее
От: darren@crystalballinc.com
Дата:
Сообщение: Re: Create Function... ERROR: language "plpgsql" does