/SQL/Trigger in postgresql to change incoming entry

Trigger in postgresql to change incoming entry

CREATE or REPLACE FUNCTION func()
RETURNS TRIGGER
AS $$
BEGIN
NEW.columnname = 0;
RETURN NEW;
END;
$$
LANGUAGE plpgsql;

-- Statement to make trigger to execute above code --
CREATE TRIGGER change_incoming BEFORE INSERT on Tablename 
FOR EACH ROW EXECUTE PROCEDURE func();

Similar codes

0 vote136 views1 answer
Concatenate columns in table
SQL
23 votes123 views6 answers
ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
3 votes151 views1 answer
Where id is in list sql
SQL
5 votes168 views2 answers
Mysql dump mysql db cli
SQL
0 vote162 views1 answer
Time in sql server
SQL
1 vote97 views1 answer
Database run
SQL
3 votes142 views2 answers
Oracle for loop
SQL
0 vote144 views1 answer
Rename constraint postgresql
SQL
1 vote130 views1 answer
Delete triger pl pg sql
SQL
0 vote107 views1 answer
Hangfire clean script
SQL