aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sp_system_notify
Parameters
Name
Type
Mode
title
text
IN
message
text
IN
users
text[]
IN (DEFAULT NULL)
icon
text
IN (DEFAULT NULL)
Definition
/* * Create by Pisanu (2021/07/08) * For notify to system admin by Telegram */ SELECT IIF(success, 1, 9) FROM dblink( fn_conn_authen(), format($$Select sp_system_notify(%L, %L) as success$$, coalesce(icon||' ', '')||'['||upper(fn_prop_code())||'] '||title, message) ) AS (success bool)