aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sp_append_log
Parameters
Name
Type
Mode
log_text
text
IN
log_id
bigint
IN (DEFAULT NULL)
Definition
BEGIN IF (log_text IS NULL) OR (log_text = '') OR (log_text = E'\n') THEN RETURN NULL; END IF; log_id := COALESCE(log_id, fn_get_session('log_id')::bigint); IF (log_id IS NOT NULL) THEN UPDATE user_logs AS lg SET log_text = CASE WHEN (lg.log_text IS NULL) OR (lg.log_text = '') OR (lg.log_text = E'\n') THEN '' WHEN right(lg.log_text,1) = E'\n' THEN lg.log_text ELSE lg.log_text||E'\n' END || $1 WHERE id = log_id; END IF; RETURN log_id; END