aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sp_delete_notifications_user
Parameters
Name
Type
Mode
i_notify_id
integer
IN
Definition
declare current_username text; _notify_id integer; begin current_username = fn_current_user(); DELETE FROM notification WHERE id = i_notify_id and notify_user = current_username returning id into _notify_id; delete from notification_followup where notification_id = i_notify_id; --return _notify_id; END;