/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

1 vote174 views1 answer
How to see logical reads in sql server
SQL
3 votes195 views5 answers
Foreign keys
SQL
18 votes168 views6 answers
Creating table in MySQL
SQL
5 votes163 views2 answers
Sql number columns
SQL
0 vote172 views1 answer
Grant access on table in oracle
SQL
4 votes163 views3 answers
Mysql update with join
SQL
0 vote175 views1 answer
Recursive query herarchical data sql server
SQL
0 vote239 views1 answer
Migrations.RunSQL
SQL
-1 vote120 views1 answer
How to create script to connect to oracle database and run query
SQL
0 vote192 views1 answer
Create table split string function in sql server
SQL