Re: setting local variable - Mailing list pgsql-general

From Raymond O'Donnell
Subject Re: setting local variable
Date
Msg-id 4DB46537.4060406@iol.ie
Whole thread Raw
In response to Re: setting local variable  (Elliott Prechter <elliottp@privatefundmgt.com>)
List pgsql-general
On 23/04/2011 23:54, Elliott Prechter wrote:
> 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.

What language are you using?

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie

pgsql-general by date:

Previous
From: Elliott Prechter
Date:
Subject: Re: setting local variable
Next
From: Adrian Klaver
Date:
Subject: Re: setting local variable