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

--

CREATE FUNCTION mk_subset_by_row_num_func(view_ regclass) RETURNS void

    LANGUAGE plpgsql STRICT

    AS $_$

DECLARE

	view_qual_name text = util.qual_name(view_);

BEGIN

	EXECUTE $$

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

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

$BODY1$

SELECT * FROM $$||view_qual_name||$$

ORDER BY sort_col

LIMIT $1 OFFSET $2

$BODY1$

  LANGUAGE sql STABLE

  COST 100

  ROWS 1000

$$;

	PERFORM util.mk_subset_by_row_num_no_sort_func(view_);

END;

$_$;

--