Project

General

Profile

« Previous | Next » 

Revision 12556

schemas/util.sql: added mk_out_params()

View differences:

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