Re: setting local variable

Elliott Prechter <elliottp(at)privatefundmgt(dot)com> writes:
> 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 ....'

In plpgsql it's just "variable := value", no SET keyword. However,
you've got more problems than that: INSERT doesn't return a value.
It's not at all clear what you expect that to do.

regards, tom lane