/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 vote199 views1 answer
Mysql with
SQL
0 vote250 views1 answer
View to table
SQL
0 vote205 views1 answer
6)selects only the DISTINCT values from the "side" column in the "Reserves" table
SQL
0 vote208 views2 answers
Temp tables in sql server
SQL
-1 vote205 views1 answer
How to create foreign key in sql server management studio
SQL
1 vote206 views1 answer
Install postgresql on raspberry pi
SQL
0 vote255 views1 answer
Postgres foreign key multiple columns
SQL
28 votes199 views4 answers
Show tables mysql
SQL
1 vote205 views1 answer
Postgresql must appear in the group by clause or be used in an aggregate function
SQL
2 votes202 views1 answer
Alter table add column and foreign key mysql
SQL