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
r...@iol.ie

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to