-- Name: seq__reset(text, integer); Type: FUNCTION; Schema: util; Owner: -

--

CREATE FUNCTION seq__reset(seq text, start integer DEFAULT 0) RETURNS void

    LANGUAGE sql

    AS $_$

SELECT util.seq__create($1, $2);

SELECT util.eval($$ALTER SEQUENCE $$||$1||$$ RESTART$$);

$_$;

--

-- Name: FUNCTION seq__reset(seq text, start integer); Type: COMMENT; Schema: util; Owner: -

--

COMMENT ON FUNCTION seq__reset(seq text, start integer) IS '

creates sequence if doesn''t exist

idempotent

start: *note*: only used if sequence doesn''t exist

';

--