/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 vote345 views1 answer
How to set sql_mode for a query in CI model
SQL
7 votes328 views4 answers
Database dump mysql command
SQL
3 votes337 views1 answer
How to uninstall microsoft sql server
SQL
2 votes345 views1 answer
Mysql last 7 days including today
SQL
0 vote347 views1 answer
Create bdd mysql
SQL
1 vote386 views1 answer
Create email address from first and last name in sql
SQL
17 votes344 views6 answers
MySQL ORDER BY
SQL
6 votes350 views2 answers
Postgresql pg_dump
SQL
0 vote331 views1 answer
How to create a new shema using query languaage
SQL
0 vote325 views1 answer
Flask sqlalchemy decimal
SQL