{"kind": "type", "slug": "int4", "name": "integer", "major": "18", "snapshot": {"casts": [{"castfunc": "int4(int8)", "castmethod": "f", "castsource": "int8", "casttarget": "int4", "castcontext": "a"}, {"castfunc": "int4(int2)", "castmethod": "f", "castsource": "int2", "casttarget": "int4", "castcontext": "i"}, {"castfunc": "int8(int4)", "castmethod": "f", "castsource": "int4", "casttarget": "int8", "castcontext": "i"}, {"castfunc": "int2(int4)", "castmethod": "f", "castsource": "int4", "casttarget": "int2", "castcontext": "a"}, {"castfunc": "float4(int4)", "castmethod": "f", "castsource": "int4", "casttarget": "float4", "castcontext": "i"}, {"castfunc": "float8(int4)", "castmethod": "f", "castsource": "int4", "casttarget": "float8", "castcontext": "i"}, {"castfunc": "numeric(int4)", "castmethod": "f", "castsource": "int4", "casttarget": "numeric", "castcontext": "i"}, {"castfunc": "int4(float4)", "castmethod": "f", "castsource": "float4", "casttarget": "int4", "castcontext": "a"}, {"castfunc": "int4(float8)", "castmethod": "f", "castsource": "float8", "casttarget": "int4", "castcontext": "a"}, {"castfunc": "int4(numeric)", "castmethod": "f", "castsource": "numeric", "casttarget": "int4", "castcontext": "a"}, {"castfunc": "money(int4)", "castmethod": "f", "castsource": "int4", "casttarget": "money", "castcontext": "a"}, {"castfunc": "bool(int4)", "castmethod": "f", "castsource": "int4", "casttarget": "bool", "castcontext": "e"}, {"castfunc": "int4(bool)", "castmethod": "f", "castsource": "bool", "casttarget": "int4", "castcontext": "e"}, {"castfunc": "0", "castmethod": "b", "castsource": "int4", "casttarget": "oid", "castcontext": "i"}, {"castfunc": "0", "castmethod": "b", "castsource": "oid", "casttarget": "int4", "castcontext": "a"}, {"castfunc": "0", "castmethod": "b", "castsource": "int4", "casttarget": "regproc", "castcontext": "i"}, {"castfunc": "0", "castmethod": "b", "castsource": "regproc", "casttarget": "int4", "castcontext": "a"}, {"castfunc": "0", "castmethod": "b", "castsource": "int4", "casttarget": "regprocedure", "castcontext": "i"}, {"castfunc": "0", "castmethod": "b", "castsource": "regprocedure", "casttarget": "int4", "castcontext": "a"}, {"castfunc": "0", "castmethod": "b", "castsource": "int4", "casttarget": "regoper", "castcontext": "i"}, {"castfunc": "0", "castmethod": "b", "castsource": "regoper", "casttarget": "int4", "castcontext": "a"}, {"castfunc": "0", "castmethod": "b", "castsource": "int4", "casttarget": "regoperator", "castcontext": "i"}, {"castfunc": "0", "castmethod": "b", "castsource": "regoperator", "casttarget": "int4", "castcontext": "a"}, {"castfunc": "0", "castmethod": "b", "castsource": "int4", "casttarget": "regclass", "castcontext": "i"}, {"castfunc": "0", "castmethod": "b", "castsource": "regclass", "casttarget": "int4", "castcontext": "a"}, {"castfunc": "0", "castmethod": "b", "castsource": "int4", "casttarget": "regcollation", "castcontext": "i"}, {"castfunc": "0", "castmethod": "b", "castsource": "regcollation", "casttarget": "int4", "castcontext": "a"}, {"castfunc": "0", "castmethod": "b", "castsource": "int4", "casttarget": "regtype", "castcontext": "i"}, {"castfunc": "0", "castmethod": "b", "castsource": "regtype", "casttarget": "int4", "castcontext": "a"}, {"castfunc": "0", "castmethod": "b", "castsource": "int4", "casttarget": "regconfig", "castcontext": "i"}, {"castfunc": "0", "castmethod": "b", "castsource": "regconfig", "casttarget": "int4", "castcontext": "a"}, {"castfunc": "0", "castmethod": "b", "castsource": "int4", "casttarget": "regdictionary", "castcontext": "i"}, {"castfunc": "0", "castmethod": "b", "castsource": "regdictionary", "casttarget": "int4", "castcontext": "a"}, {"castfunc": "0", "castmethod": "b", "castsource": "int4", "casttarget": "regrole", "castcontext": "i"}, {"castfunc": "0", "castmethod": "b", "castsource": "regrole", "casttarget": "int4", "castcontext": "a"}, {"castfunc": "0", "castmethod": "b", "castsource": "int4", "casttarget": "regnamespace", "castcontext": "i"}, {"castfunc": "0", "castmethod": "b", "castsource": "regnamespace", "casttarget": "int4", "castcontext": "a"}, {"castfunc": "bytea(int4)", "castmethod": "f", "castsource": "int4", "casttarget": "bytea", "castcontext": "e"}, {"castfunc": "int4(bytea)", "castmethod": "f", "castsource": "bytea", "casttarget": "int4", "castcontext": "e"}, {"castfunc": "int4(char)", "castmethod": "f", "castsource": "char", "casttarget": "int4", "castcontext": "e"}, {"castfunc": "char(int4)", "castmethod": "f", "castsource": "int4", "casttarget": "char", "castcontext": "e"}, {"castfunc": "bit(int4,int4)", "castmethod": "f", "castsource": "int4", "casttarget": "bit", "castcontext": "e"}, {"castfunc": "int4(bit)", "castmethod": "f", "castsource": "bit", "casttarget": "int4", "castcontext": "e"}, {"castfunc": "int4(jsonb)", "castmethod": "f", "castsource": "jsonb", "casttarget": "int4", "castcontext": "e"}], "facts": [{"label": "目录名称", "value": "pg_catalog.int4"}, {"label": "类型 OID", "value": "23"}, {"label": "类型种类", "value": "基础类型"}, {"label": "声明长度", "value": "4 字节"}, {"label": "存储策略", "value": "plain"}, {"label": "输入函数", "value": "int4in"}, {"label": "输出函数", "value": "int4out"}, {"label": "手册中的声明", "value": "integer"}, {"label": "存储大小", "value": "4 字节"}, {"label": "手册说明", "value": "整数的常用选择"}, {"label": "范围", "value": "-2147483648 到 +2147483647"}], "ranges": [], "tables": [], "aliases": ["int4", "int"], "catalog": {"oid": "23", "descr": "-2 billion to 2 billion integer, 4-byte storage", "typacl": "_null_", "typlen": "4", "typelem": "0", "typname": "int4", "typsend": "int4send", "typtype": "b", "typalign": "i", "typarray": "0", "typbyval": "t", "typdelim": "','", "typinput": "int4in", "typmodin": "-", "typndims": "0", "typowner": "POSTGRES", "typrelid": "0", "typmodout": "-", "typoutput": "int4out", "typtypmod": "-1", "typanalyze": "-", "typdefault": "_null_", "typnotnull": "f", "typreceive": "int4recv", "typstorage": "p", "typbasetype": "0", "typcategory": "N", "typcollation": "0", "typisdefined": "t", "typnamespace": "pg_catalog", "typsubscript": "-", "typdefaultbin": "_null_", "array_type_oid": "1007", "typispreferred": "f", "array_type_name": "_int4"}, "related": [{"url": "/wiki/catalog/pg_type/?v=18", "label": "pg_type 系统目录"}, {"url": "/wiki/catalog/pg_cast/?v=18", "label": "pg_cast 系统目录"}, {"url": "/wiki/catalog/pg_operator/?v=18", "label": "pg_operator 系统目录"}, {"url": "/wiki/catalog/pg_opclass/?v=18", "label": "pg_opclass 系统目录"}, {"url": "/wiki/type/arrays/?v=18", "label": "数组"}, {"url": "/wiki/indexam/brin/?v=18", "label": "brin 索引访问方法"}, {"url": "/wiki/indexam/btree/?v=18", "label": "btree 索引访问方法"}, {"url": "/wiki/indexam/hash/?v=18", "label": "hash 索引访问方法"}], "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-numeric.html", "path": "datatype-numeric.html", "label": "PostgreSQL 18 English manual", "sha256": "b74619f7ac2f1ca9f85c48073df78c33dd30e464e61baba6008634534edcb500"}, {"url": "https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2", "label": "Matching PostgreSQL source archive", "sha256": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"}], "zh_from": {"kind": "same-version-chinese-manual-with-preserved-translation-of-reverified-type-description", "manual": {"url": "/zh/docs/18/datatype-numeric.html", "anchor": "", "locale": "zh-Hans", "version": "18", "build_id": 107, "page_key": "datatype-numeric.html", "extraction": "concept-introduction", "source_hash": "13301f571b8120837be50ff8002046e6e7b1106ec1b6a8e5373c1c5567cb4ffb", "fragment_sha256": "e7b4f425345df4bff6a5b8573f652e1a8f59dba2984d0ed7bbe5f8636a6af913", "source_revision": "unknown:rendered-translation-baseline", "translation_revision": "git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b", "translated_from_revision": null}, "body_sha256": "d1efdee193704d3937129826a3a8f6da1b1868d3a1363421a732e38f256813b2", "runtime_rerun": false, "summary_translation": {"key": "int4", "kind": "preserved-translation-of-reverified-type-description", "table": "data_type", "version": "18", "source_database": "pgweb", "english_description_sha256": "fb63cd2621ec0a1e6067b27778cfbb89f16726f44e3357963b1185eb20c9d48a", "localized_description_sha256": "181b4f393508109f32ae4605d77f7cba94e17ea09e0d02d318bbdd8eaa9549d3", "original_localization_sources": [{"url": "/docs/18/datatype-money.html", "method": "same-major semantic node", "sha256": "6a3a18c17225f00376744bdae7a7f782102e9a0cce0bc2491e7669a43283455e", "language": "zh", "matched_nodes": ["#DATATYPE-MONEY/div[2]/div[1]/table[0]/tbody[2]/tr[0]/td[1]"]}, {"url": "/docs/18/datatype-numeric.html", "method": "same-major semantic node", "sha256": "3119f68768634c1b35c2d9fb65ecb989addbdf99d88064c8292f114cf3b2b79d", "language": "zh", "matched_nodes": ["#DATATYPE-NUMERIC/div[10]/div[9]/p[1]", "#DATATYPE-NUMERIC/div[4]/div[1]/table[0]/tbody[2]/tr[0]/td[3]", "#DATATYPE-NUMERIC/div[4]/div[1]/table[0]/tbody[2]/tr[1]/td[3]", "#DATATYPE-NUMERIC/div[4]/div[1]/table[0]/tbody[2]/tr[2]/td[3]", "#DATATYPE-NUMERIC/div[4]/div[1]/table[0]/tbody[2]/tr[3]/td[1]", "#DATATYPE-NUMERIC/div[4]/div[1]/table[0]/thead[1]/tr[0]/th[0]", "#DATATYPE-NUMERIC/div[8]/div[13]/h3[0]"]}]}, "authored_translation": "preserved-translation-of-reverified-type-description", "source_facts_revision": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"}, "coverage": "source inventory; exact declared input types for operator classes", "facts_zh": [{"label": "目录名称", "value": "pg_catalog.int4"}, {"label": "类型 OID", "value": "23"}, {"label": "类型种类", "value": "基础类型"}, {"label": "声明长度", "value": "4 字节"}, {"label": "存储策略", "value": "plain"}, {"label": "输入函数", "value": "int4in"}, {"label": "输出函数", "value": "int4out"}, {"label": "手册中的声明", "value": "integer"}, {"label": "存储大小", "value": "4 字节"}, {"label": "手册说明", "value": "整数的常用选择"}, {"label": "范围", "value": "-2147483648 到 +2147483647"}], "sections": [], "center_zh": {"title": "integer", "locale": "zh-Hans", "source": {"key": "int4", "locale": "zh-Hans", "version": "18", "text_hash": "526f32e0090c945597564588b9da4a7f5cad5eed023b36ad8dd68238de2a42f0", "collection": "type", "dataset_hash": "7c31b524dfe136022d39a6ae8dcfac6b3bbd5f8fdaf422536599981252aff0c9", "source_database": "center", "source_revision": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"}, "payload": {"facts": [{"label": "目录名称", "value": "pg_catalog.int4"}, {"label": "类型 OID", "value": "23"}, {"label": "类型种类", "value": "基础类型"}, {"label": "声明长度", "value": "4 字节"}, {"label": "存储策略", "value": "plain"}, {"label": "输入函数", "value": "int4in"}, {"label": "输出函数", "value": "int4out"}, {"label": "手册中的声明", "value": "integer"}, {"label": "存储大小", "value": "4 字节"}, {"label": "手册说明", "value": "整数的常用选择"}, {"label": "范围", "value": "-2147483648 到 +2147483647"}], "tables": [], "zh_from": {"kind": "same-version-chinese-manual-with-preserved-translation-of-reverified-type-description", "manual": {"url": "/zh/docs/18/datatype-numeric.html", "anchor": "", "locale": "zh-Hans", "version": "18", "build_id": 107, "page_key": "datatype-numeric.html", "extraction": "concept-introduction", "source_hash": "13301f571b8120837be50ff8002046e6e7b1106ec1b6a8e5373c1c5567cb4ffb", "fragment_sha256": "e7b4f425345df4bff6a5b8573f652e1a8f59dba2984d0ed7bbe5f8636a6af913", "source_revision": "unknown:rendered-translation-baseline", "translation_revision": "git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b", "translated_from_revision": null}, "body_sha256": "d1efdee193704d3937129826a3a8f6da1b1868d3a1363421a732e38f256813b2", "runtime_rerun": false, "summary_translation": {"key": "int4", "kind": "preserved-translation-of-reverified-type-description", "table": "data_type", "version": "18", "source_database": "pgweb", "english_description_sha256": "fb63cd2621ec0a1e6067b27778cfbb89f16726f44e3357963b1185eb20c9d48a", "localized_description_sha256": "181b4f393508109f32ae4605d77f7cba94e17ea09e0d02d318bbdd8eaa9549d3", "original_localization_sources": [{"url": "/docs/18/datatype-money.html", "method": "same-major semantic node", "sha256": "6a3a18c17225f00376744bdae7a7f782102e9a0cce0bc2491e7669a43283455e", "language": "zh", "matched_nodes": ["#DATATYPE-MONEY/div[2]/div[1]/table[0]/tbody[2]/tr[0]/td[1]"]}, {"url": "/docs/18/datatype-numeric.html", "method": "same-major semantic node", "sha256": "3119f68768634c1b35c2d9fb65ecb989addbdf99d88064c8292f114cf3b2b79d", "language": "zh", "matched_nodes": ["#DATATYPE-NUMERIC/div[10]/div[9]/p[1]", "#DATATYPE-NUMERIC/div[4]/div[1]/table[0]/tbody[2]/tr[0]/td[3]", "#DATATYPE-NUMERIC/div[4]/div[1]/table[0]/tbody[2]/tr[1]/td[3]", "#DATATYPE-NUMERIC/div[4]/div[1]/table[0]/tbody[2]/tr[2]/td[3]", "#DATATYPE-NUMERIC/div[4]/div[1]/table[0]/tbody[2]/tr[3]/td[1]", "#DATATYPE-NUMERIC/div[4]/div[1]/table[0]/thead[1]/tr[0]/th[0]", "#DATATYPE-NUMERIC/div[8]/div[13]/h3[0]"]}]}, "authored_translation": "preserved-translation-of-reverified-type-description", "source_facts_revision": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"}, "sections": [], "description_zh": "有符号四字节整数", "description_zh_html": "<p>有符号四字节整数</p><h3>同版本中文手册节选</h3><p>\n    数字类型包括 2、4、8 字节的整数，4、8 字节的浮点数，以及可选精度的小数。<a class=\"xref\" href=\"/zh/docs/18/datatype-numeric.html#DATATYPE-NUMERIC-TABLE\">表 8.2</a> 列出了所有可用类型。\n   </p><p>\n    数字类型常量的语法在<a class=\"xref\" href=\"/zh/docs/18/sql-syntax-lexical.html#SQL-SYNTAX-CONSTANTS\">第 4.1.2 节</a>里描述。数字类型有一整套对应的算术操作符和函数。相关信息请参考<a class=\"xref\" href=\"/zh/docs/18/functions.html\">第 9 章</a>。下面的几节详细描述这些类型。\n   </p><p><a href=\"/zh/docs/18/datatype-numeric.html\">查看完整中文手册与上下文</a>。</p>"}, "summary": "有符号四字节整数", "version": "18", "link_map": {"/zh/docs/18/functions.html": "/docs/18/functions.html", "/zh/docs/18/datatype-numeric.html": "/docs/18/datatype-numeric.html", "/zh/docs/18/datatype-numeric.html#DATATYPE-NUMERIC-TABLE": "/docs/18/datatype-numeric.html#DATATYPE-NUMERIC-TABLE", "/zh/docs/18/sql-syntax-lexical.html#SQL-SYNTAX-CONSTANTS": "/docs/18/sql-syntax-lexical.html#SQL-SYNTAX-CONSTANTS"}, "body_html": "<p>有符号四字节整数</p><h3>同版本中文手册节选</h3><p>\n    数字类型包括 2、4、8 字节的整数，4、8 字节的浮点数，以及可选精度的小数。<a href=\"/zh/docs/18/datatype-numeric.html#DATATYPE-NUMERIC-TABLE\" rel=\"nofollow\">表 8.2</a> 列出了所有可用类型。\n   </p><p>\n    数字类型常量的语法在<a href=\"/zh/docs/18/sql-syntax-lexical.html#SQL-SYNTAX-CONSTANTS\" rel=\"nofollow\">第 4.1.2 节</a>里描述。数字类型有一整套对应的算术操作符和函数。相关信息请参考<a href=\"/zh/docs/18/functions.html\" rel=\"nofollow\">第 9 章</a>。下面的几节详细描述这些类型。\n   </p><p><a href=\"/zh/docs/18/datatype-numeric.html\" rel=\"nofollow\">查看完整中文手册与上下文</a>。</p>", "body_sha256": "2e810afcebbece79f0fbaf820cd3d10dcae8b3b0f1e1427996fac2d7166d6199", "content_hash": "526f32e0090c945597564588b9da4a7f5cad5eed023b36ad8dd68238de2a42f0", "source_database": "center", "source_revision": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"}, "operators": [{"oid": "15", "descr": "equal", "oprcom": "=(int8,int4)", "oprcode": "int48eq", "oprjoin": "eqjoinsel", "oprkind": "b", "oprleft": "int4", "oprname": "=", "oprrest": "eqsel", "oprowner": "POSTGRES", "oprright": "int8", "oprnegate": "<>(int4,int8)", "oprresult": "bool", "oprcanhash": "t", "oprcanmerge": "t", "oprnamespace": "pg_catalog"}, {"oid": "36", "descr": "not equal", "oprcom": "<>(int8,int4)", "oprcode": "int48ne", "oprjoin": "neqjoinsel", "oprkind": "b", "oprleft": "int4", "oprname": "<>", "oprrest": "neqsel", "oprowner": "POSTGRES", "oprright": "int8", "oprnegate": "=(int4,int8)", "oprresult": "bool", "oprcanhash": "f", "oprcanmerge": "f", "oprnamespace": "pg_catalog"}, {"oid": "37", "descr": "less than", "oprcom": ">(int8,int4)", "oprcode": "int48lt", "oprjoin": "scalarltjoinsel", "oprkind": "b", "oprleft": "int4", "oprname": "<", "oprrest": "scalarltsel", "oprowner": "POSTGRES", "oprright": "int8", "oprnegate": ">=(int4,int8)", "oprresult": "bool", "oprcanhash": "f", "oprcanmerge": "f", "oprnamespace": "pg_catalog"}, {"oid": "76", "descr": "greater than", "oprcom": "<(int8,int4)", "oprcode": "int48gt", "oprjoin": "scalargtjoinsel", "oprkind": "b", "oprleft": "int4", "oprname": ">", "oprrest": "scalargtsel", "oprowner": "POSTGRES", "oprright": "int8", "oprnegate": "<=(int4,int8)", "oprresult": "bool", "oprcanhash": "f", "oprcanmerge": "f", "oprnamespace": "pg_catalog"}, {"oid": "80", "descr": "less than or equal", "oprcom": ">=(int8,int4)", "oprcode": "int48le", "oprjoin": "scalarlejoinsel", "oprkind": "b", "oprleft": "int4", "oprname": "<=", "oprrest": "scalarlesel", "oprowner": "POSTGRES", "oprright": "int8", "oprnegate": ">(int4,int8)", "oprresult": "bool", "oprcanhash": "f", "oprcanmerge": "f", "oprnamespace": "pg_catalog"}, {"oid": "82", "descr": "greater than or equal", "oprcom": "<=(int8,int4)", "oprcode": "int48ge", "oprjoin": "scalargejoinsel", "oprkind": "b", "oprleft": "int4", "oprname": ">=", "oprrest": "scalargesel", "oprowner": "POSTGRES", "oprright": "int8", "oprnegate": "<(int4,int8)", "oprresult": "bool", "oprcanhash": "f", "oprcanmerge": "f", "oprnamespace": "pg_catalog"}, {"oid": "96", "descr": "equal", "oprcom": "=(int4,int4)", "oprcode": "int4eq", "oprjoin": "eqjoinsel", "oprkind": "b", "oprleft": "int4", "oprname": "=", "oprrest": "eqsel", "oprowner": "POSTGRES", "oprright": "int4", "oprnegate": "<>(int4,int4)", "oprresult": "bool", "oid_symbol": "Int4EqualOperator", "oprcanhash": "t", "oprcanmerge": "t", "oprnamespace": "pg_catalog"}, {"oid": "97", "descr": "less than", "oprcom": ">(int4,int4)", "oprcode": "int4lt", "oprjoin": "scalarltjoinsel", "oprkind": "b", "oprleft": "int4", "oprname": "<", "oprrest": "scalarltsel", "oprowner": "POSTGRES", "oprright": "int4", "oprnegate": ">=(int4,int4)", "oprresult": "bool", "oid_symbol": "Int4LessOperator", "oprcanhash": "f", "oprcanmerge": "f", "oprnamespace": "pg_catalog"}, {"oid": "353", "descr": "equal", "oprcom": "0", "oprcode": "xideqint4", "oprjoin": "eqjoinsel", "oprkind": "b", "oprleft": "xid", "oprname": "=", "oprrest": "eqsel", "oprowner": "POSTGRES", "oprright": "int4", "oprnegate": "<>(xid,int4)", "oprresult": "bool", "oprcanhash": "f", "oprcanmerge": "f", "oprnamespace": "pg_catalog"}, {"oid": "3316", "descr": "not equal", "oprcom": "0", "oprcode": "xidneqint4", "oprjoin": "neqjoinsel", "oprkind": "b", "oprleft": "xid", "oprname": "<>", "oprrest": "neqsel", "oprowner": "POSTGRES", "oprright": "int4", "oprnegate": "=(xid,int4)", "oprresult": "bool", "oprcanhash": "f", "oprcanmerge": "f", "oprnamespace": "pg_catalog"}, {"oid": "416", "descr": "equal", "oprcom": "=(int4,int8)", "oprcode": "int84eq", "oprjoin": "eqjoinsel", "oprkind": "b", "oprleft": "int8", "oprname": "=", "oprrest": "eqsel", "oprowner": "POSTGRES", "oprright": "int4", "oprnegate": "<>(int8,int4)", "oprresult": "bool", "oprcanhash": "t", "oprcanmerge": "t", "oprnamespace": "pg_catalog"}, {"oid": "417", "descr": "not equal", "oprcom": "<>(int4,int8)", "oprcode": "int84ne", "oprjoin": "neqjoinsel", "oprkind": "b", "oprleft": "int8", "oprname": "<>", "oprrest": "neqsel", "oprowner": "POSTGRES", "oprright": "int4", "oprnegate": "=(int8,int4)", "oprresult": "bool", "oprcanhash": "f", "oprcanmerge": "f", "oprnamespace": "pg_catalog"}, {"oid": "418", "descr": "less than", "oprcom": ">(int4,int8)", "oprcode": "int84lt", "oprjoin": "scalarltjoinsel", "oprkind": "b", "oprleft": "int8", "oprname": "<", "oprrest": "scalarltsel", "oprowner": "POSTGRES", "oprright": "int4", "oprnegate": ">=(int8,int4)", "oprresult": "bool", "oprcanhash": "f", "oprcanmerge": "f", "oprnamespace": "pg_catalog"}, {"oid": "419", "descr": "greater than", "oprcom": "<(int4,int8)", "oprcode": "int84gt", "oprjoin": "scalargtjoinsel", "oprkind": "b", "oprleft": "int8", "oprname": ">", "oprrest": "scalargtsel", "oprowner": "POSTGRES", "oprright": "int4", "oprnegate": "<=(int8,int4)", "oprresult": "bool", "oprcanhash": "f", "oprcanmerge": "f", "oprnamespace": "pg_catalog"}, {"oid": "420", "descr": "less than or equal", "oprcom": ">=(int4,int8)", "oprcode": "int84le", "oprjoin": "scalarlejoinsel", "oprkind": "b", "oprleft": "int8", "oprname": "<=", "oprrest": "scalarlesel", "oprowner": "POSTGRES", "oprright": "int4", "oprnegate": ">(int8,int4)", "oprresult": "bool", "oprcanhash": "f", "oprcanmerge": "f", "oprnamespace": "pg_catalog"}, {"oid": "430", "descr": "greater than or equal", "oprcom": "<=(int4,int8)", "oprcode": "int84ge", "oprjoin": "scalargejoinsel", "oprkind": "b", "oprleft": "int8", "oprname": ">=", "oprrest": "scalargesel", "oprowner": "POSTGRES", "oprright": "int4", "oprnegate": "<(int8,int4)", "oprresult": "bool", "oprcanhash": "f", "oprcanmerge": "f", "oprnamespace": "pg_catalog"}, {"oid": "514", "descr": "multiply", "oprcom": "*(int4,int4)", "oprcode": "int4mul", "oprjoin": "-", "oprkind": "b", "oprleft": "int4", "oprname": "*", "oprrest": "-", "oprowner": "POSTGRES", "oprright": "int4", "oprnegate": "0", "oprresult": "int4", "oprcanhash": "f", "oprcanmerge": "f", "oprnamespace": "pg_catalog"}, {"oid": "518", "descr": "not equal", "oprcom": "<>(int4,int4)", "oprcode": "int4ne", "oprjoin": "neqjoinsel", "oprkind": "b", "oprleft": "int4", "oprname": "<>", "oprrest": "neqsel", "oprowner": "POSTGRES", "oprright": "int4", "oprnegate": "=(int4,int4)", "oprresult": "bool", "oprcanhash": "f", "oprcanmerge": "f", "oprnamespace": "pg_catalog"}, {"oid": "521", "descr": "greater than", "oprcom": "<(int4,int4)", "oprcode": "int4gt", "oprjoin": "scalargtjoinsel", "oprkind": "b", "oprleft": "int4", "oprname": ">", "oprrest": "scalargtsel", "oprowner": "POSTGRES", "oprright": "int4", "oprnegate": "<=(int4,int4)", "oprresult": "bool", "oprcanhash": "f", "oprcanmerge": "f", "oprnamespace": "pg_catalog"}, {"oid": "523", "descr": "less than or equal", "oprcom": ">=(int4,int4)", "oprcode": "int4le", "oprjoin": "scalarlejoinsel", "oprkind": "b", "oprleft": "int4", "oprname": "<=", "oprrest": "scalarlesel", "oprowner": "POSTGRES", "oprright": "int4", "oprnegate": ">(int4,int4)", "oprresult": "bool", "oprcanhash": "f", "oprcanmerge": "f", "oprnamespace": "pg_catalog"}, {"oid": "525", "descr": "greater than or equal", "oprcom": "<=(int4,int4)", "oprcode": "int4ge", "oprjoin": "scalargejoinsel", "oprkind": "b", "oprleft": "int4", "oprname": ">=", "oprrest": "scalargesel", "oprowner": "POSTGRES", "oprright": "int4", "oprnegate": "<(int4,int4)", "oprresult": "bool", "oprcanhash": "f", "oprcanmerge": "f", "oprnamespace": "pg_catalog"}, {"oid": "528", "descr": "divide", "oprcom": "0", "oprcode": "int4div", "oprjoin": "-", "oprkind": "b", "oprleft": "int4", "oprname": "/", "oprrest": "-", "oprowner": "POSTGRES", "oprright": "int4", "oprnegate": "0", "oprresult": "int4", "oprcanhash": "f", "oprcanmerge": "f", "oprnamespace": "pg_catalog"}, {"oid": "530", "descr": "modulus", "oprcom": "0", "oprcode": "int4mod", "oprjoin": "-", "oprkind": "b", "oprleft": "int4", "oprname": "%", "oprrest": "-", "oprowner": "POSTGRES", "oprright": "int4", "oprnegate": "0", "oprresult": "int4", "oprcanhash": "f", "oprcanmerge": "f", "oprnamespace": "pg_catalog"}, {"oid": "532", "descr": "equal", "oprcom": "=(int4,int2)", "oprcode": "int24eq", "oprjoin": "eqjoinsel", "oprkind": "b", "oprleft": "int2", "oprname": "=", "oprrest": "eqsel", "oprowner": "POSTGRES", "oprright": "int4", "oprnegate": "<>(int2,int4)", "oprresult": "bool", "oprcanhash": "t", "oprcanmerge": "t", "oprnamespace": "pg_catalog"}, {"oid": "533", "descr": "equal", "oprcom": "=(int2,int4)", "oprcode": "int42eq", "oprjoin": "eqjoinsel", "oprkind": "b", "oprleft": "int4", "oprname": "=", "oprrest": "eqsel", "oprowner": "POSTGRES", "oprright": "int2", "oprnegate": "<>(int4,int2)", "oprresult": "bool", "oprcanhash": "t", "oprcanmerge": "t", "oprnamespace": "pg_catalog"}, {"oid": "534", "descr": "less than", "oprcom": ">(int4,int2)", "oprcode": "int24lt", "oprjoin": "scalarltjoinsel", "oprkind": "b", "oprleft": "int2", "oprname": "<", "oprrest": "scalarltsel", "oprowner": "POSTGRES", "oprright": "int4", "oprnegate": ">=(int2,int4)", "oprresult": "bool", "oprcanhash": "f", "oprcanmerge": "f", "oprnamespace": "pg_catalog"}, {"oid": "535", "descr": "less than", "oprcom": ">(int2,int4)", "oprcode": "int42lt", "oprjoin": "scalarltjoinsel", "oprkind": "b", "oprleft": "int4", "oprname": "<", "oprrest": "scalarltsel", "oprowner": "POSTGRES", "oprright": "int2", "oprnegate": ">=(int4,int2)", "oprresult": "bool", "oprcanhash": "f", "oprcanmerge": "f", "oprnamespace": "pg_catalog"}, {"oid": "536", "descr": "greater than", "oprcom": "<(int4,int2)", "oprcode": "int24gt", "oprjoin": "scalargtjoinsel", "oprkind": "b", "oprleft": "int2", "oprname": ">", "oprrest": "scalargtsel", "oprowner": "POSTGRES", "oprright": "int4", "oprnegate": "<=(int2,int4)", "oprresult": "bool", "oprcanhash": "f", "oprcanmerge": "f", "oprnamespace": "pg_catalog"}, {"oid": "537", "descr": "greater than", "oprcom": "<(int2,int4)", "oprcode": "int42gt", "oprjoin": "scalargtjoinsel", "oprkind": "b", "oprleft": "int4", "oprname": ">", "oprrest": "scalargtsel", "oprowner": "POSTGRES", "oprright": "int2", "oprnegate": "<=(int4,int2)", "oprresult": "bool", "oprcanhash": "f", "oprcanmerge": "f", "oprnamespace": "pg_catalog"}, {"oid": "538", "descr": "not equal", "oprcom": "<>(int4,int2)", "oprcode": "int24ne", "oprjoin": "neqjoinsel", "oprkind": "b", "oprleft": "int2", "oprname": "<>", "oprrest": "neqsel", "oprowner": "POSTGRES", "oprright": "int4", "oprnegate": "=(int2,int4)", "oprresult": "bool", "oprcanhash": "f", "oprcanmerge": "f", "oprnamespace": "pg_catalog"}, {"oid": "539", "descr": "not equal", "oprcom": "<>(int2,int4)", "oprcode": "int42ne", "oprjoin": "neqjoinsel", "oprkind": "b", "oprleft": "int4", "oprname": "<>", "oprrest": "neqsel", "oprowner": "POSTGRES", "oprright": "int2", "oprnegate": "=(int4,int2)", "oprresult": "bool", "oprcanhash": "f", "oprcanmerge": "f", "oprnamespace": "pg_catalog"}, {"oid": "540", "descr": "less than or equal", "oprcom": ">=(int4,int2)", "oprcode": "int24le", "oprjoin": "scalarlejoinsel", "oprkind": "b", "oprleft": "int2", "oprname": "<=", "oprrest": "scalarlesel", "oprowner": "POSTGRES", "oprright": "int4", "oprnegate": ">(int2,int4)", "oprresult": "bool", "oprcanhash": "f", "oprcanmerge": "f", "oprnamespace": "pg_catalog"}, {"oid": "541", "descr": "less than or equal", "oprcom": ">=(int2,int4)", "oprcode": "int42le", "oprjoin": "scalarlejoinsel", "oprkind": "b", "oprleft": "int4", "oprname": "<=", "oprrest": "scalarlesel", "oprowner": "POSTGRES", "oprright": "int2", "oprnegate": ">(int4,int2)", "oprresult": "bool", "oprcanhash": "f", "oprcanmerge": "f", "oprnamespace": "pg_catalog"}, {"oid": "542", "descr": "greater than or equal", "oprcom": "<=(int4,int2)", "oprcode": "int24ge", "oprjoin": "scalargejoinsel", "oprkind": "b", "oprleft": "int2", "oprname": ">=", "oprrest": "scalargesel", "oprowner": "POSTGRES", "oprright": "int4", "oprnegate": "<(int2,int4)", "oprresult": "bool", "oprcanhash": "f", "oprcanmerge": "f", "oprnamespace": "pg_catalog"}, {"oid": "543", "descr": "greater than or equal", "oprcom": "<=(int2,int4)", "oprcode": "int42ge", "oprjoin": "scalargejoinsel", "oprkind": "b", "oprleft": "int4", "oprname": ">=", "oprrest": "scalargesel", "oprowner": "POSTGRES", "oprright": "int2", "oprnegate": "<(int4,int2)", "oprresult": "bool", "oprcanhash": "f", "oprcanmerge": "f", "oprnamespace": "pg_catalog"}, {"oid": "544", "descr": "multiply", "oprcom": "*(int4,int2)", "oprcode": "int24mul", "oprjoin": "-", "oprkind": "b", "oprleft": "int2", "oprname": "*", "oprrest": "-", "oprowner": "POSTGRES", "oprright": "int4", "oprnegate": "0", "oprresult": "int4", "oprcanhash": "f", "oprcanmerge": "f", "oprnamespace": "pg_catalog"}, {"oid": "545", "descr": "multiply", "oprcom": "*(int2,int4)", "oprcode": "int42mul", "oprjoin": "-", "oprkind": "b", "oprleft": "int4", "oprname": "*", "oprrest": "-", "oprowner": "POSTGRES", "oprright": "int2", "oprnegate": "0", "oprresult": "int4", "oprcanhash": "f", "oprcanmerge": "f", "oprnamespace": "pg_catalog"}, {"oid": "546", "descr": "divide", "oprcom": "0", "oprcode": "int24div", "oprjoin": "-", "oprkind": "b", "oprleft": "int2", "oprname": "/", "oprrest": "-", "oprowner": "POSTGRES", "oprright": "int4", "oprnegate": "0", "oprresult": "int4", "oprcanhash": "f", "oprcanmerge": "f", "oprnamespace": "pg_catalog"}, {"oid": "547", "descr": "divide", "oprcom": "0", "oprcode": "int42div", "oprjoin": "-", "oprkind": "b", "oprleft": "int4", "oprname": "/", "oprrest": "-", "oprowner": "POSTGRES", "oprright": "int2", "oprnegate": "0", "oprresult": "int4", "oprcanhash": "f", "oprcanmerge": "f", "oprnamespace": "pg_catalog"}, {"oid": "551", "descr": "add", "oprcom": "+(int4,int4)", "oprcode": "int4pl", "oprjoin": "-", "oprkind": "b", "oprleft": "int4", "oprname": "+", "oprrest": "-", "oprowner": "POSTGRES", "oprright": "int4", "oprnegate": "0", "oprresult": "int4", "oprcanhash": "f", "oprcanmerge": "f", "oprnamespace": "pg_catalog"}, {"oid": "552", "descr": "add", "oprcom": "+(int4,int2)", "oprcode": "int24pl", "oprjoin": "-", "oprkind": "b", "oprleft": "int2", "oprname": "+", "oprrest": "-", "oprowner": "POSTGRES", "oprright": "int4", "oprnegate": "0", "oprresult": "int4", "oprcanhash": "f", "oprcanmerge": "f", "oprnamespace": "pg_catalog"}, {"oid": "553", "descr": "add", "oprcom": "+(int2,int4)", "oprcode": "int42pl", "oprjoin": "-", "oprkind": "b", "oprleft": "int4", "oprname": "+", "oprrest": "-", "oprowner": "POSTGRES", "oprright": "int2", "oprnegate": "0", "oprresult": "int4", "oprcanhash": "f", "oprcanmerge": "f", "oprnamespace": "pg_catalog"}, {"oid": "555", "descr": "subtract", "oprcom": "0", "oprcode": "int4mi", "oprjoin": "-", "oprkind": "b", "oprleft": "int4", "oprname": "-", "oprrest": "-", "oprowner": "POSTGRES", "oprright": "int4", "oprnegate": "0", "oprresult": "int4", "oprcanhash": "f", "oprcanmerge": "f", "oprnamespace": "pg_catalog"}, {"oid": "556", "descr": "subtract", "oprcom": "0", "oprcode": "int24mi", "oprjoin": "-", "oprkind": "b", "oprleft": "int2", "oprname": "-", "oprrest": "-", "oprowner": "POSTGRES", "oprright": "int4", "oprnegate": "0", "oprresult": "int4", "oprcanhash": "f", "oprcanmerge": "f", "oprnamespace": "pg_catalog"}, {"oid": "557", "descr": "subtract", "oprcom": "0", "oprcode": "int42mi", "oprjoin": "-", "oprkind": "b", "oprleft": "int4", "oprname": "-", "oprrest": "-", "oprowner": "POSTGRES", "oprright": "int2", "oprnegate": "0", "oprresult": "int4", "oprcanhash": "f", "oprcanmerge": "f", "oprnamespace": "pg_catalog"}, {"oid": "558", "descr": "negate", "oprcom": "0", "oprcode": "int4um", "oprjoin": "-", "oprkind": "l", "oprleft": "0", "oprname": "-", "oprrest": "-", "oprowner": "POSTGRES", "oprright": "int4", "oprnegate": "0", "oprresult": "int4", "oprcanhash": "f", "oprcanmerge": "f", "oprnamespace": "pg_catalog"}, {"oid": "688", "descr": "add", "oprcom": "+(int4,int8)", "oprcode": "int84pl", "oprjoin": "-", "oprkind": "b", "oprleft": "int8", "oprname": "+", "oprrest": "-", "oprowner": "POSTGRES", "oprright": "int4", "oprnegate": "0", "oprresult": "int8", "oprcanhash": "f", "oprcanmerge": "f", "oprnamespace": "pg_catalog"}, {"oid": "689", "descr": "subtract", "oprcom": "0", "oprcode": "int84mi", "oprjoin": "-", "oprkind": "b", "oprleft": "int8", "oprname": "-", "oprrest": "-", "oprowner": "POSTGRES", "oprright": "int4", "oprnegate": "0", "oprresult": "int8", "oprcanhash": "f", "oprcanmerge": "f", "oprnamespace": "pg_catalog"}, {"oid": "690", "descr": "multiply", "oprcom": "*(int4,int8)", "oprcode": "int84mul", "oprjoin": "-", "oprkind": "b", "oprleft": "int8", "oprname": "*", "oprrest": "-", "oprowner": "POSTGRES", "oprright": "int4", "oprnegate": "0", "oprresult": "int8", "oprcanhash": "f", "oprcanmerge": "f", "oprnamespace": "pg_catalog"}, {"oid": "691", "descr": "divide", "oprcom": "0", "oprcode": "int84div", "oprjoin": "-", "oprkind": "b", "oprleft": "int8", "oprname": "/", "oprrest": "-", "oprowner": "POSTGRES", "oprright": "int4", "oprnegate": "0", "oprresult": "int8", "oprcanhash": "f", "oprcanmerge": "f", "oprnamespace": "pg_catalog"}, {"oid": "692", "descr": "add", "oprcom": "+(int8,int4)", "oprcode": "int48pl", "oprjoin": "-", "oprkind": "b", "oprleft": "int4", "oprname": "+", "oprrest": "-", "oprowner": "POSTGRES", "oprright": "int8", "oprnegate": "0", "oprresult": "int8", "oprcanhash": "f", "oprcanmerge": "f", "oprnamespace": "pg_catalog"}, {"oid": "693", "descr": "subtract", "oprcom": "0", "oprcode": "int48mi", "oprjoin": "-", "oprkind": "b", "oprleft": "int4", "oprname": "-", "oprrest": "-", "oprowner": "POSTGRES", "oprright": "int8", "oprnegate": "0", "oprresult": "int8", "oprcanhash": "f", "oprcanmerge": "f", "oprnamespace": "pg_catalog"}, {"oid": "694", "descr": "multiply", "oprcom": "*(int8,int4)", "oprcode": "int48mul", "oprjoin": "-", "oprkind": "b", "oprleft": "int4", "oprname": "*", "oprrest": "-", "oprowner": "POSTGRES", "oprright": "int8", "oprnegate": "0", "oprresult": "int8", "oprcanhash": "f", "oprcanmerge": "f", "oprnamespace": "pg_catalog"}, {"oid": "695", "descr": "divide", "oprcom": "0", "oprcode": "int48div", "oprjoin": "-", "oprkind": "b", "oprleft": "int4", "oprname": "/", "oprrest": "-", "oprowner": "POSTGRES", "oprright": "int8", "oprnegate": "0", "oprresult": "int8", "oprcanhash": "f", "oprcanmerge": "f", "oprnamespace": "pg_catalog"}, {"oid": "773", "descr": "absolute value", "oprcom": "0", "oprcode": "int4abs", "oprjoin": "-", "oprkind": "l", "oprleft": "0", "oprname": "@", "oprrest": "-", "oprowner": "POSTGRES", "oprright": "int4", "oprnegate": "0", "oprresult": "int4", "oprcanhash": "f", "oprcanmerge": "f", "oprnamespace": "pg_catalog"}, {"oid": "912", "descr": "multiply", "oprcom": "*(int4,money)", "oprcode": "cash_mul_int4", "oprjoin": "-", "oprkind": "b", "oprleft": "money", "oprname": "*", "oprrest": "-", "oprowner": "POSTGRES", "oprright": "int4", "oprnegate": "0", "oprresult": "money", "oprcanhash": "f", "oprcanmerge": "f", "oprnamespace": "pg_catalog"}, {"oid": "913", "descr": "divide", "oprcom": "0", "oprcode": "cash_div_int4", "oprjoin": "-", "oprkind": "b", "oprleft": "money", "oprname": "/", "oprrest": "-", "oprowner": "POSTGRES", "oprright": "int4", "oprnegate": "0", "oprresult": "money", "oprcanhash": "f", "oprcanmerge": "f", "oprnamespace": "pg_catalog"}, {"oid": "917", "descr": "multiply", "oprcom": "*(money,int4)", "oprcode": "int4_mul_cash", "oprjoin": "-", "oprkind": "b", "oprleft": "int4", "oprname": "*", "oprrest": "-", "oprowner": "POSTGRES", "oprright": "money", "oprnegate": "0", "oprresult": "money", "oprcanhash": "f", "oprcanmerge": "f", "oprnamespace": "pg_catalog"}, {"oid": "1100", "descr": "add", "oprcom": "+(int4,date)", "oprcode": "date_pli", "oprjoin": "-", "oprkind": "b", "oprleft": "date", "oprname": "+", "oprrest": "-", "oprowner": "POSTGRES", "oprright": "int4", "oprnegate": "0", "oprresult": "date", "oprcanhash": "f", "oprcanmerge": "f", "oprnamespace": "pg_catalog"}, {"oid": "1101", "descr": "subtract", "oprcom": "0", "oprcode": "date_mii", "oprjoin": "-", "oprkind": "b", "oprleft": "date", "oprname": "-", "oprrest": "-", "oprowner": "POSTGRES", "oprright": "int4", "oprnegate": "0", "oprresult": "date", "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"}, {"oid": "1878", "descr": "bitwise shift left", "oprcom": "0", "oprcode": "int2shl", "oprjoin": "-", "oprkind": "b", "oprleft": "int2", "oprname": "<<", "oprrest": "-", "oprowner": "POSTGRES", "oprright": "int4", "oprnegate": "0", "oprresult": "int2", "oprcanhash": "f", "oprcanmerge": "f", "oprnamespace": "pg_catalog"}, {"oid": "1879", "descr": "bitwise shift right", "oprcom": "0", "oprcode": "int2shr", "oprjoin": "-", "oprkind": "b", "oprleft": "int2", "oprname": ">>", "oprrest": "-", "oprowner": "POSTGRES", "oprright": "int4", "oprnegate": "0", "oprresult": "int2", "oprcanhash": "f", "oprcanmerge": "f", "oprnamespace": "pg_catalog"}, {"oid": "1880", "descr": "bitwise and", "oprcom": "&(int4,int4)", "oprcode": "int4and", "oprjoin": "-", "oprkind": "b", "oprleft": "int4", "oprname": "&", "oprrest": "-", "oprowner": "POSTGRES", "oprright": "int4", "oprnegate": "0", "oprresult": "int4", "oprcanhash": "f", "oprcanmerge": "f", "oprnamespace": "pg_catalog"}, {"oid": "1881", "descr": "bitwise or", "oprcom": "|(int4,int4)", "oprcode": "int4or", "oprjoin": "-", "oprkind": "b", "oprleft": "int4", "oprname": "|", "oprrest": "-", "oprowner": "POSTGRES", "oprright": "int4", "oprnegate": "0", "oprresult": "int4", "oprcanhash": "f", "oprcanmerge": "f", "oprnamespace": "pg_catalog"}, {"oid": "1882", "descr": "bitwise exclusive or", "oprcom": "#(int4,int4)", "oprcode": "int4xor", "oprjoin": "-", "oprkind": "b", "oprleft": "int4", "oprname": "#", "oprrest": "-", "oprowner": "POSTGRES", "oprright": "int4", "oprnegate": "0", "oprresult": "int4", "oprcanhash": "f", "oprcanmerge": "f", "oprnamespace": "pg_catalog"}, {"oid": "1883", "descr": "bitwise not", "oprcom": "0", "oprcode": "int4not", "oprjoin": "-", "oprkind": "l", "oprleft": "0", "oprname": "~", "oprrest": "-", "oprowner": "POSTGRES", "oprright": "int4", "oprnegate": "0", "oprresult": "int4", "oprcanhash": "f", "oprcanmerge": "f", "oprnamespace": "pg_catalog"}, {"oid": "1884", "descr": "bitwise shift left", "oprcom": "0", "oprcode": "int4shl", "oprjoin": "-", "oprkind": "b", "oprleft": "int4", "oprname": "<<", "oprrest": "-", "oprowner": "POSTGRES", "oprright": "int4", "oprnegate": "0", "oprresult": "int4", "oprcanhash": "f", "oprcanmerge": "f", "oprnamespace": "pg_catalog"}, {"oid": "1885", "descr": "bitwise shift right", "oprcom": "0", "oprcode": "int4shr", "oprjoin": "-", "oprkind": "b", "oprleft": "int4", "oprname": ">>", "oprrest": "-", "oprowner": "POSTGRES", "oprright": "int4", "oprnegate": "0", "oprresult": "int4", "oprcanhash": "f", "oprcanmerge": "f", "oprnamespace": "pg_catalog"}, {"oid": "1890", "descr": "bitwise shift left", "oprcom": "0", "oprcode": "int8shl", "oprjoin": "-", "oprkind": "b", "oprleft": "int8", "oprname": "<<", "oprrest": "-", "oprowner": "POSTGRES", "oprright": "int4", "oprnegate": "0", "oprresult": "int8", "oprcanhash": "f", "oprcanmerge": "f", "oprnamespace": "pg_catalog"}, {"oid": "1891", "descr": "bitwise shift right", "oprcom": "0", "oprcode": "int8shr", "oprjoin": "-", "oprkind": "b", "oprleft": "int8", "oprname": ">>", "oprrest": "-", "oprowner": "POSTGRES", "oprright": "int4", "oprnegate": "0", "oprresult": "int8", "oprcanhash": "f", "oprcanmerge": "f", "oprnamespace": "pg_catalog"}, {"oid": "1918", "descr": "unary plus", "oprcom": "0", "oprcode": "int4up", "oprjoin": "-", "oprkind": "l", "oprleft": "0", "oprname": "+", "oprrest": "-", "oprowner": "POSTGRES", "oprright": "int4", "oprnegate": "0", "oprresult": "int4", "oprcanhash": "f", "oprcanmerge": "f", "oprnamespace": "pg_catalog"}, {"oid": "2555", "descr": "add", "oprcom": "+(date,int4)", "oprcode": "integer_pl_date", "oprjoin": "-", "oprkind": "b", "oprleft": "int4", "oprname": "+", "oprrest": "-", "oprowner": "POSTGRES", "oprright": "date", "oprnegate": "0", "oprresult": "date", "oprcanhash": "f", "oprcanmerge": "f", "oprnamespace": "pg_catalog"}, {"oid": "3964", "descr": "get json array element", "oprcom": "0", "oprcode": "json_array_element", "oprjoin": "-", "oprkind": "b", "oprleft": "json", "oprname": "->", "oprrest": "-", "oprowner": "POSTGRES", "oprright": "int4", "oprnegate": "0", "oprresult": "json", "oprcanhash": "f", "oprcanmerge": "f", "oprnamespace": "pg_catalog"}, {"oid": "3965", "descr": "get json array element as text", "oprcom": "0", "oprcode": "json_array_element_text", "oprjoin": "-", "oprkind": "b", "oprleft": "json", "oprname": "->>", "oprrest": "-", "oprowner": "POSTGRES", "oprright": "int4", "oprnegate": "0", "oprresult": "text", "oprcanhash": "f", "oprcanmerge": "f", "oprnamespace": "pg_catalog"}, {"oid": "3212", "descr": "get jsonb array element", "oprcom": "0", "oprcode": "jsonb_array_element", "oprjoin": "-", "oprkind": "b", "oprleft": "jsonb", "oprname": "->", "oprrest": "-", "oprowner": "POSTGRES", "oprright": "int4", "oprnegate": "0", "oprresult": "jsonb", "oprcanhash": "f", "oprcanmerge": "f", "oprnamespace": "pg_catalog"}, {"oid": "3481", "descr": "get jsonb array element as text", "oprcom": "0", "oprcode": "jsonb_array_element_text", "oprjoin": "-", "oprkind": "b", "oprleft": "jsonb", "oprname": "->>", "oprrest": "-", "oprowner": "POSTGRES", "oprright": "int4", "oprnegate": "0", "oprresult": "text", "oprcanhash": "f", "oprcanmerge": "f", "oprnamespace": "pg_catalog"}, {"oid": "3286", "descr": "delete array element", "oprcom": "0", "oprcode": "jsonb_delete(jsonb,int4)", "oprjoin": "-", "oprkind": "b", "oprleft": "jsonb", "oprname": "-", "oprrest": "-", "oprowner": "POSTGRES", "oprright": "int4", "oprnegate": "0", "oprresult": "jsonb", "oprcanhash": "f", "oprcanmerge": "f", "oprnamespace": "pg_catalog"}], "signature": "integer", "tables_zh": [], "description": ["有符号四字节整数"], "manual_html": "", "manual_path": "datatype-numeric.html", "sections_zh": [], "localization": {"status": "complete", "sources": [{"url": "/docs/18/datatype-money.html", "method": "same-major semantic node", "sha256": "6a3a18c17225f00376744bdae7a7f782102e9a0cce0bc2491e7669a43283455e", "language": "zh", "matched_nodes": ["#DATATYPE-MONEY/div[2]/div[1]/table[0]/tbody[2]/tr[0]/td[1]"]}, {"url": "/docs/18/datatype-numeric.html", "method": "same-major semantic node", "sha256": "3119f68768634c1b35c2d9fb65ecb989addbdf99d88064c8292f114cf3b2b79d", "language": "zh", "matched_nodes": ["#DATATYPE-NUMERIC/div[10]/div[9]/p[1]", "#DATATYPE-NUMERIC/div[4]/div[1]/table[0]/tbody[2]/tr[0]/td[3]", "#DATATYPE-NUMERIC/div[4]/div[1]/table[0]/tbody[2]/tr[1]/td[3]", "#DATATYPE-NUMERIC/div[4]/div[1]/table[0]/tbody[2]/tr[2]/td[3]", "#DATATYPE-NUMERIC/div[4]/div[1]/table[0]/tbody[2]/tr[3]/td[1]", "#DATATYPE-NUMERIC/div[4]/div[1]/table[0]/thead[1]/tr[0]/th[0]", "#DATATYPE-NUMERIC/div[8]/div[13]/h3[0]"]}], "language": "zh", "original_text": {"/versions/18/description/0": "signed four-byte integer", "/versions/18/facts/0/label": "Catalog name", "/versions/18/facts/1/label": "Type OID", "/versions/18/facts/2/label": "Type kind", "/versions/18/facts/2/value": "Base type", "/versions/18/facts/3/label": "Declared length", "/versions/18/facts/3/value": "4 bytes", "/versions/18/facts/4/label": "Storage strategy", "/versions/18/facts/5/label": "Input function", "/versions/18/facts/6/label": "Output function", "/versions/18/facts/7/label": "Documented declaration", "/versions/18/facts/8/label": "Storage Size", "/versions/18/facts/8/value": "4 bytes", "/versions/18/facts/9/label": "Manual description", "/versions/18/facts/9/value": "typical choice for integer", "/versions/18/facts/10/label": "Range", "/versions/18/facts/10/value": "-2147483648 to +2147483647", "/versions/18/related/0/label": "pg_type catalog", "/versions/18/related/1/label": "pg_cast catalog", "/versions/18/related/2/label": "pg_operator catalog", "/versions/18/related/3/label": "pg_opclass catalog", "/versions/18/related/4/label": "Arrays", "/versions/18/related/5/label": "brin index access method", "/versions/18/related/6/label": "btree index access method", "/versions/18/related/7/label": "hash index access method"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "d0914693c0244212f23a159e490063a969e536ffcf6ad112c14cce8b5bf9ea40", "canonical_center_text_hash": "526f32e0090c945597564588b9da4a7f5cad5eed023b36ad8dd68238de2a42f0"}, "description_zh": "有符号四字节整数", "comparison_data": {"casts": [{"castfunc": "0", "castmethod": "b", "castsource": "oid", "casttarget": "int4", "castcontext": "a"}, {"castfunc": "0", "castmethod": "b", "castsource": "regclass", "casttarget": "int4", "castcontext": "a"}, {"castfunc": "0", "castmethod": "b", "castsource": "regcollation", "casttarget": "int4", "castcontext": "a"}, {"castfunc": "0", "castmethod": "b", "castsource": "regconfig", "casttarget": "int4", "castcontext": "a"}, {"castfunc": "0", "castmethod": "b", "castsource": "regdictionary", "casttarget": "int4", "castcontext": "a"}, {"castfunc": "0", "castmethod": "b", "castsource": "regnamespace", "casttarget": "int4", "castcontext": "a"}, {"castfunc": "0", "castmethod": "b", "castsource": "regoper", "casttarget": "int4", "castcontext": "a"}, {"castfunc": "0", "castmethod": "b", "castsource": "regoperator", "casttarget": "int4", "castcontext": "a"}, {"castfunc": "0", "castmethod": "b", "castsource": "regproc", "casttarget": "int4", "castcontext": "a"}, {"castfunc": "0", "castmethod": "b", "castsource": "regprocedure", "casttarget": "int4", "castcontext": "a"}, {"castfunc": "0", "castmethod": "b", "castsource": "regrole", "casttarget": "int4", "castcontext": "a"}, {"castfunc": "0", "castmethod": "b", "castsource": "regtype", "casttarget": "int4", "castcontext": "a"}, {"castfunc": "int2(int4)", "castmethod": "f", "castsource": "int4", "casttarget": "int2", "castcontext": "a"}, {"castfunc": "int4(float4)", "castmethod": "f", "castsource": "float4", "casttarget": "int4", "castcontext": "a"}, {"castfunc": "int4(float8)", "castmethod": "f", "castsource": "float8", "casttarget": "int4", "castcontext": "a"}, {"castfunc": "int4(int8)", "castmethod": "f", "castsource": "int8", "casttarget": "int4", "castcontext": "a"}, {"castfunc": "int4(numeric)", "castmethod": "f", "castsource": "numeric", "casttarget": "int4", "castcontext": "a"}, {"castfunc": "money(int4)", "castmethod": "f", "castsource": "int4", "casttarget": "money", "castcontext": "a"}, {"castfunc": "bit(int4,int4)", "castmethod": "f", "castsource": "int4", "casttarget": "bit", "castcontext": "e"}, {"castfunc": "bool(int4)", "castmethod": "f", "castsource": "int4", "casttarget": "bool", "castcontext": "e"}, {"castfunc": "bytea(int4)", "castmethod": "f", "castsource": "int4", "casttarget": "bytea", "castcontext": "e"}, {"castfunc": "char(int4)", "castmethod": "f", "castsource": "int4", "casttarget": "char", "castcontext": "e"}, {"castfunc": "int4(bit)", "castmethod": "f", "castsource": "bit", "casttarget": "int4", "castcontext": "e"}, {"castfunc": "int4(bool)", "castmethod": "f", "castsource": "bool", "casttarget": "int4", "castcontext": "e"}, {"castfunc": "int4(bytea)", "castmethod": "f", "castsource": "bytea", "casttarget": "int4", "castcontext": "e"}, {"castfunc": "int4(char)", "castmethod": "f", "castsource": "char", "casttarget": "int4", "castcontext": "e"}, {"castfunc": "int4(jsonb)", "castmethod": "f", "castsource": "jsonb", "casttarget": "int4", "castcontext": "e"}, {"castfunc": "0", "castmethod": "b", "castsource": "int4", "casttarget": "oid", "castcontext": "i"}, {"castfunc": "0", "castmethod": "b", "castsource": "int4", "casttarget": "regclass", "castcontext": "i"}, {"castfunc": "0", "castmethod": "b", "castsource": "int4", "casttarget": "regcollation", "castcontext": "i"}, {"castfunc": "0", "castmethod": "b", "castsource": "int4", "casttarget": "regconfig", "castcontext": "i"}, {"castfunc": "0", "castmethod": "b", "castsource": "int4", "casttarget": "regdictionary", "castcontext": "i"}, {"castfunc": "0", "castmethod": "b", "castsource": "int4", "casttarget": "regnamespace", "castcontext": "i"}, {"castfunc": "0", "castmethod": "b", "castsource": "int4", "casttarget": "regoper", "castcontext": "i"}, {"castfunc": "0", "castmethod": "b", "castsource": "int4", "casttarget": "regoperator", "castcontext": "i"}, {"castfunc": "0", "castmethod": "b", "castsource": "int4", "casttarget": "regproc", "castcontext": "i"}, {"castfunc": "0", "castmethod": "b", "castsource": "int4", "casttarget": "regprocedure", "castcontext": "i"}, {"castfunc": "0", "castmethod": "b", "castsource": "int4", "casttarget": "regrole", "castcontext": "i"}, {"castfunc": "0", "castmethod": "b", "castsource": "int4", "casttarget": "regtype", "castcontext": "i"}, {"castfunc": "float4(int4)", "castmethod": "f", "castsource": "int4", "casttarget": "float4", "castcontext": "i"}, {"castfunc": "float8(int4)", "castmethod": "f", "castsource": "int4", "casttarget": "float8", "castcontext": "i"}, {"castfunc": "int4(int2)", "castmethod": "f", "castsource": "int2", "casttarget": "int4", "castcontext": "i"}, {"castfunc": "int8(int4)", "castmethod": "f", "castsource": "int4", "casttarget": "int8", "castcontext": "i"}, {"castfunc": "numeric(int4)", "castmethod": "f", "castsource": "int4", "casttarget": "numeric", "castcontext": "i"}], "facts": [{"label": "Catalog name", "value": "pg_catalog.int4"}, {"label": "Declared length", "value": "4 bytes"}, {"label": "Documented declaration", "value": "integer"}, {"label": "Input function", "value": "int4in"}, {"label": "Output function", "value": "int4out"}, {"label": "Range", "value": "-2147483648 to +2147483647"}, {"label": "Storage Size", "value": "4 bytes"}, {"label": "Storage strategy", "value": "plain"}, {"label": "Type OID", "value": "23"}, {"label": "Type kind", "value": "Base type"}], "ranges": [], "aliases": ["int", "int4"], "catalog": {"typacl": "_null_", "typlen": "4", "typelem": "0", "typname": "int4", "typsend": "int4send", "typtype": "b", "typalign": "i", "typarray": "_int4", "typbyval": "t", "typdelim": ",", "typinput": "int4in", "typmodin": "-", "typndims": "0", "typrelid": "0", "typmodout": "-", "typoutput": "int4out", "typtypmod": "-1", "typanalyze": "-", "typdefault": "_null_", "typnotnull": "f", "typreceive": "int4recv", "typstorage": "p", "typbasetype": "0", "typcategory": "N", "typcollation": "0", "typisdefined": "t", "typsubscript": "-", "typdefaultbin": "_null_", "typispreferred": "f", "array_type_name": "_int4"}, "operators": [{"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": "0", "oprcode": "cash_div_int4", "oprjoin": "-", "oprkind": "b", "oprleft": "money", "oprname": "/", "oprrest": "-", "oprright": "int4", "oprnegate": "0", "oprresult": "money", "oprcanhash": "f", "oprcanmerge": "f"}, {"oprcom": "*(int4,money)", "oprcode": "cash_mul_int4", "oprjoin": "-", "oprkind": "b", "oprleft": "money", "oprname": "*", "oprrest": "-", "oprright": "int4", "oprnegate": "0", "oprresult": "money", "oprcanhash": "f", "oprcanmerge": "f"}, {"oprcom": "0", "oprcode": "date_mii", "oprjoin": "-", "oprkind": "b", "oprleft": "date", "oprname": "-", "oprrest": "-", "oprright": "int4", "oprnegate": "0", "oprresult": "date", "oprcanhash": "f", "oprcanmerge": "f"}, {"oprcom": "+(int4,date)", "oprcode": "date_pli", "oprjoin": "-", "oprkind": "b", "oprleft": "date", "oprname": "+", "oprrest": "-", "oprright": "int4", "oprnegate": "0", "oprresult": "date", "oprcanhash": "f", "oprcanmerge": "f"}, {"oprcom": "0", "oprcode": "int24div", "oprjoin": "-", "oprkind": "b", "oprleft": "int2", "oprname": "/", "oprrest": "-", "oprright": "int4", "oprnegate": "0", "oprresult": "int4", "oprcanhash": "f", "oprcanmerge": "f"}, {"oprcom": "<=(int4,int2)", "oprcode": "int24ge", "oprjoin": "scalargejoinsel", "oprkind": "b", "oprleft": "int2", "oprname": ">=", "oprrest": "scalargesel", "oprright": "int4", "oprnegate": "<(int2,int4)", "oprresult": "bool", "oprcanhash": "f", "oprcanmerge": "f"}, {"oprcom": "<(int4,int2)", "oprcode": "int24gt", "oprjoin": "scalargtjoinsel", "oprkind": "b", "oprleft": "int2", "oprname": ">", "oprrest": "scalargtsel", "oprright": "int4", "oprnegate": "<=(int2,int4)", "oprresult": "bool", "oprcanhash": "f", "oprcanmerge": "f"}, {"oprcom": ">=(int4,int2)", "oprcode": "int24le", "oprjoin": "scalarlejoinsel", "oprkind": "b", "oprleft": "int2", "oprname": "<=", "oprrest": "scalarlesel", "oprright": "int4", "oprnegate": ">(int2,int4)", "oprresult": "bool", "oprcanhash": "f", "oprcanmerge": "f"}, {"oprcom": ">(int4,int2)", "oprcode": "int24lt", "oprjoin": "scalarltjoinsel", "oprkind": "b", "oprleft": "int2", "oprname": "<", "oprrest": "scalarltsel", "oprright": "int4", "oprnegate": ">=(int2,int4)", "oprresult": "bool", "oprcanhash": "f", "oprcanmerge": "f"}, {"oprcom": "0", "oprcode": "int24mi", "oprjoin": "-", "oprkind": "b", "oprleft": "int2", "oprname": "-", "oprrest": "-", "oprright": "int4", "oprnegate": "0", "oprresult": "int4", "oprcanhash": "f", "oprcanmerge": "f"}, {"oprcom": "*(int4,int2)", "oprcode": "int24mul", "oprjoin": "-", "oprkind": "b", "oprleft": "int2", "oprname": "*", "oprrest": "-", "oprright": "int4", "oprnegate": "0", "oprresult": "int4", "oprcanhash": "f", "oprcanmerge": "f"}, {"oprcom": "<>(int4,int2)", "oprcode": "int24ne", "oprjoin": "neqjoinsel", "oprkind": "b", "oprleft": "int2", "oprname": "<>", "oprrest": "neqsel", "oprright": "int4", "oprnegate": "=(int2,int4)", "oprresult": "bool", "oprcanhash": "f", "oprcanmerge": "f"}, {"oprcom": "+(int4,int2)", "oprcode": "int24pl", "oprjoin": "-", "oprkind": "b", "oprleft": "int2", "oprname": "+", "oprrest": "-", "oprright": "int4", "oprnegate": "0", "oprresult": "int4", "oprcanhash": "f", "oprcanmerge": "f"}, {"oprcom": "0", "oprcode": "int2shl", "oprjoin": "-", "oprkind": "b", "oprleft": "int2", "oprname": "<<", "oprrest": "-", "oprright": "int4", "oprnegate": "0", "oprresult": "int2", "oprcanhash": "f", "oprcanmerge": "f"}, {"oprcom": "0", "oprcode": "int2shr", "oprjoin": "-", "oprkind": "b", "oprleft": "int2", "oprname": ">>", "oprrest": "-", "oprright": "int4", "oprnegate": "0", "oprresult": "int2", "oprcanhash": "f", "oprcanmerge": "f"}, {"oprcom": "0", "oprcode": "int42div", "oprjoin": "-", "oprkind": "b", "oprleft": "int4", "oprname": "/", "oprrest": "-", "oprright": "int2", "oprnegate": "0", "oprresult": "int4", "oprcanhash": "f", "oprcanmerge": "f"}, {"oprcom": "<=(int2,int4)", "oprcode": "int42ge", "oprjoin": "scalargejoinsel", "oprkind": "b", "oprleft": "int4", "oprname": ">=", "oprrest": "scalargesel", "oprright": "int2", "oprnegate": "<(int4,int2)", "oprresult": "bool", "oprcanhash": "f", "oprcanmerge": "f"}, {"oprcom": "<(int2,int4)", "oprcode": "int42gt", "oprjoin": "scalargtjoinsel", "oprkind": "b", "oprleft": "int4", "oprname": ">", "oprrest": "scalargtsel", "oprright": "int2", "oprnegate": "<=(int4,int2)", "oprresult": "bool", "oprcanhash": "f", "oprcanmerge": "f"}, {"oprcom": ">=(int2,int4)", "oprcode": "int42le", "oprjoin": "scalarlejoinsel", "oprkind": "b", "oprleft": "int4", "oprname": "<=", "oprrest": "scalarlesel", "oprright": "int2", "oprnegate": ">(int4,int2)", "oprresult": "bool", "oprcanhash": "f", "oprcanmerge": "f"}, {"oprcom": ">(int2,int4)", "oprcode": "int42lt", "oprjoin": "scalarltjoinsel", "oprkind": "b", "oprleft": "int4", "oprname": "<", "oprrest": "scalarltsel", "oprright": "int2", "oprnegate": ">=(int4,int2)", "oprresult": "bool", "oprcanhash": "f", "oprcanmerge": "f"}, {"oprcom": "0", "oprcode": "int42mi", "oprjoin": "-", "oprkind": "b", "oprleft": "int4", "oprname": "-", "oprrest": "-", "oprright": "int2", "oprnegate": "0", "oprresult": "int4", "oprcanhash": "f", "oprcanmerge": "f"}, {"oprcom": "*(int2,int4)", "oprcode": "int42mul", "oprjoin": "-", "oprkind": "b", "oprleft": "int4", "oprname": "*", "oprrest": "-", "oprright": "int2", "oprnegate": "0", "oprresult": "int4", "oprcanhash": "f", "oprcanmerge": "f"}, {"oprcom": "<>(int2,int4)", "oprcode": "int42ne", "oprjoin": "neqjoinsel", "oprkind": "b", "oprleft": "int4", "oprname": "<>", "oprrest": "neqsel", "oprright": "int2", "oprnegate": "=(int4,int2)", "oprresult": "bool", "oprcanhash": "f", "oprcanmerge": "f"}, {"oprcom": "+(int2,int4)", "oprcode": "int42pl", "oprjoin": "-", "oprkind": "b", "oprleft": "int4", "oprname": "+", "oprrest": "-", "oprright": "int2", "oprnegate": "0", "oprresult": "int4", "oprcanhash": "f", "oprcanmerge": "f"}, {"oprcom": "0", "oprcode": "int48div", "oprjoin": "-", "oprkind": "b", "oprleft": "int4", "oprname": "/", "oprrest": "-", "oprright": "int8", "oprnegate": "0", "oprresult": "int8", "oprcanhash": "f", "oprcanmerge": "f"}, {"oprcom": "<=(int8,int4)", "oprcode": "int48ge", "oprjoin": "scalargejoinsel", "oprkind": "b", "oprleft": "int4", "oprname": ">=", "oprrest": "scalargesel", "oprright": "int8", "oprnegate": "<(int4,int8)", "oprresult": "bool", "oprcanhash": "f", "oprcanmerge": "f"}, {"oprcom": "<(int8,int4)", "oprcode": "int48gt", "oprjoin": "scalargtjoinsel", "oprkind": "b", "oprleft": "int4", "oprname": ">", "oprrest": "scalargtsel", "oprright": "int8", "oprnegate": "<=(int4,int8)", "oprresult": "bool", "oprcanhash": "f", "oprcanmerge": "f"}, {"oprcom": ">=(int8,int4)", "oprcode": "int48le", "oprjoin": "scalarlejoinsel", "oprkind": "b", "oprleft": "int4", "oprname": "<=", "oprrest": "scalarlesel", "oprright": "int8", "oprnegate": ">(int4,int8)", "oprresult": "bool", "oprcanhash": "f", "oprcanmerge": "f"}, {"oprcom": ">(int8,int4)", "oprcode": "int48lt", "oprjoin": "scalarltjoinsel", "oprkind": "b", "oprleft": "int4", "oprname": "<", "oprrest": "scalarltsel", "oprright": "int8", "oprnegate": ">=(int4,int8)", "oprresult": "bool", "oprcanhash": "f", "oprcanmerge": "f"}, {"oprcom": "0", "oprcode": "int48mi", "oprjoin": "-", "oprkind": "b", "oprleft": "int4", "oprname": "-", "oprrest": "-", "oprright": "int8", "oprnegate": "0", "oprresult": "int8", "oprcanhash": "f", "oprcanmerge": "f"}, {"oprcom": "*(int8,int4)", "oprcode": "int48mul", "oprjoin": "-", "oprkind": "b", "oprleft": "int4", "oprname": "*", "oprrest": "-", "oprright": "int8", "oprnegate": "0", "oprresult": "int8", "oprcanhash": "f", "oprcanmerge": "f"}, {"oprcom": "<>(int8,int4)", "oprcode": "int48ne", "oprjoin": "neqjoinsel", "oprkind": "b", "oprleft": "int4", "oprname": "<>", "oprrest": "neqsel", "oprright": "int8", "oprnegate": "=(int4,int8)", "oprresult": "bool", "oprcanhash": "f", "oprcanmerge": "f"}, {"oprcom": "+(int8,int4)", "oprcode": "int48pl", "oprjoin": "-", "oprkind": "b", "oprleft": "int4", "oprname": "+", "oprrest": "-", "oprright": "int8", "oprnegate": "0", "oprresult": "int8", "oprcanhash": "f", "oprcanmerge": "f"}, {"oprcom": "*(money,int4)", "oprcode": "int4_mul_cash", "oprjoin": "-", "oprkind": "b", "oprleft": "int4", "oprname": "*", "oprrest": "-", "oprright": "money", "oprnegate": "0", "oprresult": "money", "oprcanhash": "f", "oprcanmerge": "f"}, {"oprcom": "0", "oprcode": "int4abs", "oprjoin": "-", "oprkind": "l", "oprleft": "0", "oprname": "@", "oprrest": "-", "oprright": "int4", "oprnegate": "0", "oprresult": "int4", "oprcanhash": "f", "oprcanmerge": "f"}, {"oprcom": "&(int4,int4)", "oprcode": "int4and", "oprjoin": "-", "oprkind": "b", "oprleft": "int4", "oprname": "&", "oprrest": "-", "oprright": "int4", "oprnegate": "0", "oprresult": "int4", "oprcanhash": "f", "oprcanmerge": "f"}, {"oprcom": "0", "oprcode": "int4div", "oprjoin": "-", "oprkind": "b", "oprleft": "int4", "oprname": "/", "oprrest": "-", "oprright": "int4", "oprnegate": "0", "oprresult": "int4", "oprcanhash": "f", "oprcanmerge": "f"}, {"oprcom": "<=(int4,int4)", "oprcode": "int4ge", "oprjoin": "scalargejoinsel", "oprkind": "b", "oprleft": "int4", "oprname": ">=", "oprrest": "scalargesel", "oprright": "int4", "oprnegate": "<(int4,int4)", "oprresult": "bool", "oprcanhash": "f", "oprcanmerge": "f"}, {"oprcom": "<(int4,int4)", "oprcode": "int4gt", "oprjoin": "scalargtjoinsel", "oprkind": "b", "oprleft": "int4", "oprname": ">", "oprrest": "scalargtsel", "oprright": "int4", "oprnegate": "<=(int4,int4)", "oprresult": "bool", "oprcanhash": "f", "oprcanmerge": "f"}, {"oprcom": ">=(int4,int4)", "oprcode": "int4le", "oprjoin": "scalarlejoinsel", "oprkind": "b", "oprleft": "int4", "oprname": "<=", "oprrest": "scalarlesel", "oprright": "int4", "oprnegate": ">(int4,int4)", "oprresult": "bool", "oprcanhash": "f", "oprcanmerge": "f"}, {"oprcom": ">(int4,int4)", "oprcode": "int4lt", "oprjoin": "scalarltjoinsel", "oprkind": "b", "oprleft": "int4", "oprname": "<", "oprrest": "scalarltsel", "oprright": "int4", "oprnegate": ">=(int4,int4)", "oprresult": "bool", "oprcanhash": "f", "oprcanmerge": "f"}, {"oprcom": "0", "oprcode": "int4mi", "oprjoin": "-", "oprkind": "b", "oprleft": "int4", "oprname": "-", "oprrest": "-", "oprright": "int4", "oprnegate": "0", "oprresult": "int4", "oprcanhash": "f", "oprcanmerge": "f"}, {"oprcom": "0", "oprcode": "int4mod", "oprjoin": "-", "oprkind": "b", "oprleft": "int4", "oprname": "%", "oprrest": "-", "oprright": "int4", "oprnegate": "0", "oprresult": "int4", "oprcanhash": "f", "oprcanmerge": "f"}, {"oprcom": "*(int4,int4)", "oprcode": "int4mul", "oprjoin": "-", "oprkind": "b", "oprleft": "int4", "oprname": "*", "oprrest": "-", "oprright": "int4", "oprnegate": "0", "oprresult": "int4", "oprcanhash": "f", "oprcanmerge": "f"}, {"oprcom": "<>(int4,int4)", "oprcode": "int4ne", "oprjoin": "neqjoinsel", "oprkind": "b", "oprleft": "int4", "oprname": "<>", "oprrest": "neqsel", "oprright": "int4", "oprnegate": "=(int4,int4)", "oprresult": "bool", "oprcanhash": "f", "oprcanmerge": "f"}, {"oprcom": "0", "oprcode": "int4not", "oprjoin": "-", "oprkind": "l", "oprleft": "0", "oprname": "~", "oprrest": "-", "oprright": "int4", "oprnegate": "0", "oprresult": "int4", "oprcanhash": "f", "oprcanmerge": "f"}, {"oprcom": "|(int4,int4)", "oprcode": "int4or", "oprjoin": "-", "oprkind": "b", "oprleft": "int4", "oprname": "|", "oprrest": "-", "oprright": "int4", "oprnegate": "0", "oprresult": "int4", "oprcanhash": "f", "oprcanmerge": "f"}, {"oprcom": "+(int4,int4)", "oprcode": "int4pl", "oprjoin": "-", "oprkind": "b", "oprleft": "int4", "oprname": "+", "oprrest": "-", "oprright": "int4", "oprnegate": "0", "oprresult": "int4", "oprcanhash": "f", "oprcanmerge": "f"}, {"oprcom": "0", "oprcode": "int4shl", "oprjoin": "-", "oprkind": "b", "oprleft": "int4", "oprname": "<<", "oprrest": "-", "oprright": "int4", "oprnegate": "0", "oprresult": "int4", "oprcanhash": "f", "oprcanmerge": "f"}, {"oprcom": "0", "oprcode": "int4shr", "oprjoin": "-", "oprkind": "b", "oprleft": "int4", "oprname": ">>", "oprrest": "-", "oprright": "int4", "oprnegate": "0", "oprresult": "int4", "oprcanhash": "f", "oprcanmerge": "f"}, {"oprcom": "0", "oprcode": "int4um", "oprjoin": "-", "oprkind": "l", "oprleft": "0", "oprname": "-", "oprrest": "-", "oprright": "int4", "oprnegate": "0", "oprresult": "int4", "oprcanhash": "f", "oprcanmerge": "f"}, {"oprcom": "0", "oprcode": "int4up", "oprjoin": "-", "oprkind": "l", "oprleft": "0", "oprname": "+", "oprrest": "-", "oprright": "int4", "oprnegate": "0", "oprresult": "int4", "oprcanhash": "f", "oprcanmerge": "f"}, {"oprcom": "#(int4,int4)", "oprcode": "int4xor", "oprjoin": "-", "oprkind": "b", "oprleft": "int4", "oprname": "#", "oprrest": "-", "oprright": "int4", "oprnegate": "0", "oprresult": "int4", "oprcanhash": "f", "oprcanmerge": "f"}, {"oprcom": "0", "oprcode": "int84div", "oprjoin": "-", "oprkind": "b", "oprleft": "int8", "oprname": "/", "oprrest": "-", "oprright": "int4", "oprnegate": "0", "oprresult": "int8", "oprcanhash": "f", "oprcanmerge": "f"}, {"oprcom": "<=(int4,int8)", "oprcode": "int84ge", "oprjoin": "scalargejoinsel", "oprkind": "b", "oprleft": "int8", "oprname": ">=", "oprrest": "scalargesel", "oprright": "int4", "oprnegate": "<(int8,int4)", "oprresult": "bool", "oprcanhash": "f", "oprcanmerge": "f"}, {"oprcom": "<(int4,int8)", "oprcode": "int84gt", "oprjoin": "scalargtjoinsel", "oprkind": "b", "oprleft": "int8", "oprname": ">", "oprrest": "scalargtsel", "oprright": "int4", "oprnegate": "<=(int8,int4)", "oprresult": "bool", "oprcanhash": "f", "oprcanmerge": "f"}, {"oprcom": ">=(int4,int8)", "oprcode": "int84le", "oprjoin": "scalarlejoinsel", "oprkind": "b", "oprleft": "int8", "oprname": "<=", "oprrest": "scalarlesel", "oprright": "int4", "oprnegate": ">(int8,int4)", "oprresult": "bool", "oprcanhash": "f", "oprcanmerge": "f"}, {"oprcom": ">(int4,int8)", "oprcode": "int84lt", "oprjoin": "scalarltjoinsel", "oprkind": "b", "oprleft": "int8", "oprname": "<", "oprrest": "scalarltsel", "oprright": "int4", "oprnegate": ">=(int8,int4)", "oprresult": "bool", "oprcanhash": "f", "oprcanmerge": "f"}, {"oprcom": "0", "oprcode": "int84mi", "oprjoin": "-", "oprkind": "b", "oprleft": "int8", "oprname": "-", "oprrest": "-", "oprright": "int4", "oprnegate": "0", "oprresult": "int8", "oprcanhash": "f", "oprcanmerge": "f"}, {"oprcom": "*(int4,int8)", "oprcode": "int84mul", "oprjoin": "-", "oprkind": "b", "oprleft": "int8", "oprname": "*", "oprrest": "-", "oprright": "int4", "oprnegate": "0", "oprresult": "int8", "oprcanhash": "f", "oprcanmerge": "f"}, {"oprcom": "<>(int4,int8)", "oprcode": "int84ne", "oprjoin": "neqjoinsel", "oprkind": "b", "oprleft": "int8", "oprname": "<>", "oprrest": "neqsel", "oprright": "int4", "oprnegate": "=(int8,int4)", "oprresult": "bool", "oprcanhash": "f", "oprcanmerge": "f"}, {"oprcom": "+(int4,int8)", "oprcode": "int84pl", "oprjoin": "-", "oprkind": "b", "oprleft": "int8", "oprname": "+", "oprrest": "-", "oprright": "int4", "oprnegate": "0", "oprresult": "int8", "oprcanhash": "f", "oprcanmerge": "f"}, {"oprcom": "0", "oprcode": "int8shl", "oprjoin": "-", "oprkind": "b", "oprleft": "int8", "oprname": "<<", "oprrest": "-", "oprright": "int4", "oprnegate": "0", "oprresult": "int8", "oprcanhash": "f", "oprcanmerge": "f"}, {"oprcom": "0", "oprcode": "int8shr", "oprjoin": "-", "oprkind": "b", "oprleft": "int8", "oprname": ">>", "oprrest": "-", "oprright": "int4", "oprnegate": "0", "oprresult": "int8", "oprcanhash": "f", "oprcanmerge": "f"}, {"oprcom": "+(date,int4)", "oprcode": "integer_pl_date", "oprjoin": "-", "oprkind": "b", "oprleft": "int4", "oprname": "+", "oprrest": "-", "oprright": "date", "oprnegate": "0", "oprresult": "date", "oprcanhash": "f", "oprcanmerge": "f"}, {"oprcom": "0", "oprcode": "json_array_element", "oprjoin": "-", "oprkind": "b", "oprleft": "json", "oprname": "->", "oprrest": "-", "oprright": "int4", "oprnegate": "0", "oprresult": "json", "oprcanhash": "f", "oprcanmerge": "f"}, {"oprcom": "0", "oprcode": "json_array_element_text", "oprjoin": "-", "oprkind": "b", "oprleft": "json", "oprname": "->>", "oprrest": "-", "oprright": "int4", "oprnegate": "0", "oprresult": "text", "oprcanhash": "f", "oprcanmerge": "f"}, {"oprcom": "0", "oprcode": "jsonb_array_element", "oprjoin": "-", "oprkind": "b", "oprleft": "jsonb", "oprname": "->", "oprrest": "-", "oprright": "int4", "oprnegate": "0", "oprresult": "jsonb", "oprcanhash": "f", "oprcanmerge": "f"}, {"oprcom": "0", "oprcode": "jsonb_array_element_text", "oprjoin": "-", "oprkind": "b", "oprleft": "jsonb", "oprname": "->>", "oprrest": "-", "oprright": "int4", "oprnegate": "0", "oprresult": "text", "oprcanhash": "f", "oprcanmerge": "f"}, {"oprcom": "0", "oprcode": "jsonb_delete", "oprjoin": "-", "oprkind": "b", "oprleft": "jsonb", "oprname": "-", "oprrest": "-", "oprright": "int4", "oprnegate": "0", "oprresult": "jsonb", "oprcanhash": "f", "oprcanmerge": "f"}, {"oprcom": "0", "oprcode": "xideqint4", "oprjoin": "eqjoinsel", "oprkind": "b", "oprleft": "xid", "oprname": "=", "oprrest": "eqsel", "oprright": "int4", "oprnegate": "<>(xid,int4)", "oprresult": "bool", "oprcanhash": "f", "oprcanmerge": "f"}, {"oprcom": "0", "oprcode": "xidneqint4", "oprjoin": "neqjoinsel", "oprkind": "b", "oprleft": "xid", "oprname": "<>", "oprrest": "neqsel", "oprright": "int4", "oprnegate": "=(xid,int4)", "oprresult": "bool", "oprcanhash": "f", "oprcanmerge": "f"}, {"oprcom": "=(int4,int2)", "oprcode": "int24eq", "oprjoin": "eqjoinsel", "oprkind": "b", "oprleft": "int2", "oprname": "=", "oprrest": "eqsel", "oprright": "int4", "oprnegate": "<>(int2,int4)", "oprresult": "bool", "oprcanhash": "t", "oprcanmerge": "t"}, {"oprcom": "=(int2,int4)", "oprcode": "int42eq", "oprjoin": "eqjoinsel", "oprkind": "b", "oprleft": "int4", "oprname": "=", "oprrest": "eqsel", "oprright": "int2", "oprnegate": "<>(int4,int2)", "oprresult": "bool", "oprcanhash": "t", "oprcanmerge": "t"}, {"oprcom": "=(int8,int4)", "oprcode": "int48eq", "oprjoin": "eqjoinsel", "oprkind": "b", "oprleft": "int4", "oprname": "=", "oprrest": "eqsel", "oprright": "int8", "oprnegate": "<>(int4,int8)", "oprresult": "bool", "oprcanhash": "t", "oprcanmerge": "t"}, {"oprcom": "=(int4,int4)", "oprcode": "int4eq", "oprjoin": "eqjoinsel", "oprkind": "b", "oprleft": "int4", "oprname": "=", "oprrest": "eqsel", "oprright": "int4", "oprnegate": "<>(int4,int4)", "oprresult": "bool", "oprcanhash": "t", "oprcanmerge": "t"}, {"oprcom": "=(int4,int8)", "oprcode": "int84eq", "oprjoin": "eqjoinsel", "oprkind": "b", "oprleft": "int8", "oprname": "=", "oprrest": "eqsel", "oprright": "int4", "oprnegate": "<>(int8,int4)", "oprresult": "bool", "oprcanhash": "t", "oprcanmerge": "t"}], "operator_classes": [{"opcname": "int4_bloom_ops", "opcfamily": "brin/integer_bloom_ops", "opcintype": "int4", "opcmethod": "brin", "opcdefault": "f", "opckeytype": "int4"}, {"opcname": "int4_minmax_multi_ops", "opcfamily": "brin/integer_minmax_multi_ops", "opcintype": "int4", "opcmethod": "brin", "opcdefault": "f", "opckeytype": "int4"}, {"opcname": "int4_minmax_ops", "opcfamily": "brin/integer_minmax_ops", "opcintype": "int4", "opcmethod": "brin", "opcdefault": "t", "opckeytype": "int4"}, {"opcname": "int4_ops", "opcfamily": "btree/integer_ops", "opcintype": "int4", "opcmethod": "btree", "opcdefault": "t", "opckeytype": "0"}, {"opcname": "int4_ops", "opcfamily": "hash/integer_ops", "opcintype": "int4", "opcmethod": "hash", "opcdefault": "t", "opckeytype": "0"}]}, "comparison_hash": "956894dc2672b9c4e1d823f7620a1d255aeab71f0727ff93512a3cf2166ffca9", "manual_language": "zh", "operator_classes": [{"oid": "1978", "opcname": "int4_ops", "opcowner": "POSTGRES", "opcfamily": "btree/integer_ops", "opcintype": "int4", "opcmethod": "btree", "oid_symbol": "INT4_BTREE_OPS_OID", "opcdefault": "t", "opckeytype": "0", "opcnamespace": "pg_catalog"}, {"opcname": "int4_ops", "opcowner": "POSTGRES", "opcfamily": "hash/integer_ops", "opcintype": "int4", "opcmethod": "hash", "opcdefault": "t", "opckeytype": "0", "opcnamespace": "pg_catalog"}, {"opcname": "int4_minmax_ops", "opcowner": "POSTGRES", "opcfamily": "brin/integer_minmax_ops", "opcintype": "int4", "opcmethod": "brin", "opcdefault": "t", "opckeytype": "int4", "opcnamespace": "pg_catalog"}, {"opcname": "int4_minmax_multi_ops", "opcowner": "POSTGRES", "opcfamily": "brin/integer_minmax_multi_ops", "opcintype": "int4", "opcmethod": "brin", "opcdefault": "f", "opckeytype": "int4", "opcnamespace": "pg_catalog"}, {"opcname": "int4_bloom_ops", "opcowner": "POSTGRES", "opcfamily": "brin/integer_bloom_ops", "opcintype": "int4", "opcmethod": "brin", "opcdefault": "f", "opckeytype": "int4", "opcnamespace": "pg_catalog"}], "description_zh_html": "<p>有符号四字节整数</p><h3>同版本中文手册节选</h3><p>\n    数字类型包括 2、4、8 字节的整数，4、8 字节的浮点数，以及可选精度的小数。<a href=\"/zh/docs/18/datatype-numeric.html#DATATYPE-NUMERIC-TABLE\" rel=\"nofollow\">表 8.2</a> 列出了所有可用类型。\n   </p><p>\n    数字类型常量的语法在<a href=\"/zh/docs/18/sql-syntax-lexical.html#SQL-SYNTAX-CONSTANTS\" rel=\"nofollow\">第 4.1.2 节</a>里描述。数字类型有一整套对应的算术操作符和函数。相关信息请参考<a href=\"/zh/docs/18/functions.html\" rel=\"nofollow\">第 9 章</a>。下面的几节详细描述这些类型。\n   </p><p><a href=\"/zh/docs/18/datatype-numeric.html\" rel=\"nofollow\">查看完整中文手册与上下文</a>。</p>", "manual_documentation": "dedicated family chapter", "center_zh_rendered": "<p>有符号四字节整数</p><h3>同版本中文手册节选</h3><p>\n    数字类型包括 2、4、8 字节的整数，4、8 字节的浮点数，以及可选精度的小数。<a href=\"/docs/18/datatype-numeric.html#DATATYPE-NUMERIC-TABLE\">表 8.2</a> 列出了所有可用类型。\n   </p><p>\n    数字类型常量的语法在<a href=\"/docs/18/sql-syntax-lexical.html#SQL-SYNTAX-CONSTANTS\">第 4.1.2 节</a>里描述。数字类型有一整套对应的算术操作符和函数。相关信息请参考<a href=\"/docs/18/functions.html\">第 9 章</a>。下面的几节详细描述这些类型。\n   </p><p><a href=\"/docs/18/datatype-numeric.html\">查看完整中文手册与上下文</a>。</p>"}, "from": "17", "comparison": {"available": true, "changes": [{"label": "类型转换", "before": "[{\"castcontext\": \"a\", \"castfunc\": \"0\", \"castmethod\": \"b\", \"castsource\": \"oid\", \"casttarget\": \"int4\"}, {\"castcontext\": \"a\", \"castfunc\": \"0\", \"castmethod\": \"b\", \"castsource\": \"regclass\", \"casttarget\": \"int4\"}, {\"castcontext\": \"a\", \"castfunc\": \"0\", \"castmethod\": \"b\", \"castsource\": \"regcollation\", \"casttarget\": \"int4\"}, {\"castcontext\": \"a\", \"castfunc\": \"0\", \"castmethod\": \"b\", \"castsource\": \"regconfig\", \"casttarget\": \"int4\"}, {\"castcontext\": \"a\", \"castfunc\": \"0\", \"castmethod\": \"b\", \"castsource\": \"regdictionary\", \"casttarget\": \"int4\"}, {\"castcontext\": \"a\", \"castfunc\": \"0\", \"castmethod\": \"b\", \"castsource\": \"regnamespace\", \"casttarget\": \"int4\"}, {\"castcontext\": \"a\", \"castfunc\": \"0\", \"castmethod\": \"b\", \"castsource\": \"regoper\", \"casttarget\": \"int4\"}, {\"castcontext\": \"a\", \"castfunc\": \"0\", \"castmethod\": \"b\", \"castsource\": \"regoperator\", \"casttarget\": \"int4\"}, {\"castcontext\": \"a\", \"castfunc\": \"0\", \"castmethod\": \"b\", \"castsource\": \"regproc\", \"casttarget\": \"int4\"}, {\"castcontext\": \"a\", \"castfunc\": \"0\", \"castmethod\": \"b\", \"castsource\": \"regprocedure\", \"casttarget\": \"int4\"}, {\"castcontext\": \"a\", \"castfunc\": \"0\", \"castmethod\": \"b\", \"castsource\": \"regrole\", \"casttarget\": \"int4\"}, {\"castcontext\": \"a\", \"castfunc\": \"0\", \"castmethod\": \"b\", \"castsource\": \"regtype\", \"casttarget\": \"int4\"}, {\"castcontext\": \"a\", \"castfunc\": \"int2(int4)\", \"castmethod\": \"f\", \"castsource\": \"int4\", \"casttarget\": \"int2\"}, {\"castcontext\": \"a\", \"castfunc\": \"int4(float4)\", \"castmethod\": \"f\", \"castsource\": \"float4\", \"casttarget\": \"int4\"}, {\"castcontext\": \"a\", \"castfunc\": \"int4(float8)\", \"castmethod\": \"f\", \"castsource\": \"float8\", \"casttarget\": \"int4\"}, {\"castcontext\": \"a\", \"castfunc\": \"int4(int8)\", \"castmethod\": \"f\", \"castsource\": \"int8\", \"casttarget\": \"int4\"}, {\"castcontext\": \"a\", \"castfunc\": \"int4(numeric)\", \"castmethod\": \"f\", \"castsource\": \"numeric\", \"casttarget\": \"int4\"}, {\"castcontext\": \"a\", \"castfunc\": \"money(int4)\", \"castmethod\": \"f\", \"castsource\": \"int4\", \"casttarget\": \"money\"}, {\"castcontext\": \"e\", \"castfunc\": \"bit(int4,int4)\", \"castmethod\": \"f\", \"castsource\": \"int4\", \"casttarget\": \"bit\"}, {\"castcontext\": \"e\", \"castfunc\": \"bool(int4)\", \"castmethod\": \"f\", \"castsource\": \"int4\", \"casttarget\": \"bool\"}, {\"castcontext\": \"e\", \"castfunc\": \"char(int4)\", \"castmethod\": \"f\", \"castsource\": \"int4\", \"casttarget\": \"char\"}, {\"castcontext\": \"e\", \"castfunc\": \"int4(bit)\", \"castmethod\": \"f\", \"castsource\": \"bit\", \"casttarget\": \"int4\"}, {\"castcontext\": \"e\", \"castfunc\": \"int4(bool)\", \"castmethod\": \"f\", \"castsource\": \"bool\", \"casttarget\": \"int4\"}, {\"castcontext\": \"e\", \"castfunc\": \"int4(char)\", \"castmethod\": \"f\", \"castsource\": \"char\", \"casttarget\": \"int4\"}, {\"castcontext\": \"e\", \"castfunc\": \"int4(jsonb)\", \"castmethod\": \"f\", \"castsource\": \"jsonb\", \"casttarget\": \"int4\"}, {\"castcontext\": \"i\", \"castfunc\": \"0\", \"castmethod\": \"b\", \"castsource\": \"int4\", \"casttarget\": \"oid\"}, {\"castcontext\": \"i\", \"castfunc\": \"0\", \"castmethod\": \"b\", \"castsource\": \"int4\", \"casttarget\": \"regclass\"}, {\"castcontext\": \"i\", \"castfunc\": \"0\", \"castmethod\": \"b\", \"castsource\": \"int4\", \"casttarget\": \"regcollation\"}, {\"castcontext\": \"i\", \"castfunc\": \"0\", \"castmethod\": \"b\", \"castsource\": \"int4\", \"casttarget\": \"regconfig\"}, {\"castcontext\": \"i\", \"castfunc\": \"0\", \"castmethod\": \"b\", \"castsource\": \"int4\", \"casttarget\": \"regdictionary\"}, {\"castcontext\": \"i\", \"castfunc\": \"0\", \"castmethod\": \"b\", \"castsource\": \"int4\", \"casttarget\": \"regnamespace\"}, {\"castcontext\": \"i\", \"castfunc\": \"0\", \"castmethod\": \"b\", \"castsource\": \"int4\", \"casttarget\": \"regoper\"}, {\"castcontext\": \"i\", \"castfunc\": \"0\", \"castmethod\": \"b\", \"castsource\": \"int4\", \"casttarget\": \"regoperator\"}, {\"castcontext\": \"i\", \"castfunc\": \"0\", \"castmethod\": \"b\", \"castsource\": \"int4\", \"casttarget\": \"regproc\"}, {\"castcontext\": \"i\", \"castfunc\": \"0\", \"castmethod\": \"b\", \"castsource\": \"int4\", \"casttarget\": \"regprocedure\"}, {\"castcontext\": \"i\", \"castfunc\": \"0\", \"castmethod\": \"b\", \"castsource\": \"int4\", \"casttarget\": \"regrole\"}, {\"castcontext\": \"i\", \"castfunc\": \"0\", \"castmethod\": \"b\", \"castsource\": \"int4\", \"casttarget\": \"regtype\"}, {\"castcontext\": \"i\", \"castfunc\": \"float4(int4)\", \"castmethod\": \"f\", \"castsource\": \"int4\", \"casttarget\": \"float4\"}, {\"castcontext\": \"i\", \"castfunc\": \"float8(int4)\", \"castmethod\": \"f\", \"castsource\": \"int4\", \"casttarget\": \"float8\"}, {\"castcontext\": \"i\", \"castfunc\": \"int4(int2)\", \"castmethod\": \"f\", \"castsource\": \"int2\", \"casttarget\": \"int4\"}, {\"castcontext\": \"i\", \"castfunc\": \"int8(int4)\", \"castmethod\": \"f\", \"castsource\": \"int4\", \"casttarget\": \"int8\"}, {\"castcontext\": \"i\", \"castfunc\": \"numeric(int4)\", \"castmethod\": \"f\", \"castsource\": \"int4\", \"casttarget\": \"numeric\"}]", "after": "[{\"castcontext\": \"a\", \"castfunc\": \"0\", \"castmethod\": \"b\", \"castsource\": \"oid\", \"casttarget\": \"int4\"}, {\"castcontext\": \"a\", \"castfunc\": \"0\", \"castmethod\": \"b\", \"castsource\": \"regclass\", \"casttarget\": \"int4\"}, {\"castcontext\": \"a\", \"castfunc\": \"0\", \"castmethod\": \"b\", \"castsource\": \"regcollation\", \"casttarget\": \"int4\"}, {\"castcontext\": \"a\", \"castfunc\": \"0\", \"castmethod\": \"b\", \"castsource\": \"regconfig\", \"casttarget\": \"int4\"}, {\"castcontext\": \"a\", \"castfunc\": \"0\", \"castmethod\": \"b\", \"castsource\": \"regdictionary\", \"casttarget\": \"int4\"}, {\"castcontext\": \"a\", \"castfunc\": \"0\", \"castmethod\": \"b\", \"castsource\": \"regnamespace\", \"casttarget\": \"int4\"}, {\"castcontext\": \"a\", \"castfunc\": \"0\", \"castmethod\": \"b\", \"castsource\": \"regoper\", \"casttarget\": \"int4\"}, {\"castcontext\": \"a\", \"castfunc\": \"0\", \"castmethod\": \"b\", \"castsource\": \"regoperator\", \"casttarget\": \"int4\"}, {\"castcontext\": \"a\", \"castfunc\": \"0\", \"castmethod\": \"b\", \"castsource\": \"regproc\", \"casttarget\": \"int4\"}, {\"castcontext\": \"a\", \"castfunc\": \"0\", \"castmethod\": \"b\", \"castsource\": \"regprocedure\", \"casttarget\": \"int4\"}, {\"castcontext\": \"a\", \"castfunc\": \"0\", \"castmethod\": \"b\", \"castsource\": \"regrole\", \"casttarget\": \"int4\"}, {\"castcontext\": \"a\", \"castfunc\": \"0\", \"castmethod\": \"b\", \"castsource\": \"regtype\", \"casttarget\": \"int4\"}, {\"castcontext\": \"a\", \"castfunc\": \"int2(int4)\", \"castmethod\": \"f\", \"castsource\": \"int4\", \"casttarget\": \"int2\"}, {\"castcontext\": \"a\", \"castfunc\": \"int4(float4)\", \"castmethod\": \"f\", \"castsource\": \"float4\", \"casttarget\": \"int4\"}, {\"castcontext\": \"a\", \"castfunc\": \"int4(float8)\", \"castmethod\": \"f\", \"castsource\": \"float8\", \"casttarget\": \"int4\"}, {\"castcontext\": \"a\", \"castfunc\": \"int4(int8)\", \"castmethod\": \"f\", \"castsource\": \"int8\", \"casttarget\": \"int4\"}, {\"castcontext\": \"a\", \"castfunc\": \"int4(numeric)\", \"castmethod\": \"f\", \"castsource\": \"numeric\", \"casttarget\": \"int4\"}, {\"castcontext\": \"a\", \"castfunc\": \"money(int4)\", \"castmethod\": \"f\", \"castsource\": \"int4\", \"casttarget\": \"money\"}, {\"castcontext\": \"e\", \"castfunc\": \"bit(int4,int4)\", \"castmethod\": \"f\", \"castsource\": \"int4\", \"casttarget\": \"bit\"}, {\"castcontext\": \"e\", \"castfunc\": \"bool(int4)\", \"castmethod\": \"f\", \"castsource\": \"int4\", \"casttarget\": \"bool\"}, {\"castcontext\": \"e\", \"castfunc\": \"bytea(int4)\", \"castmethod\": \"f\", \"castsource\": \"int4\", \"casttarget\": \"bytea\"}, {\"castcontext\": \"e\", \"castfunc\": \"char(int4)\", \"castmethod\": \"f\", \"castsource\": \"int4\", \"casttarget\": \"char\"}, {\"castcontext\": \"e\", \"castfunc\": \"int4(bit)\", \"castmethod\": \"f\", \"castsource\": \"bit\", \"casttarget\": \"int4\"}, {\"castcontext\": \"e\", \"castfunc\": \"int4(bool)\", \"castmethod\": \"f\", \"castsource\": \"bool\", \"casttarget\": \"int4\"}, {\"castcontext\": \"e\", \"castfunc\": \"int4(bytea)\", \"castmethod\": \"f\", \"castsource\": \"bytea\", \"casttarget\": \"int4\"}, {\"castcontext\": \"e\", \"castfunc\": \"int4(char)\", \"castmethod\": \"f\", \"castsource\": \"char\", \"casttarget\": \"int4\"}, {\"castcontext\": \"e\", \"castfunc\": \"int4(jsonb)\", \"castmethod\": \"f\", \"castsource\": \"jsonb\", \"casttarget\": \"int4\"}, {\"castcontext\": \"i\", \"castfunc\": \"0\", \"castmethod\": \"b\", \"castsource\": \"int4\", \"casttarget\": \"oid\"}, {\"castcontext\": \"i\", \"castfunc\": \"0\", \"castmethod\": \"b\", \"castsource\": \"int4\", \"casttarget\": \"regclass\"}, {\"castcontext\": \"i\", \"castfunc\": \"0\", \"castmethod\": \"b\", \"castsource\": \"int4\", \"casttarget\": \"regcollation\"}, {\"castcontext\": \"i\", \"castfunc\": \"0\", \"castmethod\": \"b\", \"castsource\": \"int4\", \"casttarget\": \"regconfig\"}, {\"castcontext\": \"i\", \"castfunc\": \"0\", \"castmethod\": \"b\", \"castsource\": \"int4\", \"casttarget\": \"regdictionary\"}, {\"castcontext\": \"i\", \"castfunc\": \"0\", \"castmethod\": \"b\", \"castsource\": \"int4\", \"casttarget\": \"regnamespace\"}, {\"castcontext\": \"i\", \"castfunc\": \"0\", \"castmethod\": \"b\", \"castsource\": \"int4\", \"casttarget\": \"regoper\"}, {\"castcontext\": \"i\", \"castfunc\": \"0\", \"castmethod\": \"b\", \"castsource\": \"int4\", \"casttarget\": \"regoperator\"}, {\"castcontext\": \"i\", \"castfunc\": \"0\", \"castmethod\": \"b\", \"castsource\": \"int4\", \"casttarget\": \"regproc\"}, {\"castcontext\": \"i\", \"castfunc\": \"0\", \"castmethod\": \"b\", \"castsource\": \"int4\", \"casttarget\": \"regprocedure\"}, {\"castcontext\": \"i\", \"castfunc\": \"0\", \"castmethod\": \"b\", \"castsource\": \"int4\", \"casttarget\": \"regrole\"}, {\"castcontext\": \"i\", \"castfunc\": \"0\", \"castmethod\": \"b\", \"castsource\": \"int4\", \"casttarget\": \"regtype\"}, {\"castcontext\": \"i\", \"castfunc\": \"float4(int4)\", \"castmethod\": \"f\", \"castsource\": \"int4\", \"casttarget\": \"float4\"}, {\"castcontext\": \"i\", \"castfunc\": \"float8(int4)\", \"castmethod\": \"f\", \"castsource\": \"int4\", \"casttarget\": \"float8\"}, {\"castcontext\": \"i\", \"castfunc\": \"int4(int2)\", \"castmethod\": \"f\", \"castsource\": \"int2\", \"casttarget\": \"int4\"}, {\"castcontext\": \"i\", \"castfunc\": \"int8(int4)\", \"castmethod\": \"f\", \"castsource\": \"int4\", \"casttarget\": \"int8\"}, {\"castcontext\": \"i\", \"castfunc\": \"numeric(int4)\", \"castmethod\": \"f\", \"castsource\": \"int4\", \"casttarget\": \"numeric\"}]"}], "prose_changed": false}}