SELECT (jgbc.group_id) as test_group_id FROM jb_groups_blocked_conference jgbc WHERE group_id =:group_id SELECT group_id FROM jb_conference_groups WHERE group_id = :group_id INSERT INTO jb_conference_groups (group_id , conference_only_p ) values (:group_id , 'f') SELECT im_screen_name , status FROM jb_screens WHERE user_id = :user_id AND service = 'jabber' DECLARE v_room_id integer; begin SELECT room_id INTO v_room_id FROM jb_conference_rooms WHERE lower(name) = lower(:room_name); UPDATE jb_conference_groups SET default_room_id = v_room_id WHERE group_id = :group_id; END;