X-Git-Url: https://git.openstreetmap.org/rails.git/blobdiff_plain/d3d4cff1cf188667cf873d7879d98d8ef86fe474..689821c22483d7b7dd49f69c2671b76ee8628d75:/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;