Revision 12564
Added by Aaron Marcuse-Kubitza almost 11 years ago
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
schemas/util.sql: added mk_keys_func(regtype)