From 5a2ba9c2e7605bb788bc406184547d22c6436867 Mon Sep 17 00:00:00 2001 From: Freya Murphy Date: Mon, 23 Dec 2024 11:13:27 -0500 Subject: v2.1.0, refactor w/ crimson --- src/db/rev.sql | 21 --------------------- 1 file changed, 21 deletions(-) delete mode 100644 src/db/rev.sql (limited to 'src/db/rev.sql') diff --git a/src/db/rev.sql b/src/db/rev.sql deleted file mode 100644 index dff1cfe..0000000 --- a/src/db/rev.sql +++ /dev/null @@ -1,21 +0,0 @@ -CREATE OR REPLACE FUNCTION curr_revision() -RETURNS INTEGER -LANGUAGE plpgsql VOLATILE -AS $BODY$ -DECLARE - _revision INTEGER; -BEGIN - BEGIN - SELECT curr_revision INTO _revision - FROM sys.database_info - WHERE name = current_database(); - RETURN _revision; - EXCEPTION WHEN OTHERS THEN - RETURN 0; - END; -END -$BODY$; - -GRANT EXECUTE ON FUNCTION curr_revision() TO xssbook; - -SELECT curr_revision(); -- cgit v1.2.3-freya