/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

3 votes152 views4 answers
Order by desc postgres
SQL
1 vote173 views1 answer
Oracle drop temporary table
SQL
1 vote168 views1 answer
Where to locate set password for mysql
SQL
0 vote169 views1 answer
Set engine to innodb
SQL
-1 vote152 views3 answers
Error mysql shutdown unexpectedly
SQL
2 votes194 views1 answer
Search query in mysql
SQL
10 votes148 views4 answers
Join with multiple conditions sql
SQL
0 vote159 views1 answer
List in one column mysql
SQL
0 vote155 views1 answer
Drop constraint in ms sql
SQL
0 vote148 views1 answer
Stuff in sql server
SQL