great shuffling, not finished

[migration-tools.git] / sql / base / 09-misc.sql

diff --git a/sql/base/09-misc.sql b/sql/base/09-misc.sql
new file mode 100644 (file)
index 0000000..41d8a01
--- /dev/null
+++ b/sql/base/09-misc.sql
@@ -0,0 +1,7 @@
+
+CREATE OR REPLACE FUNCTION migration_tools.is_blank (TEXT) RETURNS BOOLEAN AS $$
+  BEGIN
+    RETURN CASE WHEN $1 = '' THEN TRUE ELSE FALSE END;
+  END;
+$$ LANGUAGE PLPGSQL STRICT STABLE;
+