postgresql7.1 select community_id from dotlrn_communities 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__new( :community_type, :name :pretty_name, :pretty_name, :description ); select dotlrn_community__set_active_dates( :community_id, to_date(:start_date, :date_format), to_date(:end_date, :date_format) ); select site_node__url(node_id) from site_nodes where parent_id = :current_node_id and object_id = :package_id 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)