clean_cron jsonb;

Ninteger;

nametext;

updatePrevboolean;

updatePrev := true;

IF NOT params?'cron'AND NOT params?'rule'AND NOT params?'date'AND NOT params?'dates' THEN

RAISE EXCEPTION'There is no information about job''s schedule'

USING HINT='Use''cron'' - cron string,''rule'' - json to set schedule rules or''date'' and''dates'' to set exact date(s)';

EXECUTE'SELECT cron2jsontext($1::cstring)::jsonb'

INTO cron

USING params->>'cron';

IF prevIS NOT NULL THEN

cron := prev|| cron;

END IF;

END IF;

IF params?'rule' THEN

rule := params->'rule';

updatePrev := false;

END IF;

cron := coalesce(cron,'{}'::jsonb)|| coalesce(rule,'{}'::jsonb);

cron := cron|| jsonb_build_object('dates', array_to_json(dates));

END IF;

IF updatePrevAND prevIS NOT NULL THEN

cron := prev|| cron;

END IF;

clean_cron :='{}'::jsonb;

FOR nameINSELECT*FROM unnest('{dates, crontab, onstart, days, hours, wdays, months, minutes}'::text[])

LOOP