/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 vote282 views1 answer
Change redo log file size in mysql 5.6
SQL
-1 vote304 views3 answers
Error: mysql shutdown unexpectedly.
SQL
0 vote330 views1 answer
Mysql streaming example
SQL
0 vote294 views1 answer
Sql server information_schema temp tables
SQL
49 votes363 views6 answers
Install mysql ubuntu
SQL
3 votes281 views3 answers
List columns in table postgres
SQL
27 votes286 views6 answers
Sql update record
SQL
1 vote272 views1 answer
Mysql show long running queries
SQL
1 vote288 views1 answer
Convert epoch to date in sql server
SQL
0 vote274 views1 answer
Add colum date in sql
SQL