/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

2 votes295 views1 answer
Apex date today add days
SQL
0 vote325 views1 answer
Top 3 salary in sql
SQL
0 vote296 views3 answers
Between keyword sql
SQL
5 votes341 views2 answers
Mysql dump mysql db cli
SQL
2 votes301 views1 answer
Oracle sql concatenate results into string
SQL
0 vote334 views1 answer
Mysql record group by created date count
SQL
0 vote311 views1 answer
How to tell if i have lactose intolerance
SQL
0 vote330 views4 answers
Sql rownum
SQL
1 vote317 views1 answer
Postgres cast as currency format
SQL
0 vote307 views1 answer
Django mssql backend
SQL