DECLARE 错误，帮忙看看。[已解决]

yueliangdao0608

CREATE OR REPLACE FUNCTION "public"."logfun2" () RETURNS TIMESTAMP WITH TIME ZONE AS $body$ declare   starttime TIMESTAMP; begin   starttime := CURRENT_TIMESTAMP;   return starttime; end; -- select CURRENT_TIMESTAMP; $body$ LANGUAGE 'sql' IMMUTABLE CALLED ON NULL INPUT SECURITY INVOKER;

[ 本帖最后由 yueliangdao0608 于 2008-2-4 09:59 编辑 ]

yueliangdao0608

错误：

ERROR:  syntax error at or near "TIMESTAMP" at character 116

yueliangdao0608

搞定了。

把sql 变成plpgsql就可以了。