↑↓ select ↵ open ⌫ change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Wiki / Operator Families / B-tree classes

btree/oid8_ops (class)

Not recorded in the selected version.

Reading PostgreSQL 18.6.

Not recorded in this version

This PostgreSQL 18.6 snapshot does not contain btree/oid8_ops (class). Available versions:

Compare versions

PostgreSQL 18 → 19: added.

--- PostgreSQL 18
+++ PostgreSQL 19
@@ -1 +1,111 @@
-Not recorded in this version
+{
+  "attributes": {
+    "default": "t",
+    "family": "oid8_ops",
+    "input_type": "oid8",
+    "key_type": "none",
+    "method": "btree",
+    "name": "oid8_ops"
+  },
+  "classes": [
+    {
+      "default": "t",
+      "family": "oid8_ops",
+      "input_type": "oid8",
+      "key_type": "none",
+      "method": "btree",
+      "name": "oid8_ops"
+    }
+  ],
+  "kind": "class",
+  "operators": [
+    {
+      "family": "oid8_ops",
+      "left_type": "oid8",
+      "method": "btree",
+      "operator": "<(oid8,oid8)",
+      "purpose": "search",
+      "right_type": "oid8",
+      "sort_family": "",
+      "strategy": "1"
+    },
+    {
+      "family": "oid8_ops",
+      "left_type": "oid8",
+      "method": "btree",
+      "operator": "<=(oid8,oid8)",
+      "purpose": "search",
+      "right_type": "oid8",
+      "sort_family": "",
+      "strategy": "2"
+    },
+    {
+      "family": "oid8_ops",
+      "left_type": "oid8",
+      "method": "btree",
+      "operator": "=(oid8,oid8)",
+      "purpose": "search",
+      "right_type": "oid8",
+      "sort_family": "",
+      "strategy": "3"
+    },
+    {
+      "family": "oid8_ops",
+      "left_type": "oid8",
+      "method": "btree",
+      "operator": ">=(oid8,oid8)",
+      "purpose": "search",
+      "right_type": "oid8",
+      "sort_family": "",
+      "strategy": "4"
+    },
+    {
+      "family": "oid8_ops",
+      "left_type": "oid8",
+      "method": "btree",
+      "operator": ">(oid8,oid8)",
+      "purpose": "search",
+      "right_type": "oid8",
+      "sort_family": "",
+      "strategy": "5"
+    }
+  ],
+  "support_functions": [
+    {
+      "family": "oid8_ops",
+      "function": "btoid8cmp(oid8,oid8)",
+      "left_type": "oid8",
+      "method": "btree",
+      "number": "1",
+      "result_type": "int4",
+      "right_type": "oid8"
+    },
+    {
+      "family": "oid8_ops",
+      "function": "btoid8sortsupport(internal)",
+      "left_type": "oid8",
+      "method": "btree",
+      "number": "2",
+      "result_type": "void",
+      "right_type": "oid8"
+    },
+    {
+      "family": "oid8_ops",
+      "function": "btequalimage(oid)",
+      "left_type": "oid8",
+      "method": "btree",
+      "number": "4",
+      "result_type": "bool",
+      "right_type": "oid8"
+    },
+    {
+      "family": "oid8_ops",
+      "function": "btoid8skipsupport(internal)",
+      "left_type": "oid8",
+      "method": "btree",
+      "number": "6",
+      "result_type": "void",
+      "right_type": "oid8"
+    }
+  ]
+}

Compares recorded interfaces and attributes. Source fingerprints and build metadata are excluded; an absent sample is not proof of the introduction or removal release.

Related entries

Export JSON · Back to Operator Families · Recorded in PostgreSQL 19 through 20; the first sample is not necessarily its introduction.