aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sp_run_endday_task
Parameters
Name
Type
Mode
task_index
integer
IN
Definition
DECLARE system_date date = fn_system_date(); BEGIN UPDATE endday SET tasks = jsonb_set(tasks, '{'||task_index||',status}', 'processing') WHERE endday_date = system_date; PERFORM pg_sleep_for('10 seconds'); UPDATE endday SET tasks = jsonb_set(tasks, '{'||task_index||',status}', 'success') WHERE endday_date = system_date; RETURN TRUE; END;