/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

16 votes179 views3 answers
Get count of duplicate records
SQL
0 vote173 views3 answers
Mysql regex replace
SQL
1 vote172 views1 answer
Delete dublicate rows sql
SQL
0 vote183 views1 answer
Sql remove decimal places
SQL
0 vote157 views1 answer
Windows services sql
SQL
0 vote142 views2 answers
Add new column after in sql
SQL
0 vote162 views7 answers
10 random questions use python and SQL
SQL
0 vote150 views1 answer
Mysqldump ignore table
SQL
0 vote156 views1 answer
Hibernate with springboot mysql
SQL
6 votes188 views4 answers
Mysql get random row
SQL