/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

5 votes192 views1 answer
Ascending order and where in sql
SQL
24 votes194 views4 answers
How to add column sql
SQL
0 vote189 views1 answer
Default value false mysql
SQL
2 votes207 views1 answer
Mysql increment value by 1 in update
SQL
0 vote190 views1 answer
Oracle index hint
SQL
22 votes220 views4 answers
Date format mysql
SQL
0 vote192 views2 answers
Create sequence if not exists postgres
SQL
20 votes212 views3 answers
Update values in select statement sql
SQL
5 votes217 views4 answers
SQL Order of execution
SQL
3 votes260 views1 answer
Mysql cli connect with password
SQL