/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

23 votes223 views6 answers
How to create table in sql
SQL
1 vote221 views1 answer
Create new table in SQL from old table with data
SQL
0 vote214 views1 answer
Sql beginning of previous month
SQL
1 vote216 views1 answer
Base nosql
SQL
1 vote235 views1 answer
Quit mysql
SQL
5 votes231 views1 answer
Oracle nls session
SQL
1 vote225 views2 answers
Mysql allow remote connections
SQL
0 vote207 views1 answer
How to insert same table data using mysql query
SQL
3 votes203 views1 answer
Delete all content in table mysql
SQL
0 vote242 views2 answers
Get item by composite primary key mysql
SQL