Revision 12576
Added by Aaron Marcuse-Kubitza almost 11 years ago
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
schemas/util.sql: added mk_typed_cols_list(col_cast[])