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
>
>
>
>
>