在postgresql下使用PL/pgSQL建立函数的问题!!
本人配置为:
WIN2000PRO
postgresql 7.2
下建立
CREATE FUNCTION kkk() RETURNS INTEGER AS '
BEGIN
RETURN 99;
END;
' LANGUAGE 'plpgsql';
提示
ERROR: Unrecognized language specified in a CREATE FUNCTION: 'plpgsql'.
Pre-installed languages are SQL, C, and internal.
Additional languages may be installed using 'createlang'.
ERROR: Unrecognized language specified in a CREATE FUNCTION: 'plpgsql'.
Pre-installed languages are SQL, C, and internal.
Additional languages may be installed using 'createlang'.
那该如何处理?
应该是用CREATE LANGUAGE新建plpgsql语言
现希望可以给出详细操作过程.
这里先谢过了!!
问题点数：100、回复次数：1Top
1 楼sunthing（重出江湖）回复于 2003-12-05 15:50:43 得分 100
CREATE FUNCTION plpgsql_call_handler () RETURNS LANGUAGE_HANDLER AS
'$libdir/plpgsql' LANGUAGE C;
CREATE TRUSTED PROCEDURAL LANGUAGE 'plpgsql'
HANDLER plpgsql_call_handler
LANCOMPILER 'PL/pgSQL';Top
