Project

General

Profile

« Previous | Next » 

Revision 12576

schemas/util.sql: added mk_typed_cols_list(col_cast[])

View differences:

trunk/schemas/util.sql
2330 2330

  
2331 2331

  
2332 2332
--
2333
-- Name: mk_typed_cols_list(col_cast[]); Type: FUNCTION; Schema: util; Owner: -
2334
--
2335

  
2336
CREATE FUNCTION mk_typed_cols_list(cols col_cast[]) RETURNS text
2337
    LANGUAGE sql IMMUTABLE
2338
    AS $_$
2339
SELECT COALESCE(string_agg((unnest).col_name||$$ $$||
2340
util.qual_name((unnest).type), ', '), '')
2341
FROM unnest($1)
2342
$_$;
2343

  
2344

  
2345
--
2333 2346
-- Name: name(regclass); Type: FUNCTION; Schema: util; Owner: -
2334 2347
--
2335 2348

  

Also available in: Unified diff