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