ACS3 Data Model

     1: function wp_between_checkpoints_p
     2:   (v_checkpoint IN wp_checkpoints.checkpoint%TYPE,
     3:    v_min_checkpoint IN wp_checkpoints.checkpoint%TYPE,
     4:    v_max_checkpoint IN wp_checkpoints.checkpoint%TYPE)
     5: return varchar is
     6: begin
     7:   if v_checkpoint >= v_min_checkpoint AND (v_max_checkpoint IS NULL OR v_checkpoint < v_max_checkpoint) then
     8:     return 't';
     9:   end if;
    10: 
    11:   return 'f';
    12: end;