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

You need to create the plpgsql language in your database first.  See
http://www.faqs.org/docs/ppbook/c19610.htm for how to do this.

Hope this helps,
chet@crashed.net

thomasatiem@hotmail.com ("Thomas LeBlanc") wrote in message news:<Law9-F78SH3ZIrqTIov0000f92d@hotmail.com>...
> 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