{"kind": "type", "slug": "bit", "name": "bit", "major": "18", "snapshot": {"casts": [{"castfunc": "0", "castmethod": "b", "castsource": "bit", "casttarget": "varbit", "castcontext": "i"}, {"castfunc": "0", "castmethod": "b", "castsource": "varbit", "casttarget": "bit", "castcontext": "i"}, {"castfunc": "bit(int8,int4)", "castmethod": "f", "castsource": "int8", "casttarget": "bit", "castcontext": "e"}, {"castfunc": "bit(int4,int4)", "castmethod": "f", "castsource": "int4", "casttarget": "bit", "castcontext": "e"}, {"castfunc": "int8(bit)", "castmethod": "f", "castsource": "bit", "casttarget": "int8", "castcontext": "e"}, {"castfunc": "int4(bit)", "castmethod": "f", "castsource": "bit", "casttarget": "int4", "castcontext": "e"}, {"castfunc": "bit(bit,int4,bool)", "castmethod": "f", "castsource": "bit", "casttarget": "bit", "castcontext": "i"}], "facts": [{"label": "Catalog name", "value": "pg_catalog.bit"}, {"label": "Type OID", "value": "1560"}, {"label": "Type kind", "value": "Base type"}, {"label": "Declared length", "value": "Variable length (varlena)"}, {"label": "Storage strategy", "value": "extended"}, {"label": "Input function", "value": "bit_in"}, {"label": "Output function", "value": "bit_out"}], "ranges": [], "aliases": [], "catalog": {"oid": "1560", "descr": "fixed-length bit string", "typacl": "_null_", "typlen": "-1", "typelem": "0", "typname": "bit", "typsend": "bit_send", "typtype": "b", "typalign": "i", "typarray": "0", "typbyval": "f", "typdelim": "','", "typinput": "bit_in", "typmodin": "bittypmodin", "typndims": "0", "typowner": "POSTGRES", "typrelid": "0", "typmodout": "bittypmodout", "typoutput": "bit_out", "typtypmod": "-1", "typanalyze": "-", "typdefault": "_null_", "typnotnull": "f", "typreceive": "bit_recv", "typstorage": "x", "typbasetype": "0", "typcategory": "V", "typcollation": "0", "typisdefined": "t", "typnamespace": "pg_catalog", "typsubscript": "-", "typdefaultbin": "_null_", "array_type_oid": "1561", "typispreferred": "f", "array_type_name": "_bit"}, "related": [{"url": "/wiki/catalog/pg_type/?v=18", "label": "pg_type catalog"}, {"url": "/wiki/catalog/pg_cast/?v=18", "label": "pg_cast catalog"}, {"url": "/wiki/catalog/pg_operator/?v=18", "label": "pg_operator catalog"}, {"url": "/wiki/catalog/pg_opclass/?v=18", "label": "pg_opclass catalog"}, {"url": "/wiki/type/arrays/?v=18", "label": "Arrays"}, {"url": "/wiki/indexam/brin/?v=18", "label": "brin index access method"}, {"url": "/wiki/indexam/btree/?v=18", "label": "btree index access method"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2", "label": "18.6", "major": "18", "channel": "stable", "revision": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f", "source_files": {"doc/src/sgml/datatype.sgml": "86328daa77e20d81d222376ec0306d9841a17104e436c08d138eb763aefb3700", "src/include/catalog/pg_am.h": "3426799df799f32163fcc0765f43dbdb5e88e626acf31284fef9fc6014b69d8e", "src/include/catalog/pg_am.dat": "b3cb86b102a42fb0024cbd99779c9897afb40d12a71f5cc5a0e5aee7ff2f9969", "src/include/catalog/pg_cast.h": "de585c7df687d698e7d1d100dce8a794ac9da52414ea48169191019178c8f053", "src/include/catalog/pg_proc.h": "f7d59f07c5b95e2f3c7141762a0f576e8a3af7581ba54c27537f4d500472bea5", "src/include/catalog/pg_type.h": "8fb198749fd82b6c1818a3c18455f226f66116fcfeb3d4959c65ce3fda22802e", "src/include/catalog/pg_range.h": "45546d952b5181f989bd9234721897fc2b37005c8e49ce2ddc156f26974c3ca4", "src/include/catalog/pg_cast.dat": "97911281ca2c81917394ccb2ec13367e37c6801fd461d5e1a3d2f28b911b46b2", "src/include/catalog/pg_proc.dat": "1f934ce80d460159dda137714374a35f9896315ea2476709cbb4da13b38ef95a", "src/include/catalog/pg_type.dat": "5f5887b75677cba2d4a1a0cfeb355df5ed91f85d385fac88bd8d7c605b3578f9", "src/include/catalog/pg_opclass.h": "9c218537806c8ef0398302faaca7f91315dfc1198c48706cebffb479b68defaf", "src/include/catalog/pg_range.dat": "5c2271f8e89e9378d1887204e5785060b77405b5f0ff3e6c719250c9c1dcfcc4", "src/include/catalog/pg_operator.h": "621b18cfffe102413d79b746ce7a10f77fc60fdd097bac34c22b31070d3ee3c4", "src/include/catalog/pg_opfamily.h": "e1f5fc8aebd3042df847455bf66bf755f768c2aa8a9b03d22f7ec8563eba59c0", "src/include/catalog/pg_opclass.dat": "4ee7d3619a6aa106e1c0db55de903931c7d11b1c60ba053a022519c55f8ee668", "src/include/catalog/pg_operator.dat": "5d35b9b2ef5f9797cc815263927ef8a12367fedace53e828b4e8b320e2a7f703", "src/include/catalog/pg_opfamily.dat": "3b694879027b858f2ecf1fa1152b7e30c6e15a216ba99c2384291c30e9d52311"}, "manual_sha256": {"arrays.html": "0e1d5c5a7b4a949d4439995f44f74ad4264e050d16eb9ad2a850fbaee04032df", "domains.html": "82d486973ccc35d14276627a67ac76b434452f23f9ed4d8aa3fbb01fdf285fc2", "datatype.html": "e581f67c74e42006289638c8659e9b338adbfd7f068bd8bf2b3be3880fcd2254", "rowtypes.html": "74f99e029c3a9edfd3e18810ba3c8cb66d3aada91eb67b86476560871e6617e9", "rangetypes.html": "e4960abc7ce8e51d794f94f1e57b099d30b7f75dd7f2b23a960eef91f6291c33", "datatype-bit.html": "c49124aad561636c18080b9e09572fde7785a6b9eae86f5a33283f0fd6774c37", "datatype-oid.html": "8b3360302225f08ae72716ce1804596de95b568e5d31f788cb4597427b28cc38", "datatype-xml.html": "061fc2295b7b69be704f0a741b8decd10ad721059f871fb0243c669bb54d7822", "datatype-enum.html": "cab38e53222e30cc94b24de4b33634fd22d7c93f58ebcf35f646c9b8da78fae8", "datatype-json.html": "650162a05b660146b500a205d523374d00aee117a6a6240d30262be51b6e33e5", "datatype-uuid.html": "292b307b3223c6182bdba687e7f69e6dca9038430143ad79d56327f6ed4c3246", "datatype-money.html": "8b29c14b90679683ac5c472b59a0a7e2853f32cc7db43fab417b2697a6879964", "functions-info.html": "78ac80bf81da2e4f4a33f3b850faa86f0f58ec54a083d6c31da557907de0df87", "catalog-pg-type.html": "ea9c9313bab8e92a7da18ebc50c7ff1f908dd80999a7e0ca3bbc82ba626c58d4", "datatype-binary.html": "0c03ec47b76e37888a3da7f5dcfd340128a5d356642a85185cc9ebe17856a904", "datatype-pg-lsn.html": "339172f5107cc7eb7139bec911277647219e92a532cebd0f3da0a5dacf8195af", "datatype-pseudo.html": "c7cf0b8214304bd8702c95f2142671ae5f0d631f83717f9c07d9e1f2579961b4", "datatype-boolean.html": "b633f663e6c8276e7056287640c413aa79dbc15d5353cee0d41653d58d376956", "datatype-numeric.html": "b74619f7ac2f1ca9f85c48073df78c33dd30e464e61baba6008634534edcb500", "sql-createdomain.html": "e94f927196de1b0ea1ce35cd4603c1f6f544439adcc0edf1c4222358e832245b", "datatype-datetime.html": "e366275d8b13845bfa4ef0d68faa093e5f3ecb708a1ec870cbcbf7e425b85699", "datatype-character.html": "c73eebe413ea709a7792e4cfc3cfe9fb68cb496ebe83c3ebaa9d09f8c40d0f73", "datatype-geometric.html": "0eb3053cfe7d6b0a4b5592c5d7af8d97cae527e87f063c5793413bcba5c14cd9", "datatype-net-types.html": "96846e641cc37727ddcd8b8a1aa0dbe33cd9787760a2b4efb0dcb9403d5be63f", "datatype-textsearch.html": "4b15e05be8b49a71b28aea22f2c46d0dbf639a91e7b4fe129a4c737c6daad47c"}, "source_sha256": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"}, "sources": [{"url": "/docs/18/datatype-bit.html", "path": "datatype-bit.html", "label": "PostgreSQL 18 English manual", "sha256": "c49124aad561636c18080b9e09572fde7785a6b9eae86f5a33283f0fd6774c37"}, {"url": "https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2", "label": "Matching PostgreSQL source archive", "sha256": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"}], "coverage": "source inventory; exact declared input types for operator classes", "sections": [], "operators": [{"oid": "1784", "descr": "equal", "oprcom": "=(bit,bit)", "oprcode": "biteq", "oprjoin": "eqjoinsel", "oprkind": "b", "oprleft": "bit", "oprname": "=", "oprrest": "eqsel", "oprowner": "POSTGRES", "oprright": "bit", "oprnegate": "<>(bit,bit)", "oprresult": "bool", "oprcanhash": "f", "oprcanmerge": "t", "oprnamespace": "pg_catalog"}, {"oid": "1785", "descr": "not equal", "oprcom": "<>(bit,bit)", "oprcode": "bitne", "oprjoin": "neqjoinsel", "oprkind": "b", "oprleft": "bit", "oprname": "<>", "oprrest": "neqsel", "oprowner": "POSTGRES", "oprright": "bit", "oprnegate": "=(bit,bit)", "oprresult": "bool", "oprcanhash": "f", "oprcanmerge": "f", "oprnamespace": "pg_catalog"}, {"oid": "1786", "descr": "less than", "oprcom": ">(bit,bit)", "oprcode": "bitlt", "oprjoin": "scalarltjoinsel", "oprkind": "b", "oprleft": "bit", "oprname": "<", "oprrest": "scalarltsel", "oprowner": "POSTGRES", "oprright": "bit", "oprnegate": ">=(bit,bit)", "oprresult": "bool", "oprcanhash": "f", "oprcanmerge": "f", "oprnamespace": "pg_catalog"}, {"oid": "1787", "descr": "greater than", "oprcom": "<(bit,bit)", "oprcode": "bitgt", "oprjoin": "scalargtjoinsel", "oprkind": "b", "oprleft": "bit", "oprname": ">", "oprrest": "scalargtsel", "oprowner": "POSTGRES", "oprright": "bit", "oprnegate": "<=(bit,bit)", "oprresult": "bool", "oprcanhash": "f", "oprcanmerge": "f", "oprnamespace": "pg_catalog"}, {"oid": "1788", "descr": "less than or equal", "oprcom": ">=(bit,bit)", "oprcode": "bitle", "oprjoin": "scalarlejoinsel", "oprkind": "b", "oprleft": "bit", "oprname": "<=", "oprrest": "scalarlesel", "oprowner": "POSTGRES", "oprright": "bit", "oprnegate": ">(bit,bit)", "oprresult": "bool", "oprcanhash": "f", "oprcanmerge": "f", "oprnamespace": "pg_catalog"}, {"oid": "1789", "descr": "greater than or equal", "oprcom": "<=(bit,bit)", "oprcode": "bitge", "oprjoin": "scalargejoinsel", "oprkind": "b", "oprleft": "bit", "oprname": ">=", "oprrest": "scalargesel", "oprowner": "POSTGRES", "oprright": "bit", "oprnegate": "<(bit,bit)", "oprresult": "bool", "oprcanhash": "f", "oprcanmerge": "f", "oprnamespace": "pg_catalog"}, {"oid": "1791", "descr": "bitwise and", "oprcom": "&(bit,bit)", "oprcode": "bitand", "oprjoin": "-", "oprkind": "b", "oprleft": "bit", "oprname": "&", "oprrest": "-", "oprowner": "POSTGRES", "oprright": "bit", "oprnegate": "0", "oprresult": "bit", "oprcanhash": "f", "oprcanmerge": "f", "oprnamespace": "pg_catalog"}, {"oid": "1792", "descr": "bitwise or", "oprcom": "|(bit,bit)", "oprcode": "bitor", "oprjoin": "-", "oprkind": "b", "oprleft": "bit", "oprname": "|", "oprrest": "-", "oprowner": "POSTGRES", "oprright": "bit", "oprnegate": "0", "oprresult": "bit", "oprcanhash": "f", "oprcanmerge": "f", "oprnamespace": "pg_catalog"}, {"oid": "1793", "descr": "bitwise exclusive or", "oprcom": "#(bit,bit)", "oprcode": "bitxor", "oprjoin": "-", "oprkind": "b", "oprleft": "bit", "oprname": "#", "oprrest": "-", "oprowner": "POSTGRES", "oprright": "bit", "oprnegate": "0", "oprresult": "bit", "oprcanhash": "f", "oprcanmerge": "f", "oprnamespace": "pg_catalog"}, {"oid": "1794", "descr": "bitwise not", "oprcom": "0", "oprcode": "bitnot", "oprjoin": "-", "oprkind": "l", "oprleft": "0", "oprname": "~", "oprrest": "-", "oprowner": "POSTGRES", "oprright": "bit", "oprnegate": "0", "oprresult": "bit", "oprcanhash": "f", "oprcanmerge": "f", "oprnamespace": "pg_catalog"}, {"oid": "1795", "descr": "bitwise shift left", "oprcom": "0", "oprcode": "bitshiftleft", "oprjoin": "-", "oprkind": "b", "oprleft": "bit", "oprname": "<<", "oprrest": "-", "oprowner": "POSTGRES", "oprright": "int4", "oprnegate": "0", "oprresult": "bit", "oprcanhash": "f", "oprcanmerge": "f", "oprnamespace": "pg_catalog"}, {"oid": "1796", "descr": "bitwise shift right", "oprcom": "0", "oprcode": "bitshiftright", "oprjoin": "-", "oprkind": "b", "oprleft": "bit", "oprname": ">>", "oprrest": "-", "oprowner": "POSTGRES", "oprright": "int4", "oprnegate": "0", "oprresult": "bit", "oprcanhash": "f", "oprcanmerge": "f", "oprnamespace": "pg_catalog"}], "signature": "bit [ ( n ) ]", "description": ["fixed-length bit string"], "manual_html": "<div class=\"sect1\" id=\"DATATYPE-BIT\">\n<div class=\"titlepage\">\n<div>\n<div>\n<h2 class=\"title\">8.10. Bit String Types </h2>\n</div>\n</div>\n</div>\n<p>Bit strings are strings of 1's and 0's. They can be used to store or visualize bit masks. There are two SQL bit types: <code class=\"type\">bit(<em class=\"replaceable\"><code>n</code></em>)</code> and <code class=\"type\">bit varying(<em class=\"replaceable\"><code>n</code></em>)</code>, where <em class=\"replaceable\"><code>n</code></em> is a positive integer.</p>\n<p><code class=\"type\">bit</code> type data must match the length <em class=\"replaceable\"><code>n</code></em> exactly; it is an error to attempt to store shorter or longer bit strings. <code class=\"type\">bit varying</code> data is of variable length up to the maximum length <em class=\"replaceable\"><code>n</code></em>; longer strings will be rejected. Writing <code class=\"type\">bit</code> without a length is equivalent to <code class=\"literal\">bit(1)</code>, while <code class=\"type\">bit varying</code> without a length specification means unlimited length.</p>\n<div class=\"note\">\n<h3 class=\"title\">Note</h3>\n<p>If one explicitly casts a bit-string value to <code class=\"type\">bit(<em class=\"replaceable\"><code>n</code></em>)</code>, it will be truncated or zero-padded on the right to be exactly <em class=\"replaceable\"><code>n</code></em> bits, without raising an error. Similarly, if one explicitly casts a bit-string value to <code class=\"type\">bit varying(<em class=\"replaceable\"><code>n</code></em>)</code>, it will be truncated on the right if it is more than <em class=\"replaceable\"><code>n</code></em> bits.</p>\n</div>\n<p>Refer to <a class=\"xref\" href=\"/docs/18/sql-syntax-lexical.html#SQL-SYNTAX-BIT-STRINGS\" title=\"4.1.2.5. Bit-String Constants\">Section 4.1.2.5</a> for information about the syntax of bit string constants. Bit-logical operators and string manipulation functions are available; see <a class=\"xref\" href=\"/docs/18/functions-bitstring.html\" title=\"9.6. Bit String Functions and Operators\">Section 9.6</a>.</p>\n<div class=\"example\" id=\"id-1.5.7.18.7\">\n<p class=\"title\"><strong>Example 8.3. Using the Bit String Types</strong></p>\n<div class=\"example-contents\">\n<pre class=\"programlisting\">CREATE TABLE test (a BIT(3), b BIT VARYING(5));\nINSERT INTO test VALUES (B'101', B'00');\nINSERT INTO test VALUES (B'10', B'101');\n<code class=\"computeroutput\">\nERROR:  bit string length 2 does not match type bit(3)\n</code>\nINSERT INTO test VALUES (B'10'::bit(3), B'101');\nSELECT * FROM test;\n<code class=\"computeroutput\">\n  a  |  b\n-----+-----\n 101 | 00\n 100 | 101\n</code>\n</pre>\n</div>\n</div><br class=\"example-break\">\n<p>A bit string value requires 1 byte for each group of 8 bits, plus 5 or 8 bytes overhead depending on the length of the string (but long values may be compressed or moved out-of-line, as explained in <a class=\"xref\" href=\"/docs/18/datatype-character.html\" title=\"8.3. Character Types\">Section 8.3</a> for character strings).</p>\n</div>", "manual_path": "datatype-bit.html", "comparison_data": {"casts": [{"castfunc": "bit(int4,int4)", "castmethod": "f", "castsource": "int4", "casttarget": "bit", "castcontext": "e"}, {"castfunc": "bit(int8,int4)", "castmethod": "f", "castsource": "int8", "casttarget": "bit", "castcontext": "e"}, {"castfunc": "int4(bit)", "castmethod": "f", "castsource": "bit", "casttarget": "int4", "castcontext": "e"}, {"castfunc": "int8(bit)", "castmethod": "f", "castsource": "bit", "casttarget": "int8", "castcontext": "e"}, {"castfunc": "0", "castmethod": "b", "castsource": "bit", "casttarget": "varbit", "castcontext": "i"}, {"castfunc": "0", "castmethod": "b", "castsource": "varbit", "casttarget": "bit", "castcontext": "i"}, {"castfunc": "bit(bit,int4,bool)", "castmethod": "f", "castsource": "bit", "casttarget": "bit", "castcontext": "i"}], "facts": [{"label": "Catalog name", "value": "pg_catalog.bit"}, {"label": "Declared length", "value": "Variable length (varlena)"}, {"label": "Input function", "value": "bit_in"}, {"label": "Output function", "value": "bit_out"}, {"label": "Storage strategy", "value": "extended"}, {"label": "Type OID", "value": "1560"}, {"label": "Type kind", "value": "Base type"}], "ranges": [], "aliases": [], "catalog": {"typacl": "_null_", "typlen": "-1", "typelem": "0", "typname": "bit", "typsend": "bit_send", "typtype": "b", "typalign": "i", "typarray": "_bit", "typbyval": "f", "typdelim": ",", "typinput": "bit_in", "typmodin": "bittypmodin", "typndims": "0", "typrelid": "0", "typmodout": "bittypmodout", "typoutput": "bit_out", "typtypmod": "-1", "typanalyze": "-", "typdefault": "_null_", "typnotnull": "f", "typreceive": "bit_recv", "typstorage": "x", "typbasetype": "0", "typcategory": "V", "typcollation": "0", "typisdefined": "t", "typsubscript": "-", "typdefaultbin": "_null_", "typispreferred": "f", "array_type_name": "_bit"}, "operators": [{"oprcom": "&(bit,bit)", "oprcode": "bitand", "oprjoin": "-", "oprkind": "b", "oprleft": "bit", "oprname": "&", "oprrest": "-", "oprright": "bit", "oprnegate": "0", "oprresult": "bit", "oprcanhash": "f", "oprcanmerge": "f"}, {"oprcom": "<=(bit,bit)", "oprcode": "bitge", "oprjoin": "scalargejoinsel", "oprkind": "b", "oprleft": "bit", "oprname": ">=", "oprrest": "scalargesel", "oprright": "bit", "oprnegate": "<(bit,bit)", "oprresult": "bool", "oprcanhash": "f", "oprcanmerge": "f"}, {"oprcom": "<(bit,bit)", "oprcode": "bitgt", "oprjoin": "scalargtjoinsel", "oprkind": "b", "oprleft": "bit", "oprname": ">", "oprrest": "scalargtsel", "oprright": "bit", "oprnegate": "<=(bit,bit)", "oprresult": "bool", "oprcanhash": "f", "oprcanmerge": "f"}, {"oprcom": ">=(bit,bit)", "oprcode": "bitle", "oprjoin": "scalarlejoinsel", "oprkind": "b", "oprleft": "bit", "oprname": "<=", "oprrest": "scalarlesel", "oprright": "bit", "oprnegate": ">(bit,bit)", "oprresult": "bool", "oprcanhash": "f", "oprcanmerge": "f"}, {"oprcom": ">(bit,bit)", "oprcode": "bitlt", "oprjoin": "scalarltjoinsel", "oprkind": "b", "oprleft": "bit", "oprname": "<", "oprrest": "scalarltsel", "oprright": "bit", "oprnegate": ">=(bit,bit)", "oprresult": "bool", "oprcanhash": "f", "oprcanmerge": "f"}, {"oprcom": "<>(bit,bit)", "oprcode": "bitne", "oprjoin": "neqjoinsel", "oprkind": "b", "oprleft": "bit", "oprname": "<>", "oprrest": "neqsel", "oprright": "bit", "oprnegate": "=(bit,bit)", "oprresult": "bool", "oprcanhash": "f", "oprcanmerge": "f"}, {"oprcom": "0", "oprcode": "bitnot", "oprjoin": "-", "oprkind": "l", "oprleft": "0", "oprname": "~", "oprrest": "-", "oprright": "bit", "oprnegate": "0", "oprresult": "bit", "oprcanhash": "f", "oprcanmerge": "f"}, {"oprcom": "|(bit,bit)", "oprcode": "bitor", "oprjoin": "-", "oprkind": "b", "oprleft": "bit", "oprname": "|", "oprrest": "-", "oprright": "bit", "oprnegate": "0", "oprresult": "bit", "oprcanhash": "f", "oprcanmerge": "f"}, {"oprcom": "0", "oprcode": "bitshiftleft", "oprjoin": "-", "oprkind": "b", "oprleft": "bit", "oprname": "<<", "oprrest": "-", "oprright": "int4", "oprnegate": "0", "oprresult": "bit", "oprcanhash": "f", "oprcanmerge": "f"}, {"oprcom": "0", "oprcode": "bitshiftright", "oprjoin": "-", "oprkind": "b", "oprleft": "bit", "oprname": ">>", "oprrest": "-", "oprright": "int4", "oprnegate": "0", "oprresult": "bit", "oprcanhash": "f", "oprcanmerge": "f"}, {"oprcom": "#(bit,bit)", "oprcode": "bitxor", "oprjoin": "-", "oprkind": "b", "oprleft": "bit", "oprname": "#", "oprrest": "-", "oprright": "bit", "oprnegate": "0", "oprresult": "bit", "oprcanhash": "f", "oprcanmerge": "f"}, {"oprcom": "=(bit,bit)", "oprcode": "biteq", "oprjoin": "eqjoinsel", "oprkind": "b", "oprleft": "bit", "oprname": "=", "oprrest": "eqsel", "oprright": "bit", "oprnegate": "<>(bit,bit)", "oprresult": "bool", "oprcanhash": "f", "oprcanmerge": "t"}], "operator_classes": [{"opcname": "bit_minmax_ops", "opcfamily": "brin/bit_minmax_ops", "opcintype": "bit", "opcmethod": "brin", "opcdefault": "t", "opckeytype": "bit"}, {"opcname": "bit_ops", "opcfamily": "btree/bit_ops", "opcintype": "bit", "opcmethod": "btree", "opcdefault": "t", "opckeytype": "0"}]}, "comparison_hash": "2eed105427186037bb33b87c03d56c35abb8227d2e24d4f066ebbbd72a8209af", "operator_classes": [{"opcname": "bit_ops", "opcowner": "POSTGRES", "opcfamily": "btree/bit_ops", "opcintype": "bit", "opcmethod": "btree", "opcdefault": "t", "opckeytype": "0", "opcnamespace": "pg_catalog"}, {"opcname": "bit_minmax_ops", "opcowner": "POSTGRES", "opcfamily": "brin/bit_minmax_ops", "opcintype": "bit", "opcmethod": "brin", "opcdefault": "t", "opckeytype": "bit", "opcnamespace": "pg_catalog"}], "manual_documentation": "dedicated family chapter"}, "from": "17", "comparison": {"available": true, "changes": [], "prose_changed": true}}