Revision 12432
Added by Aaron Marcuse-Kubitza over 10 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 |
/* 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) |
|
| 1974 |
SELECT string_agg(quote_ident(unnest), ', ') FROM unnest($1) |
|
| 1979 | 1975 |
$_$; |
| 1980 | 1976 |
|
| 1981 | 1977 |
|
| ... | ... | |
| 2009 | 2005 |
CREATE FUNCTION mk_set_search_path(search_path text) RETURNS text |
| 2010 | 2006 |
LANGUAGE sql IMMUTABLE |
| 2011 | 2007 |
AS $_$ |
| 2012 |
SELECT $$SET LOCAL search_path TO $$||$1 |
|
| 2008 |
/* debug_print_return_value() needed because this function is used with EXECUTE |
|
| 2009 |
rather than util.eval() (in order to affect the calling function), so the |
|
| 2010 |
search_path would not otherwise be printed */ |
|
| 2011 |
SELECT util.debug_print_return_value($$SET LOCAL search_path TO $$||$1) |
|
| 2013 | 2012 |
$_$; |
| 2014 | 2013 |
|
| 2015 | 2014 |
|
Also available in: Unified diff
bugfix: schemas/util.sql: mk_set_search_path(): debug_print_return_value() needs to be on mk_set_search_path(text), not mk_search_path(VARIADIC text[])