ACS3 Data Model

     1: function hp_get_nh_child_count (neighborhoodid IN integer)
     2: return integer
     3: IS
     4: 	CURSOR count_cursor IS
     5: 		select count(*) from users_neighborhoods
     6: 		where parent_id=neighborhoodid;
     7: 	counter		integer;
     8: BEGIN
     9: 	OPEN count_cursor;
    10: 	FETCH count_cursor INTO counter;
    11: 	CLOSE count_cursor;
    12: 	return counter;
    13: END;