/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 vote234 views2 answers
Suse stop MySQL
SQL
3 votes212 views2 answers
Oracle sql drop sequence
SQL
-2 votes225 views1 answer
Mysql not empty
SQL
2 votes224 views2 answers
How to rename column name in sql server using query
SQL
36 votes248 views3 answers
Add column in mysq
SQL
1 vote251 views1 answer
Date in where on datetime column clause mysql
SQL
16 votes230 views2 answers
Oracle ddl
SQL
0 vote234 views1 answer
Mysql dump everythign
SQL
0 vote221 views1 answer
Plpgsql if statement
SQL
0 vote222 views1 answer
Oracle character index
SQL