/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 vote82 views1 answer
Mysql workbench primary key
SQL
1 vote83 views1 answer
Check current sequence value postgres
SQL
0 vote75 views1 answer
Trigger value from maltiple table to single table mysql
SQL
15 votes73 views6 answers
Laravel db transaction
SQL
0 vote79 views1 answer
Select even number id data from table
SQL
8 votes79 views2 answers
Select current_timestamp - interval '3 days';
SQL
1 vote75 views1 answer
Postgres regex remove special characters
SQL
2 votes88 views1 answer
Tcl in sql
SQL
0 vote81 views1 answer
Order child below the parent in mysqli
SQL
1 vote88 views1 answer
Size of all tables in a schema oracle
SQL