Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE SCHOOL (
- ID SERIAL PRIMARY KEY,
- First_name VARCHAR(30) NOT NULL,
- Last_name VARCHAR(30) NOT NULL,
- Jurusan VARCHAR(20) NOT NULL
- );
- -----------------------------------------------------------------------------------------
- CREATE TABLE SCHOOL_CLASS (
- ID SERIAL PRIMARY KEY,
- Absen INTEGER NOT NULL,
- First_name VARCHAR(30) NOT NULL,
- Old_Jurusan VARCHAR(20) NOT NULL,
- New_Jurusan VARCHAR(20) NOT NULL
- );
- -----------------------------------------------------------------------------------------
- CREATE OR REPLACE FUNCTION Jurusan_changes()
- RETURNS TRIGGER AS
- $BODY$
- BEGIN
- IF NEW.Jurusan <> OLD.Jurusan THEN
- INSERT INTO SCHOOL_CLASS(Absen, First_name, Old_Jurusan, New_Jurusan)
- VALUES(OLD.ID, OLD.First_name, OLD.Jurusan, NEW.Jurusan);
- END IF;
- RETURN NEW;
- END;
- $BODY$
- LANGUAGE plpgsql;
- -----------------------------------------------------------------------------------------
- CREATE TRIGGER Jurusan_change
- BEFORE UPDATE
- ON SCHOOL
- FOR EACH ROW
- EXECUTE PROCEDURE Jurusan_changes();
- -----------------------------------------------------------------------------------------
- INSERT INTO SCHOOL (First_name, Last_name, Jurusan)
- VALUES ('Muhammad Dzaky', 'Bahrul Ilmi', 'IPA');
- INSERT INTO SCHOOL (First_name, Last_name, Jurusan)
- VALUES ('Muhammad Rafi', 'Bahrur Rizki', 'IPA');
- INSERT INTO SCHOOL (First_name, Last_name, Jurusan)
- VALUES ('Shafa Nurul', 'Ilyanti', 'IPA');
- -----------------------------------------------------------------------------------------
- SELECT * FROM SCHOOL;
- -----------------------------------------------------------------------------------------
- UPDATE SCHOOL
- SET Jurusan = 'Kedokteran Gigi'
- WHERE ID = 3;
- -----------------------------------------------------------------------------------------
- SELECT * FROM SCHOOL_CLASS;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement