Revision 12556
Added by Aaron Marcuse-Kubitza about 11 years ago
trunk/schemas/util.sql | ||
---|---|---|
2089 | 2089 |
|
2090 | 2090 |
|
2091 | 2091 |
-- |
2092 |
-- Name: mk_out_params(col_cast[]); Type: FUNCTION; Schema: util; Owner: - |
|
2093 |
-- |
|
2094 |
|
|
2095 |
CREATE FUNCTION mk_out_params(cols col_cast[]) RETURNS text |
|
2096 |
LANGUAGE sql IMMUTABLE |
|
2097 |
AS $_$ |
|
2098 |
SELECT string_agg($$, OUT $$||(unnest).col_name||$$ $$|| |
|
2099 |
util.qual_name((unnest).type), '') |
|
2100 |
FROM unnest($1) |
|
2101 |
$_$; |
|
2102 |
|
|
2103 |
|
|
2104 |
-- |
|
2092 | 2105 |
-- Name: mk_search_path(text[]); Type: FUNCTION; Schema: util; Owner: - |
2093 | 2106 |
-- |
2094 | 2107 |
|
Also available in: Unified diff
schemas/util.sql: added mk_out_params()