Re: BUG #4533: Plpgsql complex type failure

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #4533: Plpgsql complex type failure
Дата
Msg-id 29530.1227380230@sss.pgh.pa.us
обсуждение исходный текст
Ответ на BUG #4533: Plpgsql complex type failure  ("Rod Taylor" <rod.taylor@gmail.com>)
Список pgsql-bugs
"Rod Taylor" <rod.taylor@gmail.com> writes:
> That was the short form exhibiting the bug. Selecting the complex
> column from a table into a value results in the same error.

Well, you could do "SELECT t.* INTO v_time".  The fundamental point here
is that when the INTO target is a rowtype variable, plpgsql expects to
assign the columns of the SELECT result to the fields of the variable.
We can't change that without breaking enormous amounts of existing code.

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #4533: Plpgsql complex type failure
Следующее
От: Gregory Stark
Дата:
Сообщение: Re: could not read block 77 of relation 1663/16385/388818775