Postgres 15

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

Help with an interesting Postgres question: Why isn't an Index Only Scan used on a partition accessed via the parent table?.

show server_version;

select * 
from pg_catalog.pg_operator 
where oprname in ('<=','>=') 
and oprcode::text ilike '%network%';


server_version


15.0



SHOW




oid
oprname
oprnamespace
oprowner
oprkind
oprcanmerge
oprcanhash
oprleft
oprright
oprresult
oprcom
oprnegate
oprcode
oprrest
oprjoin


1204
<=
11
10
b
f
f
869
869
16
1206
1205
network_le
scalarlesel
scalarlejoinsel

1206
>=
11
10
b
f
f
869
869
16
1204
1203
network_ge
scalargesel
scalargejoinsel



SELECT 2


select inet '192.168.1.5' < inet '192.168.1.6' as "less than",
       inet '192.168.1.5' > inet '192.168.1.6' as "greater than",
       inet '192.168.1.5' <= inet '192.168.1.6' as "less than or equal",
       inet '192.168.1.5' >= inet '192.168.1.6' as "greater than or equal";


less than
greater than
less than or equal
greater than or equal


t
f
t
f



SELECT 1


SELECT n.nspname as "Schema",
  o.oprname AS "Name",
  CASE WHEN o.oprkind='l' THEN NULL ELSE pg_catalog.format_type(o.oprleft, NULL) END AS "Left arg type",
  CASE WHEN o.oprkind='r' THEN NULL ELSE pg_catalog.format_type(o.oprright, NULL) END AS "Right arg type",
  pg_catalog.format_type(o.oprresult, NULL) AS "Result type",
  o.oprcode AS "Function",
  coalesce(pg_catalog.obj_description(o.oid, 'pg_operator'),
           pg_catalog.obj_description(o.oprcode, 'pg_proc')) AS "Description"
FROM pg_catalog.pg_operator o
     LEFT JOIN pg_catalog.pg_namespace n ON n.oid = o.oprnamespace
     LEFT JOIN pg_catalog.pg_type t0 ON t0.oid = o.oprleft
     LEFT JOIN pg_catalog.pg_namespace nt0 ON nt0.oid = t0.typnamespace
     LEFT JOIN pg_catalog.pg_type t1 ON t1.oid = o.oprright
     LEFT JOIN pg_catalog.pg_namespace nt1 ON nt1.oid = t1.typnamespace
WHERE o.oprname OPERATOR(pg_catalog.~) '^(>=)$' COLLATE pg_catalog.default
  AND pg_catalog.pg_operator_is_visible(o.oid)
  AND (t0.typname OPERATOR(pg_catalog.~) '^(inet)$' COLLATE pg_catalog.default
        OR pg_catalog.format_type(t0.oid, NULL) OPERATOR(pg_catalog.~) '^(inet)$' COLLATE pg_catalog.default)
  AND pg_catalog.pg_type_is_visible(t0.oid)
  AND (t1.typname OPERATOR(pg_catalog.~) '^(inet)$' COLLATE pg_catalog.default
        OR pg_catalog.format_type(t1.oid, NULL) OPERATOR(pg_catalog.~) '^(inet)$' COLLATE pg_catalog.default)
  AND pg_catalog.pg_type_is_visible(t1.oid)
ORDER BY 1, 2, 3, 4;


Schema
Name
Left arg type
Right arg type
Result type
Function
Description


pg_catalog
>=
inet
inet
boolean
network_ge
greater than or equal



SELECT 1

oid	oprname	oprnamespace	oprowner	oprkind	oprcanmerge	oprcanhash	oprleft	oprright	oprresult	oprcom	oprnegate	oprcode	oprrest	oprjoin
1204	<=	11	10	b	f	f	869	869	16	1206	1205	network_le	scalarlesel	scalarlejoinsel
1206	>=	11	10	b	f	f	869	869	16	1204	1203	network_ge	scalargesel	scalargejoinsel