/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 vote200 views1 answer
Sql server python connection
SQL
0 vote171 views1 answer
Mariadb mysql root access denied
SQL
1 vote288 views1 answer
How to select department from table
SQL
18 votes202 views6 answers
Laravel form validation
SQL
1 vote168 views1 answer
Mariadb alter user host
SQL
1 vote203 views2 answers
Copy table in sql
SQL
25 votes192 views6 answers
How to change column name in mysql
SQL
0 vote174 views1 answer
List all indexes postgres
SQL
0 vote196 views1 answer
Influxdb list all tags for a measurement
SQL
6 votes165 views2 answers
Mysql set primary key
SQL