Revision 13448
Added by Aaron Marcuse-Kubitza over 10 years ago
trunk/schemas/util.sql | ||
---|---|---|
1113 | 1113 |
|
1114 | 1114 |
|
1115 | 1115 |
-- |
1116 |
-- Name: debug_print_var(text, anyelement, boolean); Type: FUNCTION; Schema: util; Owner: - |
|
1117 |
-- |
|
1118 |
|
|
1119 |
CREATE FUNCTION debug_print_var(var text, value anyelement, encode boolean DEFAULT false) RETURNS void |
|
1120 |
LANGUAGE sql IMMUTABLE |
|
1121 |
AS $_$ |
|
1122 |
/* can't use EXECUTE in the caller because "No substitution of PL/pgSQL |
|
1123 |
variables is done on the computed command string" |
|
1124 |
(http://www.postgresql.org/docs/9.3/static/plpgsql-statements.html#PLPGSQL-STATEMENTS-EXECUTING-DYN) */ |
|
1125 |
SELECT util.debug_print_value($1||' = ', $2, $3) |
|
1126 |
$_$; |
|
1127 |
|
|
1128 |
|
|
1129 |
-- |
|
1116 | 1130 |
-- Name: derived_cols(regclass, regclass); Type: FUNCTION; Schema: util; Owner: - |
1117 | 1131 |
-- |
1118 | 1132 |
|
Also available in: Unified diff
schemas/util.sql: added debug_print_var()