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  (Pavel Stehule <pavel.stehule@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: BUG #6518: archive_command stderr not in log if log_destination=syslog
Следующее
От: Pavel Stehule
Дата:
Сообщение: Re: plpgsql doesn't check a number of expressions and number of target variables correctly