Revision 12481
Added by Aaron Marcuse-Kubitza about 11 years ago
| trunk/schemas/util.sql | ||
|---|---|---|
| 2794 | 2794 |
CREATE FUNCTION runnable_sql(sql text) RETURNS text |
| 2795 | 2795 |
LANGUAGE sql IMMUTABLE |
| 2796 | 2796 |
AS $_$ |
| 2797 |
SELECT util.mk_set_search_path(for_printing := true)||$$; |
|
| 2798 |
$$||$1 |
|
| 2797 |
SELECT (CASE WHEN util.is_set_stmt($1) THEN '' |
|
| 2798 |
ELSE util.mk_set_search_path(for_printing := true)||$$; |
|
| 2799 |
$$ END)||$1 |
|
| 2799 | 2800 |
$_$; |
| 2800 | 2801 |
|
| 2801 | 2802 |
|
Also available in: Unified diff
schemas/util.sql: runnable_sql(): don't output search_path before a SET statement