SQL

postgresql procedure example

        
            
        
     create [or replace] procedure procedure_name(parameter_list)
language plpgsql
as $$
declare
-- variable declaration
begin
-- stored procedure body
end; $$

postgres stored procedure

CREATE OR REPLACE FUNCTION public.date_submission(state varchar, created_at date, updated_at date)
 returns date
 LANGUAGE plpgsql
 IMMUTABLE
AS $function$
declare
	response date;
begin
	if (state = 'CREATED' or state = 'PENDING' or state = 'PENDING - RESUBMITTED') then 
		response = updated_at;
	else
		response = created_at;
	end if;
	return response;
end;
$function$

select date_submission('PENDING', now()::date, now()::date)