Breaking News: Grepper is joining You.com. Read the official announcement!

update trigger

Zarden answered on December 27, 2021 Popularity 9/10 Helpfulness 3/10

answer update trigger

update trigger

Comment

/*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*/

Popularity 9/10 Helpfulness 3/10 Language sql

Source: Grepper

Tags: sql

Link to this answer
Share Copy Link

Contributed on Dec 27 2021

Zarden

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

update trigger

Contents

More Related Answers

update trigger

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.