X-Git-Url: https://git.openstreetmap.org./rails.git/blobdiff_plain/afe679349fb7139f5cff5830f45e4b8214732812..d711d5af735abc83c36c8e6d1a91b21bdaa7f987:/db/structure.sql 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;