From 689821c22483d7b7dd49f69c2671b76ee8628d75 Mon Sep 17 00:00:00 2001 From: Matt Amos Date: Mon, 21 Oct 2019 15:05:16 +0100 Subject: [PATCH] Ooops, forgot to commit changes to db/structure.sql --- db/structure.sql | 24 ++++++++++++++++++++++++ 1 file changed, 24 insertions(+) diff --git a/db/structure.sql b/db/structure.sql index 03950502c..6370eb95a 100644 --- a/db/structure.sql +++ b/db/structure.sql @@ -184,6 +184,30 @@ END; $$; +-- +-- Name: xid_to_int4(xid); Type: FUNCTION; Schema: public; Owner: - +-- + +CREATE FUNCTION public.xid_to_int4(t xid) RETURNS integer + LANGUAGE plpgsql STRICT + AS $$ +DECLARE + tl bigint; + ti int; +BEGIN + tl := t; + + IF tl >= 2147483648 THEN + tl := tl - 4294967296; + END IF; + + ti := tl; + + RETURN ti; +END; +$$; + + SET default_tablespace = ''; SET default_with_oids = false; -- 2.39.5