Re: SQL state: 42601. Execption handling.

2022-06-07 Thread Kyotaro Horiguchi
At Tue, 07 Jun 2022 10:36:52 -0400, Tom Lane wrote in > =?UTF-8?B?0KY=?= writes: > > -- 2 -- > > do $$ > > begin > >select p.result from dbo.func() p into v_result; > > exception when SQLSTATE '42601' then > > raise '42601' ; > >when others then > > rai

Re: SQL state: 42601. Execption handling.

2022-06-07 Thread Tom Lane
=?UTF-8?B?0KY=?= writes: > -- 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 th