/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 vote319 views2 answers
Grab part of a string sql
SQL
0 vote292 views1 answer
CALCULATING MONTHS BETWEEN TWO DATES IN POSTGRESQL
SQL
7 votes301 views2 answers
Html to react converter
SQL
0 vote302 views1 answer
Alter rename command in mysql
SQL
0 vote304 views1 answer
Query to remove duplicate rows from a table
SQL
0 vote279 views1 answer
Sql examples from your work
SQL
1 vote280 views1 answer
Stop mysql server mac
SQL
5 votes300 views2 answers
Oracle apex debug mode
SQL
0 vote307 views1 answer
Oracle query to find schema you are working on
SQL
0 vote270 views1 answer
Is not null postgresql
SQL