INF4211

Bases de données pour les organisations


Project maintained by guyfrancoeur Hosted on GitHub Pages — Theme by mattgraham

Les sequences, fonctions et gachettes (déclancheurs)

CREATE SEQUENCE SEQ_abc START WITH 100 INCREMENT BY 2 MAXVALUE 1000000 CYCLE;

SELECT nextval('SEQ_abc');

INSERT INTO abc(colb) VALUES( nextval('SEQ_abc') );

INSERT INTO abc (cola, colb) VALUES ('GUy222', 98928398);

SELECt * FROM abc;

CREATE TRIGGER tbi_abc BEFORE INSERT on abc
for each row
  execute procedure f_tbi_abc();

CREATE OR REPLACE FUNCTION f_tbi_abc() returns trigger as $$
begin
  new.colb = nextval('SEQ_abc');
  return new;
end;
$$ LANGUAGE plpgsql;

update abc set colb = 10000 where cola = 'GUy';

Modèle EA

modèele EA

Modèle ER

modèle ER — Par GF 2021