Hi there,
i'm using the following trigger function to update a timestamp of a row when
it is UPDATEd:
CREATE OR REPLACE modified_trigger() RETURNS opaque AS $$
BEGIN
NEW.modify_timestamp := now();
END;
$$ LANGUAGE SQL;
Since i like to use the same trigger for various tables, i'm plan
Alex Mayrhofer wrote:
Hi there,
i'm planning to use the following trigger function to update a timestamp
of a row when it is UPDATEd:
CREATE OR REPLACE modified_trigger() RETURNS opaque AS $$
BEGIN
NEW.modify_timestamp := now();
END;
$$ LANGUAGE SQL;
I don't think you can write a t
Hi there,
i'm planning to use the following trigger function to update a timestamp of
a row when it is UPDATEd:
CREATE OR REPLACE modified_trigger() RETURNS opaque AS $$
BEGIN
NEW.modify_timestamp := now();
END;
$$ LANGUAGE SQL;
Since i like to use the same trigger procedure for vari
