/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 vote86 views1 answer
Postgres delete where id in
SQL
-1 vote157 views2 answers
Sql truncate number
SQL
0 vote143 views1 answer
Mysql persistence.xml
SQL
1 vote134 views1 answer
Name of today sql
SQL
18 votes113 views3 answers
Mysql query add column with default string value
SQL
2 votes128 views2 answers
Mysqli_real_connect(): The server requested authentication method unknown to the client [caching_sha2_password]
SQL
2 votes159 views1 answer
Merge two columns in sql oracle
SQL
-1 vote129 views1 answer
Can pandas fetch data from sql
SQL
0 vote132 views1 answer
Mysql workbench not showing schemas
SQL
2 votes129 views1 answer
No data found oracle
SQL