-- Name: mk_subset_by_row_num_func(regclass, text); Type: FUNCTION; Schema: util; Owner: -

--

CREATE FUNCTION mk_subset_by_row_num_func(view_ regclass, row_num_col text) RETURNS void

    LANGUAGE plpgsql STRICT

    AS $_$

BEGIN

	EXECUTE $$

CREATE OR REPLACE FUNCTION $$||view_||$$(limit_ integer DEFAULT NULL::integer, offset_ integer DEFAULT NULL)

  RETURNS SETOF $$||view_||$$ AS

$BODY1$

SELECT * FROM $$||util.type_qual_name(view_::text::regtype)||$$

WHERE $$||quote_ident(row_num_col)||$$ BETWEEN COALESCE($2, 0) AND COALESCE($2+$1, 2147483647)

$BODY1$

  LANGUAGE sql STABLE

  COST 100

  ROWS 1000

$$;

END;

$_$;

--