/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

1 vote122 views1 answer
Add time to date sql
SQL
0 vote98 views1 answer
Deny select insert update delete sql
SQL
0 vote99 views1 answer
Postgresql extract hour and minutes from timestamp
SQL
0 vote100 views1 answer
Order by ip address sql
SQL
39 votes171 views4 answers
Select duplicates in sql
SQL
0 vote101 views1 answer
Mysql case when null
SQL
1 vote108 views1 answer
Oracle list datafiles in tablespace
SQL
0 vote124 views1 answer
Postgres get database encoding
SQL
3 votes55 views2 answers
Mysql sum with condition
SQL
0 vote116 views1 answer
Mysql drop vs delete
SQL