/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 votes294 views1 answer
Mysql change data type of column
SQL
1 vote320 views1 answer
Sql server if exists update else insert
SQL
0 vote314 views1 answer
<connectionStrings> <add name="MainDB" connectionString="Data Source=multidc02.its.com.pk,47328;Initial Catalog=ITSGeneralApplications;User ID=ITSGeneralAdmin;Password=TDsHn6TTyJohXCe"/> </connectionStrings>
SQL
7 votes313 views2 answers
Phpmyadmin change password
SQL
4 votes285 views2 answers
Postgresql reset sequence
SQL
0 vote322 views1 answer
Mysql backup query
SQL
8 votes289 views2 answers
Grant all privileges database postgres to user
SQL
3 votes272 views3 answers
Stop mysql service ubuntu
SQL
0 vote295 views1 answer
How to login to mysql in homestead
SQL
2 votes277 views2 answers
Mysql get time from datetime
SQL