-- Name: mk_keys_func(regtype, col_cast[]); Type: FUNCTION; Schema: util; Owner: -

--

CREATE FUNCTION mk_keys_func(type regtype, cols col_cast[]) RETURNS void

    LANGUAGE sql IMMUTABLE

    AS $_$

SELECT util.eval($$

CREATE OR REPLACE FUNCTION $$||util.schema($1)||$$.keys(value $$

||util.qual_name($1)||util.mk_out_params($2)||$$)

  RETURNS record AS

$BODY1$

SELECT ROW($$||

(SELECT COALESCE(string_agg($$$1.$$||(unnest).col_name, ', '), '')

FROM unnest($2)) ||$$)

$BODY1$

  LANGUAGE sql IMMUTABLE

  COST 100;

$$)

$_$;

--