X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=blobdiff_plain;f=sql%2Fbase%2Fbase.sql;h=82a7e7a55a5f5e76921a51b498e6e337168c80c7;hp=7eb55e051d0d2883fbdbbc6203655ce062b7c34a;hb=d1812fa8c4c9e220978d650adb3611c978a2a56b;hpb=5a192db46cdadef98017b1b52acfc09946561188 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; +