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.