/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

4 votes132 views1 answer
Postgres delete last row
SQL
0 vote144 views1 answer
How to create a new db from dumb file mysql
SQL
6 votes139 views3 answers
What is where in sql
SQL
0 vote135 views1 answer
How to take sum of column with same id in "JPQL?"
SQL
0 vote137 views1 answer
SQL server datetime compare
SQL
0 vote121 views1 answer
Sqldf change user
SQL
0 vote128 views2 answers
Add colum in sql
SQL
8 votes127 views3 answers
Alter user root mysql
SQL
0 vote132 views1 answer
Max mysql
SQL
0 vote131 views1 answer
Cast as decimal postgresql
SQL