/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 votes367 views1 answer
SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' (SQL: select * from information_schema.tables where table_schema = whatsapp and table_name = migrations and table_type = 'BASE TABLE')
SQL
10 votes387 views4 answers
SELECT FROM WHERE
SQL
2 votes345 views2 answers
Join update query in sql
SQL
0 vote358 views1 answer
R rmysql connect local database Plugin caching_sha2_password could not be loaded
SQL
0 vote373 views1 answer
Write a query to peint the pattern P(20)
SQL
7 votes348 views3 answers
Sql get last inserted row
SQL
1 vote519 views3 answers
Uninstall postgresql mac
SQL
2 votes368 views1 answer
SQL IF ELSE
SQL
0 vote331 views1 answer
Postgresql parse json array
SQL
-1 vote350 views1 answer
Ssms connect with connection string
SQL