Re: Problem with PL/pgSQL

Hans-Jürgen Schönig wrote:

> What is wrong with the following function?
>
> CREATE FUNCTION logfunc2 (text) RETURNS int AS '
> DECLARE
> text ALIAS FOR $1;
> BEGIN
> SELECT length(text);
> RETURN ''3'';
> END;
> ' LANGUAGE 'plpgsql';
>
> I get the following error:
>
> ERROR: Unrecognized language specified in a CREATE FUNCTION: 'plpgsql'.
>
> Recognized languages are sql, C, internal, and created
> procedural languages.
>
> According to my docs "plpgsql" should be ok.
>
> Hans

plpgsql is not installed by default.

createlang 'plpgsql'

from the command line should to the trick.