aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sp_test_endday_task
Parameters
Name
Type
Mode
task
jsonb
IN
error
boolean
IN
status
text
INOUT
msg
text
INOUT
Definition
BEGIN PERFORM pg_sleep(0.2); PERFORM sp_log_info('Run endday task', (task->>'id')||': '||(task->>'name')); status := iif(error, 'error', 'success'); IF error THEN RAISE EXCEPTION SQLSTATE '90002' USING MESSAGE = 'Test Error: '||(task->>'name') ; END IF; msg := 'Success: '||(task->>'name'); END;