/usr/share/postgresql/10/extension/debversion--1.0.8--1.1.sql is in postgresql-10-debversion 1.1-1.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 | UPDATE pg_operator SET oprrest = 'eqsel'::regproc, oprjoin = 'eqjoinsel'::regproc
WHERE oprname = '=' AND oprleft = 'debversion'::regtype AND oprright = 'debversion'::regtype;
UPDATE pg_operator SET oprrest = 'neqsel'::regproc, oprjoin = 'neqjoinsel'::regproc
WHERE oprname = '<>' AND oprleft = 'debversion'::regtype AND oprright = 'debversion'::regtype;
UPDATE pg_operator SET oprrest = 'scalarltsel'::regproc, oprjoin = 'scalarltjoinsel'::regproc
WHERE oprname IN ('<', '<=') AND oprleft = 'debversion'::regtype AND oprright = 'debversion'::regtype;
UPDATE pg_operator SET oprrest = 'scalargtsel'::regproc, oprjoin = 'scalargtjoinsel'::regproc
WHERE oprname IN ('>', '>=') AND oprleft = 'debversion'::regtype AND oprright = 'debversion'::regtype;
-- PG 9.6+ has ALTER OPERATOR SET RESTRICT | JOIN ...
|