Update trigger

/*EXAMPLE OF A UPDATE FUNCTION WITH TRIGGER PLPGSQL*/

CREATE OR REPLACE FUNCTION update_aumentarpreco ()
    RETURNS TRIGGER
    LANGUAGE PLPGSQL
    AS 
    $BODY$
BEGIN
	IF OLD.ps_availqty = 2 THEN
		RETURN NULL;
	END IF;
		
    IF NEW.ps_availqty = 2 THEN
        NEW.ps_supplycost = OLD.ps_supplycost * 0.10;
        RETURN NEW;
    END IF;
	
    RETURN NEW;
END;
    $BODY$ 

CREATE TRIGGER update_aumentarpreco
    BEFORE UPDATE OF ps_availqty ON partsupp
    FOR EACH ROW
    EXECUTE PROCEDURE update_aumentarpreco ();

/*DROP TRIGGER update_aumentarpreco ON partsupp*/
/*Testing

UPDATE
    partsupp
SET
    ps_availqty = 4
WHERE
    ps_suppkey = 2*/

Similar codes

1 vote324 views2 answers
Last working day in week date function in sql
SQL
5 votes377 views2 answers
Mysql dump mysql db cli
SQL
2 votes448 views2 answers
SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' (SQL: select * from information_schema.tables where table_schema = laravel and table_name = migrations and table_type = 'BASE TABLE')
SQL
2 votes312 views1 answer
Match in sql server
SQL
1 vote319 views1 answer
Search for tables with name postgresql
SQL
27 votes355 views3 answers
Mysql show tables in database
SQL
0 vote368 views1 answer
Pl sql disable trigger
SQL
0 vote321 views1 answer
Convert sql server guid to varbinary
SQL
4 votes326 views1 answer
Oracle select first 10 rows
SQL
7 votes387 views3 answers
Sql server check if temp table exists
SQL