/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 vote125 views1 answer
INSERT INTO table using OpenQuery
SQL
0 vote135 views1 answer
Get primary key of table
SQL
5 votes142 views2 answers
To date oracle
SQL
8 votes123 views1 answer
Oracle add month
SQL
1 vote129 views7 answers
Filter
SQL
2 votes185 views2 answers
Create table mysql integer NOT null
SQL
0 vote130 views1 answer
Wp_query raw sql
SQL
0 vote144 views1 answer
Find duplicate users by email address in mysql
SQL
0 vote123 views3 answers
Joins and views sql
SQL
0 vote138 views1 answer
Get first 3 letter of department name in sql
SQL