language "plpgsql" does not exist - Mailing list pgsql-sql

i am trying to create functions only to get the above error in return.
what do i need to do to get PL/PGSQL functions working?
example:

CREATE FUNCTION logfunc1(text) RETURNS timestamp AS '    DECLARE        logtxt ALIAS FOR $1;    BEGIN        INSERT
INTOlogtable VALUES (logtxt, ''now'');        RETURN ''now'';    END;
 
' LANGUAGE plpgsql;

#  ERROR:  language "plpgsql" does not exist


any help appreciated


__________________________________
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
http://search.yahoo.com


pgsql-sql by date:

Previous
From: Rod Taylor
Date:
Subject: Re: plpgsql recursion
Next
From: Alexey Dashevsky
Date:
Subject: Re: numeric fields and null