As part of CORE-4403, it's possible to use the colon prefix to read cursor fields.
This ticket is to document the change for OLD/NEW fields and aissgnments to variables. This is now valid syntax:
create trigger t1 before insert on t1
as
declare v integer;
begin
:v = :old.n;
:new.n = :v;
end
Description
As part of CORE-4403, it's possible to use the colon prefix to read cursor fields.
This ticket is to document the change for OLD/NEW fields and aissgnments to variables. This is now valid syntax:
create trigger t1 before insert on t1
as
declare v integer;
begin
:v = :old.n;
:new.n = :v;
end
Improvement
Resolved
Major
Extend the use of colon prefix for read/assignment OLD/NEW fields and assignment to variables