Project

General

Profile

« Previous | Next » 

Revision 13448

schemas/util.sql: added debug_print_var()

View differences:

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