Re: SQL state: 42601. Execption handling. - Mailing list pgsql-general

=?UTF-8?B?0KY=?= <pfunk@mail.ru> 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 the question.
> ERROR:   "v_result"   is   not  a known variable
> LINE  3 :    select  p.result  from  dbo.func() p  into  v_result;

This error is thrown by the plpgsql parser, so you can't trap it
with "exception", any more than you could trap other syntax errors
detected by the parser.  (As an extreme example, you could certainly
not trap it if you misspelled "exception".)

            regards, tom lane