/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 vote117 views2 answers
Csv into data postgres
SQL
0 vote129 views1 answer
Mysql best varchar length size
SQL
4 votes116 views1 answer
Sql delete where in select
SQL
4 votes120 views1 answer
Id primary key auto generated
SQL
4 votes114 views2 answers
Host '192.168.43.100' is not allowed to connect to this MySQL server
SQL
0 vote115 views1 answer
Sql column as header
SQL
0 vote133 views1 answer
Selecting Multiple Columns in SQL
SQL
3 votes115 views2 answers
Mysql create database
SQL
5 votes104 views2 answers
Create table
SQL
0 vote107 views1 answer
Mariadb datetime change to microseconds
SQL