hello...
i've the following problem, but i don't know how to solve it.
the following table structure exists
create table ttest
(
id int4 NOT NULL,
description text,
modtime timestamp default CURRENT_TIMESTAMP,
);
CREATE TRIGGER trg_ttest_modtime
BEFORE INSERT OR UPDATE
ON ttest
FOR EACH ROW
EXECUTE PROCEDURE fnc_modtime();
CREATE FUNCTION fnc_modtime() RETURNS opaque AS'
BEGIN
new.modtime=now();
RETURN new;
END;
'LANGUAGE 'plpgsql';
what can i do ?!
