Re: plpgsql doesn't check a number of expressions and number of target variables correctly

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: plpgsql doesn't check a number of expressions and number of target variables correctly
Дата
Msg-id 24904.1330976177@sss.pgh.pa.us
обсуждение исходный текст
Ответ на plpgsql doesn't check a number of expressions and number of target variables correctly  (Pavel Stehule <pavel.stehule@gmail.com>)
Ответы Re: plpgsql doesn't check a number of expressions and number of target variables correctly
Список pgsql-bugs
Pavel Stehule <pavel.stehule@gmail.com> writes:
> Hello
> I found a plpgsql bug:

> create or replace function fx()
> returns void as $$
> declare a int; b int;
> begin
>   select 10,20 into a;
> end;
> $$ language plpgsql;

> this is bug, or minimally potential source of strange behave.

AFAICS this is intentional --- see the comment in exec_move_row.

In any case, I think tightening it up is more likely to break working
applications than do anything helpful.

            regards, tom lane

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