CURRENT INDICATOR

CURRENT INDICATOR COLUMN

CREATE OR REPLACE PROCEDURE uplata_za_aranzman(NUMERIC,NUMERIC)
LANGUAGE plpgsql
AS $$
BEGIN
    UPDATE rezervacija
    SET placeno ='da'
    WHERE korisnik_id=$2 AND aranzman_id=$1;
END;
$$;

CREATE OR REPLACE FUNCTION up_za_aranz()
RETURNS TRIGGER AS
$$
BEGIN
    CALL uplata_za_aranzman (
        NEW.aranzman_id,
       NEW.korisnik_id
    );
END;
$$
LANGUAGE 'plpgsql'



CREATE TRIGGER up_za_aranz_trigger
AFTER INSERT ON uplata
FOR EACH ROW
EXECUTE PROCEDURE up_za_aranz();