/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

2 votes362 views1 answer
Sqlite3 show columns name
SQL
-1 vote337 views1 answer
Django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.8.0.
SQL
0 vote358 views1 answer
Get first 3 letter of department name in sql
SQL
0 vote340 views1 answer
Comma seperated join mssql
SQL
1 vote353 views3 answers
Drop unique key constraint in sql server
SQL
2 votes398 views2 answers
Mysql compare datetime to another datetime
SQL
0 vote377 views1 answer
C# mysql data reader from two tables
SQL
1 vote360 views1 answer
Postgresql pass array in function
SQL
0 vote338 views1 answer
Oracle search in date columns
SQL
0 vote382 views1 answer
Is not numeric sql
SQL