Revision 12431
Added by Aaron Marcuse-Kubitza almost 11 years ago
| trunk/schemas/util.sql | ||
|---|---|---|
| 1971 | 1971 |
CREATE FUNCTION mk_search_path(VARIADIC schemas text[]) RETURNS text |
| 1972 | 1972 |
LANGUAGE sql IMMUTABLE |
| 1973 | 1973 |
AS $_$ |
| 1974 |
SELECT string_agg(quote_ident(unnest), ', ') FROM unnest($1) |
|
| 1974 |
/* debug_print_return_value() needed because this function is used with EXECUTE |
|
| 1975 |
rather than util.eval() (in order to affect the calling function), so the |
|
| 1976 |
search_path would not otherwise be printed */ |
|
| 1977 |
SELECT util.debug_print_return_value(string_agg(quote_ident(unnest), ', ')) |
|
| 1978 |
FROM unnest($1) |
|
| 1975 | 1979 |
$_$; |
| 1976 | 1980 |
|
| 1977 | 1981 |
|
Also available in: Unified diff
schemas/util.sql: mk_search_path(): use debug_print_return_value() because this function is used with EXECUTE rather than util.eval() (in order to affect the calling function), so the search_path would not otherwise be printed