From d1812fa8c4c9e220978d650adb3611c978a2a56b Mon Sep 17 00:00:00 2001 From: Jason Etheridge Date: Thu, 30 Mar 2017 13:32:44 -0400 Subject: [PATCH] third variant of migration_tools.assert with success message as 3rd argument Signed-off-by: Jason Etheridge --- sql/base/base.sql | 11 +++++++++++ 1 files changed, 11 insertions(+), 0 deletions(-) diff --git a/sql/base/base.sql b/sql/base/base.sql index 7eb55e0..82a7e7a 100644 --- a/sql/base/base.sql +++ b/sql/base/base.sql @@ -2467,3 +2467,14 @@ CREATE OR REPLACE FUNCTION migration_tools.assert (BOOLEAN,TEXT) RETURNS VOID AS END; $$ LANGUAGE PLPGSQL STRICT VOLATILE; +CREATE OR REPLACE FUNCTION migration_tools.assert (BOOLEAN,TEXT,TEXT) RETURNS TEXT AS $$ + DECLARE + test ALIAS FOR $1; + fail_msg ALIAS FOR $2; + success_msg ALIAS FOR $3; + BEGIN + ASSERT test, fail_msg; + RETURN success_msg; + END; +$$ LANGUAGE PLPGSQL STRICT VOLATILE; + -- 1.7.2.5