/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 vote204 views1 answer
Add mysql database to power bi web
SQL
12 votes183 views1 answer
Docker mysql random root password
SQL
0 vote178 views1 answer
Mssql describe stored procedure sqlcmd
SQL
0 vote202 views1 answer
Oracle 11g forget password
SQL
1 vote182 views1 answer
Oracle finding duplicate records
SQL
0 vote181 views1 answer
How get data from database if id not found then search another column
SQL
0 vote185 views1 answer
Query to remove duplicate rows from a table
SQL
1 vote184 views1 answer
Rermove categories woocommerce sql
SQL
0 vote190 views1 answer
Postgres data location
SQL
1 vote184 views1 answer
Alter add syntax
SQL