/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 vote335 views1 answer
Sql server rtrim everything after character
SQL
1 vote302 views1 answer
Convert rows to string sql server
SQL
0 vote323 views1 answer
Returning with sqlalchemy
SQL
0 vote325 views1 answer
Sql delete from with relation
SQL
1 vote340 views1 answer
Sql server delete top 1000
SQL
20 votes300 views2 answers
Mysql bigint max value
SQL
-1 vote303 views1 answer
Io
SQL
0 vote353 views1 answer
Select the date 30 days less that the todays date sql request
SQL
0 vote302 views1 answer
Ffeathers express mysql application users login
SQL
2 votes290 views1 answer
Convert series number to date in sql
SQL