CREATE OR REPLACE FUNCTION "addgroup"(_name text, _descr text, _ctime int, _oset int, _en boolean, _ba boolean) RETURNS int AS $$DECLARE gid integer;BEGIN IF _name IS NULL OR _descr IS NULL OR _ctime IS NULL THEN RETURN -2; END IF; LOCK TABLE csvdevel.groups IN ACCESS EXCLUSIVE MODE; PERFORM 1 FROM csvdevel.groups WHERE name = _name; IF FOUND THEN RETURN -1; END IF; gid := nextval('csvdevel.groups_id_seq'); INSERT INTO csvdevel.groups (id,name,description,cycletime,"offset",enabled,beginat) VALUES (gid, _name, _descr, _ctime, _oset, _en, _ba); RETURN gid;END;$$ LANGUAGE 'plpgsql';