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

0 vote155 views1 answer
Select insert new table sql server
SQL
2 votes132 views1 answer
Error Code: 1055. Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column \\ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
0 vote185 views1 answer
SHOW RESULT WITHOUT ROUND IN SQL
SQL
0 vote150 views1 answer
Sql list dates between two dates
SQL
0 vote154 views1 answer
Mysql workbench not showing schemas
SQL
15 votes158 views6 answers
Laravel db transaction
SQL
3 votes162 views2 answers
How to open postgresql in windows
SQL
0 vote144 views1 answer
T-sql update table variale
SQL
2 votes133 views2 answers
Function in sql
SQL
5 votes152 views2 answers
Sql constraint check value in list
SQL