Postgres 12

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select version();


version


PostgreSQL 12.17 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-20), 64-bit



SELECT 1


create or replace function tx1( x numeric )
  returns numeric 
  language plpgsql
as $$
declare 
     y numeric(3,1)  = x;
begin 
    return y; 
exception 
   when others then
        raise notice 'Exception Caughr: %', squerrm; 
end;
$$; 

CREATE FUNCTION


create or replace function tx2( x numeric )
  returns numeric 
  language plpgsql
as $$
declare 
    y numeric(3,1); 
begin 
    y = x; 
    return y; 
exception 
   when others then
        raise exception  'Exception Caught: %', sqlerrm; 
end;
$$; 

CREATE FUNCTION


select tx1(1000.0) ; 

ERROR:  numeric field overflow
DETAIL:  A field with precision 3, scale 1 must round to an absolute value less than 10^2.
CONTEXT:  PL/pgSQL function tx1(numeric) line 4 during statement block local variable initialization


select tx2(1000.0) ; 

ERROR:  Exception Caught: numeric field overflow
CONTEXT:  PL/pgSQL function tx2(numeric) line 9 at RAISE