ACS3 Data Model

     1: function user_fulfills_requirements_p(uid in integer) return char
     2: AS
     3: 	requirements	user_requirements%ROWTYPE;
     4: 	count_result	integer;
     5: begin
     6: 	select count(*) INTO count_result from user_requirements where user_id=uid;
     7: 	IF count_result=0
     8: 	THEN RETURN 't';
     9: 	END IF;
    10: 
    11: 	select * INTO requirements from user_requirements where user_id=uid;
    12: 
    13: 	select count(*) INTO count_result from users_demographics where user_id=uid;
    14: 
    15: 	IF requirements.demographics='t' AND count_result=0 THEN
    16: 		RETURN 'f';
    17: 	END IF;
    18: 
    19: 	select count(*) INTO count_result from users_contact where user_id=uid;
    20: 
    21: 	IF requirements.contacts='t' AND count_result=0 THEN
    22: 		RETURN 'f';
    23: 	END IF;
    24: 
    25: 	RETURN 't';
    26: 
    27: end user_fulfills_requirements_p;