I have a function which looks like this:
...
declare _object bigint;
begin
set _object = insert into object (object_type,name) values
('type1','test object');
insert into ref (object,refname) values (_object,'test object reference');
end;
...
However I get a syntax error on the line 'set _object = insert ....'
I searched through the docs but don't know what I'm doing wrong.
Thanks!
Elliott
