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@cityxpress.com> ���g���l���s�D:b0pra1$66l$1@news.hub.org...
> 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
>
>
>
>
>