All pastes #390028 Raw Edit

Stuff

public sql v1 · immutable
·published 2007-03-11 02:57 UTC
rendered paste body
-- //// Insert FunctionCREATE 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;