postgresql7.1 select community_id from dotlrn_communities_all where package_id = :package_id select dotlrn_community_type__new( :community_type_key, :parent_type, :pretty_name, :pretty_name, :description ); select dotlrn_community_type__delete( :community_type_key ); select dotlrn_community__set_active_dates( :community_id, to_date(:start_date, :date_format), to_date(:end_date, :date_format) ); select community_type from dotlrn_communities where community_id = :community_id select dotlrn_community_types.community_type from dotlrn_community_types where dotlrn_community_types.tree_sortkey = (select tree_ancestor_key(dotlrn_communities.tree_sortkey, 1) from dotlrn_communities where dotlrn_communities.community_id = :community_id) select dotlrn_community_types.community_type from dotlrn_community_types where dotlrn_community_types.tree_sortkey = (select tree_ancestor_key(dct.tree_sortkey, 1) from dotlrn_community_types dct where dct.community_type = :community_type) select community_id, community_key, pretty_name, archived_p, dotlrn_community__url(community_id) as url from dotlrn_communities_all where parent_community_id = :community_id and archived_p = 'f' order by pretty_name select from_addr, subject, email from dotlrn_member_emails where (enabled_p or :override_enabled_p = 1) and community_id = :community_id and type = :type