SQL state: 42601. Execption handling.
Community, is that behavior is explainable ?
create or replace function dbo.func(result out int ) as $$ begin result = 1 ; end ; $$ language plpgsql;
-- 1 --
do $$
declare
v_result int ;
begin
select p.result from dbo.func(d) p into v_result;
exception when SQLSTATE '42601' then
raise '42601' ;
when others then
raise 'others' ;
end ;
$$
--Exception is handled. This is OK.
ERROR: others
CONTEXT: PL/pgSQL function inline_code_block line 9 at RAISE
********** Error **********
ERROR: others
SQL state: P0001
Context: PL/pgSQL function inline_code_block line 9 at RAISE
-- 2 --
do $$
begin
select p.result from dbo.func() p into v_result;
exception when SQLSTATE '42601' then
raise '42601' ;
when others then
raise 'others' ;
end ;
$$
--Exception is not handled. This is the question.
ERROR: "v_result" is not a known variable
LINE 3 : select p.result from dbo.func() p into v_result;
********** Error **********
ERROR: "v_result" is not a known variable
SQL state: 42601
Character : 57
I suppose the reason of such behavior in different steps of code parsing, but can`t find any discussions or topics in documentation.
Сould someone clarify the situation for sure?