-- //// Insert Function CREATE OR REPLACE FUNCTION groupmember_Insert_list ( v_gid int4, v_sid int4[] ) RETURNS void AS $$ BEGIN FOR i IN array_lower(v_sid, 1)..array_upper(v_sid, 1) LOOP INSERT INTO groupmember ( gid, sid ) VALUES ( v_gid, v_sid[i] ); END LOOP; RETURN; END; $$ LANGUAGE plpgsql;