/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

3 votes243 views2 answers
WhereIn SQL
SQL
0 vote261 views1 answer
Oracle create job if not exists
SQL
0 vote250 views1 answer
Jooq replace
SQL
5 votes228 views1 answer
Mongodb vs
SQL
0 vote263 views1 answer
Find usage of table in sql server
SQL
0 vote264 views3 answers
Insert query in ci
SQL
4 votes269 views2 answers
Oracle last day of month
SQL
4 votes257 views3 answers
How to describe a table in sqlite3
SQL
16 votes265 views2 answers
Add column to all tables after first column mysql
SQL
0 vote258 views2 answers
How to update date in oracle
SQL