From 035aa3d40f901d2510cdfb103ff0fd7e418e6710 Mon Sep 17 00:00:00 2001 From: Jason Etheridge Date: Thu, 30 Mar 2017 13:18:25 -0400 Subject: [PATCH] assert tool for use with \set ON_ERROR_STOP on Signed-off-by: Jason Etheridge --- sql/base/base.sql | 18 ++++++++++++++++++ 1 files changed, 18 insertions(+), 0 deletions(-) diff --git a/sql/base/base.sql b/sql/base/base.sql index 8f16f68..7eb55e0 100644 --- a/sql/base/base.sql +++ b/sql/base/base.sql @@ -2449,3 +2449,21 @@ CREATE OR REPLACE FUNCTION migration_tools.find_circ_matrix_matchpoint (INTEGER) ) ); $$ LANGUAGE SQL; + +CREATE OR REPLACE FUNCTION migration_tools.assert (BOOLEAN) RETURNS VOID AS $$ + DECLARE + test ALIAS FOR $1; + BEGIN + ASSERT test; + END; +$$ LANGUAGE PLPGSQL STRICT VOLATILE; + +CREATE OR REPLACE FUNCTION migration_tools.assert (BOOLEAN,TEXT) RETURNS VOID AS $$ + DECLARE + test ALIAS FOR $1; + msg ALIAS FOR $2; + BEGIN + ASSERT test, msg; + END; +$$ LANGUAGE PLPGSQL STRICT VOLATILE; + -- 1.7.2.5