Project

General

Profile

« Previous | Next » 

Revision 12564

schemas/util.sql: added mk_keys_func(regtype)

View differences:

trunk/schemas/util.sql
2067 2067

  
2068 2068

  
2069 2069
--
2070
-- Name: mk_keys_func(regtype); Type: FUNCTION; Schema: util; Owner: -
2071
--
2072

  
2073
CREATE FUNCTION mk_keys_func(type regtype) RETURNS void
2074
    LANGUAGE sql IMMUTABLE
2075
    AS $_$
2076
SELECT util.mk_keys_func($1, ARRAY(
2077
SELECT col FROM util.typed_cols($1) col
2078
WHERE (col).type != ANY('{bigint}'::regtype[]) -- not a count col
2079
))
2080
$_$;
2081

  
2082

  
2083
--
2070 2084
-- Name: mk_keys_func(regtype, col_cast[]); Type: FUNCTION; Schema: util; Owner: -
2071 2085
--
2072 2086

  

Also available in: Unified diff