Re: setting local variable

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: setting local variable
Дата
Msg-id 17828.1303680189@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: setting local variable  (Elliott Prechter <elliottp@privatefundmgt.com>)
Список pgsql-general
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

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Extract (Recover) data from a cluster built on a different architecture (ARM).
Следующее
От: John R Pierce
Дата:
Сообщение: Re: Need to replace SAN, best method with least downtime? (8.4.4)