-- Also create subset function which turns off enable_sort

	EXECUTE $$

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

  RETURNS SETOF $$||view_||$$

  SET enable_sort TO 'off'

  AS

$BODY1$

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

$BODY1$

  LANGUAGE sql STABLE

  COST 100

  ROWS 1000

;

COMMENT ON FUNCTION $$||view_||$$(no_sort boolean, limit_ integer, offset_ integer) IS '

Use this for limit values greater than ~100,000 to avoid unwanted slow sorts.

If you want to run EXPLAIN and get expanded output, use the regular subset

function instead. (When a config param is set on a function, EXPLAIN produces

just a function scan.)

';

$$;