pg_catalog.pg_proc procedure has correct proargnames array, but proargtypes is empty - Mailing list pgsql-bugs

From Walker Philips
Subject pg_catalog.pg_proc procedure has correct proargnames array, but proargtypes is empty
Date
Msg-id CAFssDw=Hs5i1VNAaafNdDdvMNCF0gh7f4x=D-Of1eUJDhGin5A@mail.gmail.com
Whole thread Raw
Responses Re: pg_catalog.pg_proc procedure has correct proargnames array, but proargtypes is empty  (David Rowley <dgrowleyml@gmail.com>)
Re: pg_catalog.pg_proc procedure has correct proargnames array, but proargtypes is empty  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
The following function's metadata is not correctly reported in the pg_proc table (see picture below).

CREATE OR REPLACE FUNCTION scm.get_period_type_adjustment(period_type_id integer)
 RETURNS numeric
 LANGUAGE plpgsql
 IMMUTABLE
AS $function$
------
begin
return (case
when period_type_id in (1) then 1.0
when period_type_id in (2, 17, 4, 3) then 0.25
when period_type_id = 10 then 0.5
else 1
end)::numeric;
end;
$function$
;

image.png


--
Walker Philips
Data Engineering Consultant
Saguaro Capital Management
Attachment

pgsql-bugs by date:

Previous
From: Andres Freund
Date:
Subject: Re: Makefile.global will override configure parameters if "pgsql" and "postgres" appear anywhere in the source path name
Next
From: David Rowley
Date:
Subject: Re: pg_catalog.pg_proc procedure has correct proargnames array, but proargtypes is empty