/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

5 votes162 views4 answers
Describe table postgres
SQL
0 vote186 views1 answer
Mysql grant all on all databases
SQL
0 vote161 views1 answer
Selects all the columns from the sailors table
SQL
4 votes134 views2 answers
Select todays data postgres query
SQL
0 vote171 views1 answer
Mysql set boolean default value
SQL
2 votes177 views1 answer
ADD COLOUNS CREATED AND UPDATED AT IN MYSQL
SQL
2 votes169 views1 answer
Oracle sql query to make column data uppercase
SQL
0 vote178 views1 answer
Postgresql check total storage
SQL
0 vote172 views1 answer
Add sqlcmd to path linux
SQL
0 vote191 views1 answer
How to create notes in mysql
SQL