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