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 по дате отправления: