/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 vote180 views1 answer
Work around for mutating problem in Oracle Triggers. Please check it out.
SQL
0 vote191 views1 answer
Phpmyadmin mysql conflict
SQL
1 vote189 views2 answers
DROP TABLes regardless of constraints
SQL
0 vote172 views1 answer
Mariadb LOAD DATA INFILE
SQL
0 vote186 views1 answer
SQL add a totals of differemt rows of the same id
SQL
0 vote188 views1 answer
Delete record by id sql
SQL
1 vote173 views1 answer
Sql only five first row
SQL
4 votes172 views1 answer
Delete record mysql query
SQL
3 votes180 views1 answer
Postgresql db owner change
SQL
0 vote172 views1 answer
Postgres select except
SQL