/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 vote152 views2 answers
Compound operator in sql
SQL
2 votes154 views3 answers
Sql interview query questions
SQL
0 vote135 views1 answer
Sql query to check if column contains alphabets
SQL
2 votes129 views1 answer
Oracle cpu per session
SQL
0 vote123 views1 answer
List MySQL Table and Index Size
SQL
3 votes160 views5 answers
Foreign keys
SQL
0 vote149 views1 answer
T-SQL - Where Used List (Table/View)
SQL
0 vote169 views1 answer
Mysql auto increment in DD-MM-XXX format
SQL
0 vote154 views1 answer
Count database access django
SQL
16 votes133 views2 answers
Gremove folder from git
SQL