On Sun, Jan 15, 2017 at 1:27 AM, Pavel Stehule
wrote:
> Hi
>
> Proposed result:
> postgres=# select foo(0, 100);
> ERROR: division by zero
> CONTEXT: PL/pgSQL function foo(double precision) line 3 at RETURN
> ARGUMENTS: a=0, b=100
>
+1 This would be useful in cases where an app calls one proce
Hi
In last discussion related to PLpgSQL was mentioned weak of stack trace
PLpgSQL. The function parameters are not printed.
CREATE OR REPLACE FUNCTION public.foo(a double precision, b double
precision)
RETURNS double precision
LANGUAGE plpgsql
AS $function$
begin
return 100/a;
end;
$function
