/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 vote140 views1 answer
Sql remove last x char
SQL
1 vote153 views1 answer
Mysql take number in string
SQL
0 vote158 views1 answer
Big table in mysql
SQL
0 vote193 views1 answer
Migrations.RunSQL
SQL
0 vote142 views2 answers
Sql join on wildcard
SQL
0 vote156 views1 answer
Sql character index
SQL
0 vote139 views2 answers
Django.db.utils.OperationalError: (1698, "Access denied for user 'root'@'localhost'")
SQL
5 votes171 views2 answers
Postgresql add not null constraint
SQL
1 vote156 views1 answer
Mysql change root mysql_native_password
SQL
12 votes158 views6 answers
Select distinct
SQL