Re: ERROR: language "plpgsql" does not exist

Hello Michael,

It seems that you haven't installed the 'plpgsql' language.

To do this, type 'createlang plpgsql your-database' under the shell prompt,
then 'plpgsql' language support is added to the database specified.

Frankie

"Michael" <mshi(at)cityxpress(dot)com> glsD:b0pra1$66l$1(at)news(dot)hub(dot)org(dot)(dot)(dot)
> I just installed the PostgreSQL7.3.1 on a linux server and trying to
create
> a function .
>
> I got the
> ERROR: language "plpgsql" does not exist
>
> Why? How can I solve this ?
>
> -- script
> CREATE FUNCTION sales_tax(INTEGER) RETURNS REAL AS
> '
> DECLARE
> subtotal ALIAS FOR $1;
> BEGIN
> return subtotal * 0.06;
> END;
> ' Language 'plpgsql';
>
>
> --
> -
> Best Regards
>
> /'"`\ zzzZ |
> ( - - ) |
> ---oooO--(_)--Oooo-----------------------------------------------------
> Life Is A Journey, Enjoy The Ride.
> **********************************************************************
> Michael Shi Database Developer
>
>
>
>
>