pg_catalog.pg_proc procedure has correct proargnames array, but proargtypes is empty

Поиск
Список
Период
Сортировка
От Walker Philips
Тема pg_catalog.pg_proc procedure has correct proargnames array, but proargtypes is empty
Дата
Msg-id CAFssDw=Hs5i1VNAaafNdDdvMNCF0gh7f4x=D-Of1eUJDhGin5A@mail.gmail.com
обсуждение исходный текст
Ответы 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>)
Список 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
Вложения

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: Makefile.global will override configure parameters if "pgsql" and "postgres" appear anywhere in the source path name
Следующее
От: David Rowley
Дата:
Сообщение: Re: pg_catalog.pg_proc procedure has correct proargnames array, but proargtypes is empty