blob: bd02f3df2551a83792f086575247ff57ca381b27 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
|
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 website;
SELECT curr_revision();
|
