Re: setting local variable

Elliott Prechter <elliottp@privatefundmgt.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