/ - Diff - BIEN 3 - NCEAS Projects

« Previous | Next »

Revision 12464

schemas/util.sql: util.explain2notice_msg(): add newline before and after to visually separate it from other debug info

     newline after to visually separate queries from one another. */
     SELECT util.raise_notice($$
     $$||$1||$$
     $$||COALESCE($$
     $$||util.explain2notice_msg_if_can($1)||$$
     $$, ''))
     $$||COALESCE(util.explain2notice_msg_if_can($1), ''))
     $_$;
-...
     CREATE FUNCTION explain2notice_msg(sql text) RETURNS text
         LANGUAGE sql
         AS $_$
     SELECT $$EXPLAIN:
     $$||util.explain2str($1)
     -- newline before and after to visually separate it from other debug info
     SELECT $$
     EXPLAIN:
     $$||util.explain2str($1)||$$
     $$
     $_$;

Also available in: Unified diff