postgresql 在触发器中设置默认值

Question

我在表上有一个“更新前触发器”。如何在列上设置默认值？ :

CREATE OR REPLACE FUNCTION trigger() RETURNS TRIGGER AS
$$

TD["new"]["test"] = DEFAULT # Doesn't work

$$ LANGUAGE plpython2u VOLATILE;

Answer 1

来自documentation :

... you can return None or "OK" from the Python function to indicate the row is unmodified, "SKIP" to abort the event, or [...] "MODIFY" to indicate you've modified the new row.