From: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Cc: | Elliott Prechter <elliottp(at)privatefundmgt(dot)com> |
Subject: | Re: setting local variable |
Date: | 2011-04-24 18:01:21 |
Message-ID: | 201104241101.21819.adrian.klaver@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Saturday, April 23, 2011 3:54:05 pm 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 are you trying to set _object to, the id value of the inserted row?
>
> Thanks!
> Elliott
--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Gabriele Bartolini | 2011-04-24 18:17:08 | Re: Need to replace SAN, best method with least downtime? (8.4.4) |
Previous Message | Raymond O'Donnell | 2011-04-24 18:00:23 | Re: setting local variable |