Problem with PL/pgSQL

From: Hans-Jürgen Schönig <hs(at)cybertec(dot)at>
To: pgsql-general(at)postgresql(dot)org
Subject: Problem with PL/pgSQL
Date: 2001-02-24 15:01:59
Message-ID: 3A97CCE7.E28F207A@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Doug McNaught 2001-02-24 17:11:51 Re: PostgreSQL packages for Debian potato
Previous Message J.H.M. Dassen Ray 2001-02-24 13:57:58 Re: PostgreSQL packages for Debian potato