ACS3 Data Model

     1: function ticket_one_if_high_priority (priority IN integer, status IN varchar)
     2: return integer
     3: is
     4: BEGIN
     5:   IF ((priority = 1) AND (status <> 'closed') AND (status <> 'deferred')) THEN
     6:     return 1;
     7:   ELSE
     8:     return 0;
     9:   END IF;
    10: END ticket_one_if_high_priority;