Bases de données pour les organisations
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';
—
Par GF 2021