/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 vote184 views1 answer
Implizite joins sql
SQL
0 vote228 views2 answers
Mysql add days to date
SQL
0 vote193 views1 answer
Psql get table data types
SQL
0 vote196 views1 answer
Check if string is a number sql
SQL
0 vote179 views1 answer
Mysql start of today
SQL
0 vote188 views1 answer
How to get inserted id in sql server
SQL
1 vote188 views2 answers
Duplicate key value violates unique constraint "django_admin_log_pkey"
SQL
-1 vote274 views1 answer
Minus vs except in sql
SQL
0 vote173 views1 answer
Drop all tables in azure sql database
SQL
2 votes200 views1 answer
Docker run postgres locally
SQL