Revision 12559
Added by Aaron Marcuse-Kubitza almost 11 years ago
| util.sql | ||
|---|---|---|
| 2095 | 2095 |
CREATE FUNCTION mk_out_params(cols col_cast[]) RETURNS text |
| 2096 | 2096 |
LANGUAGE sql IMMUTABLE |
| 2097 | 2097 |
AS $_$ |
| 2098 |
SELECT string_agg($$, OUT $$||(unnest).col_name||$$ $$|| |
|
| 2099 |
util.qual_name((unnest).type), '') |
|
| 2098 |
SELECT COALESCE(string_agg($$, OUT $$||(unnest).col_name||$$ $$||
|
|
| 2099 |
util.qual_name((unnest).type), ''), '')
|
|
| 2100 | 2100 |
FROM unnest($1) |
| 2101 | 2101 |
$_$; |
| 2102 | 2102 |
|
Also available in: Unified diff
bugfix: schemas/util.sql: mk_out_params(): need COALESCE around string_agg()