* Bruce Young <hbrucey@yahoo.com> [23.05.2003 14:29]:
> 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 INTO logtable VALUES (logtxt, ''now'');
> RETURN ''now'';
> END;
> ' LANGUAGE plpgsql;
>
> # ERROR: language "plpgsql" does not exist
issue the following command on console (comand interpreter):
$ createlang plpgsql <dbname>
--
Victor Yegorov