[firebase-br] PSQL

[ibestvip]

Eu Utilizo com o set term....

SET TERM ^ ;


CREATE TRIGGER AGENDA_BI FOR AGENDA
ACTIVE BEFORE INSERT POSITION 0
AS
BEGIN
  IF (NEW.COD_AGENDA IS NULL) THEN
    NEW.COD_AGENDA = GEN_ID(GEN_AGENDA_ID,1);
END

SET TERM ; ^