{"kind": "operator", "major": "18", "item": {"slug": "op-7c7c-anycompatiblearray-anycompatiblearray", "name": "||(anycompatiblearray,anycompatiblearray)", "name_zh": "", "category": "\u4f2a\u7c7b\u578b", "summary": "\u8fde\u63a5", "aliases": ["||", "||(anycompatiblearray,anycompatiblearray)"], "content_hash": "9ef558ded1f000589b7aea9207cd03577ee1601b3c40fe993043bae9760ce600", "versions": {"14": {"facts": [{"label": "\u5de6\u64cd\u4f5c\u6570", "value": "anycompatiblearray"}, {"label": "\u53f3\u64cd\u4f5c\u6570", "value": "anycompatiblearray"}, {"label": "\u8fd4\u56de\u7c7b\u578b", "value": "anycompatiblearray"}, {"label": "\u5b9e\u73b0\u51fd\u6570", "value": "array_cat(anycompatiblearray,anycompatiblearray)"}, {"label": "\u64cd\u4f5c\u7b26\u79cd\u7c7b", "value": "Binary"}, {"label": "\u53ef\u7528\u4e8e\u54c8\u5e0c\u8fde\u63a5", "value": "\u5426"}, {"label": "\u53ef\u7528\u4e8e\u5f52\u5e76\u8fde\u63a5", "value": "\u5426"}], "tables": [], "aliases": ["||", "||(anycompatiblearray,anycompatiblearray)"], "related": [{"url": "/wiki/type/anycompatiblearray/?v=14", "label": "anycompatiblearray \u6570\u636e\u7c7b\u578b"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v14.24/postgresql-14.24.tar.bz2", "label": "14.24", "major": "14", "channel": "stable", "revision": "a7fa7ed3d558172355f51406097a7bd4f6b473be80f311ef7cda96bf383d8897", "source_sha256": "a7fa7ed3d558172355f51406097a7bd4f6b473be80f311ef7cda96bf383d8897", "manual_fingerprint": "1d055c6dc55d4defe2b6e9d0f842a47005487b21025b67e51d06721d3c122f71", "catalog_fingerprint": "9e0116f26e5ce870719efb77ef7b73e30c7928f8af27cbe87fdea32efe3811ef"}, "sources": [{"url": "https://ftp.postgresql.org/pub/source/v14.24/postgresql-14.24.tar.bz2", "label": "Matching PostgreSQL source archive", "sha256": "a7fa7ed3d558172355f51406097a7bd4f6b473be80f311ef7cda96bf383d8897"}, {"url": "https://pg.center/docs/14/catalog-pg-operator.html", "path": "catalog-pg-operator.html", "label": "PostgreSQL 14 English manual: catalog-pg-operator.html", "sha256": "5e69fa82a7f0b49efb4ba5fc669e5bd35aeeede75682493bfc87e6035b23dd4d", "language": "en", "original_url": "/docs/14/catalog-pg-operator.html"}, {"url": "https://pg.center/docs/14/catalog-pg-amop.html", "path": "catalog-pg-amop.html", "label": "PostgreSQL 14 English manual: catalog-pg-amop.html", "sha256": "402b87d7fb1a313b096ba5349a676ae38d507e2eb98739d6ed7f0681e0b9a9a4", "language": "en", "original_url": "/docs/14/catalog-pg-amop.html"}, {"url": "https://pg.center/docs/14/functions-array.html#ARRAY-OPERATORS-TABLE", "path": "functions-array.html", "label": "PostgreSQL 14 English manual: functions-array.html", "sha256": "060b0c966d3d15591cbd968eaedd31c9cd3d882a6f7cefd1521bca5f7795c12a", "language": "en", "original_url": "/docs/14/functions-array.html#ARRAY-OPERATORS-TABLE"}], "operator": {"kind": "b", "symbol": "||", "negator": "", "function": "array_cat(anycompatiblearray,anycompatiblearray)", "hash_join": "f", "left_type": "anycompatiblearray", "commutator": "", "merge_join": "f", "right_type": "anycompatiblearray", "result_type": "anycompatiblearray"}, "sections": [{"title": "\u82f1\u6587\u624b\u518c\u5b9a\u4e49", "paragraphs": ["\u8fde\u63a5\u4e24\u4e2a\u6570\u7ec4\u3002\u8fde\u63a5 null \u6216\u7a7a\u6570\u7ec4\u4e0d\u4f1a\u4ea7\u751f\u4efb\u4f55\u6548\u679c\uff1b\u5426\u5219\uff0c\u6570\u7ec4\u5fc5\u987b\u5177\u6709\u76f8\u540c\u7684\u7ef4\u6570\uff08\u5982\u7b2c\u4e00\u4e2a\u793a\u4f8b\u6240\u793a\uff09\uff0c\u6216\u7ef4\u6570\u76f8\u5dee\u4e00\u7ef4\uff08\u5982\u7b2c\u4e8c\u4e2a\u793a\u4f8b\u6240\u793a\uff09\u3002\u5982\u679c\u6570\u7ec4\u7684\u5143\u7d20\u7c7b\u578b\u4e0d\u540c\uff0c\u5219\u4f1a\u5c06\u5b83\u4eec\u5f3a\u5236\u8f6c\u6362\u4e3a\u540c\u4e00\u4e2a\u7c7b\u578b\uff08\u53c2\u89c1 \u7b2c 10.5 \u8282 \uff09\u3002", "ARRAY[1,2,3] || ARRAY[4,5,6,7] \u2192 {1,2,3,4,5,6,7}", "ARRAY[1,2,3] || ARRAY[[4,5,6],[7,8,9.9]] \u2192 {{1,2,3},{4,5,6},{7,8,9.9}}"]}, {"title": "\u76ee\u5f55\u8bb0\u5f55\u89e3\u8bfb", "paragraphs": ["\u76ee\u5f55 pg_operator \u5b58\u50a8\u5173\u4e8e\u64cd\u4f5c\u7b26\u7684\u4fe1\u606f\u3002\u8be6\u89c1 CREATE OPERATOR \u548c \u7b2c 38.14 \u8282 \u3002"]}], "signature": "||(anycompatiblearray,anycompatiblearray) \u2192 anycompatiblearray", "source_oid": "375", "description": ["\u8fde\u63a5"], "memberships": [], "localization": {"status": "complete", "sources": [{"url": "/docs/14/catalog-pg-operator.html", "method": "same-major semantic node", "sha256": "77531e62ed30180fca3990f31ecee43d1a140f3a459c18583e5158aa4b41435a", "language": "zh", "matched_nodes": ["#CATALOG-PG-OPERATOR/p[2]"]}, {"url": "/docs/14/functions-array.html", "method": "same-major semantic node", "sha256": "9782299db4c3b687e0bc9e3e2b2d3dd303b44c7c33039f518b8984ff4d1114a9", "language": "zh", "matched_nodes": ["#FUNCTIONS-ARRAY/div[2]/div[1]/table[0]/tbody[2]/tr[3]/td[0]/p[1]"]}], "language": "zh", "original_text": {"/versions/14/description/0": "concatenate", "/versions/14/facts/0/label": "Left operand", "/versions/14/facts/1/label": "Right operand", "/versions/14/facts/2/label": "Result type", "/versions/14/facts/3/label": "Implementing function", "/versions/14/facts/4/label": "Operator kind", "/versions/14/facts/5/label": "Hash join candidate", "/versions/14/facts/5/value": "no", "/versions/14/facts/6/label": "Merge join candidate", "/versions/14/facts/6/value": "no", "/versions/14/related/0/label": "anycompatiblearray data type", "/versions/14/sections/0/title": "English manual definition", "/versions/14/sections/1/title": "Catalog interpretation", "/versions/14/sections/0/paragraphs/0": "Concatenates the two arrays. Concatenating a null or empty array is a no-op; otherwise the arrays must have the same number of dimensions (as illustrated by the first example) or differ in number of dimensions by one (as illustrated by the second). If the arrays are not of identical element types, they will be coerced to a common type (see Section 10.5 ).", "/versions/14/sections/1/paragraphs/0": "The catalog pg_operator stores information about operators. See CREATE OPERATOR and Section 38.14 for more information."}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "4d5cc83acdf4dd229e1699db1a237f6be5e826b6f63b39d047ed5e95b4198781"}, "comparison_data": {"operator": {"kind": "b", "symbol": "||", "negator": "", "function": "array_cat(anycompatiblearray,anycompatiblearray)", "hash_join": "f", "left_type": "anycompatiblearray", "commutator": "", "merge_join": "f", "right_type": "anycompatiblearray", "result_type": "anycompatiblearray"}, "memberships": []}, "comparison_hash": "bcb679177559f63619ba272b4580941aca7dfd52dd5b0fece7e7d25c92d6a34a", "manual_semantics": "Exact operand/result signature matched"}, "15": {"facts": [{"label": "\u5de6\u64cd\u4f5c\u6570", "value": "anycompatiblearray"}, {"label": "\u53f3\u64cd\u4f5c\u6570", "value": "anycompatiblearray"}, {"label": "\u8fd4\u56de\u7c7b\u578b", "value": "anycompatiblearray"}, {"label": "\u5b9e\u73b0\u51fd\u6570", "value": "array_cat(anycompatiblearray,anycompatiblearray)"}, {"label": "\u64cd\u4f5c\u7b26\u79cd\u7c7b", "value": "Binary"}, {"label": "\u53ef\u7528\u4e8e\u54c8\u5e0c\u8fde\u63a5", "value": "\u5426"}, {"label": "\u53ef\u7528\u4e8e\u5f52\u5e76\u8fde\u63a5", "value": "\u5426"}], "tables": [], "aliases": ["||", "||(anycompatiblearray,anycompatiblearray)"], "related": [{"url": "/wiki/type/anycompatiblearray/?v=15", "label": "anycompatiblearray \u6570\u636e\u7c7b\u578b"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v15.19/postgresql-15.19.tar.bz2", "label": "15.19", "major": "15", "channel": "stable", "revision": "e1a64a87a46b825b88c082e4518161a47aab53c45694964f8ba1df28f7859f89", "source_sha256": "e1a64a87a46b825b88c082e4518161a47aab53c45694964f8ba1df28f7859f89", "manual_fingerprint": "f39c61e9facb5b9404c7d6d1cf494d83af0cc46146554a7fc40724eb882d24a9", "catalog_fingerprint": "1c332a5ccec7bfdd8ca19b55a0279b5bd6cb1dd5dcc6c5587a98a491a9b566a5"}, "sources": [{"url": "https://ftp.postgresql.org/pub/source/v15.19/postgresql-15.19.tar.bz2", "label": "Matching PostgreSQL source archive", "sha256": "e1a64a87a46b825b88c082e4518161a47aab53c45694964f8ba1df28f7859f89"}, {"url": "https://pg.center/docs/15/catalog-pg-operator.html", "path": "catalog-pg-operator.html", "label": "PostgreSQL 15 English manual: catalog-pg-operator.html", "sha256": "3719563ca7bb28791116cb206b9998cd336d09fb4d4cc4a236b6447bcfd5cbb2", "language": "en", "original_url": "/docs/15/catalog-pg-operator.html"}, {"url": "https://pg.center/docs/15/catalog-pg-amop.html", "path": "catalog-pg-amop.html", "label": "PostgreSQL 15 English manual: catalog-pg-amop.html", "sha256": "53ced8770f19710869151ab02a9a6f0d97380981ca4bfe83752092bfb74a9e0c", "language": "en", "original_url": "/docs/15/catalog-pg-amop.html"}, {"url": "https://pg.center/docs/15/functions-array.html#ARRAY-OPERATORS-TABLE", "path": "functions-array.html", "label": "PostgreSQL 15 English manual: functions-array.html", "sha256": "3a51987d44e436f2a5fd3d31371d7ac3213ecd6f86d8efc297d9e902dbbe1954", "language": "en", "original_url": "/docs/15/functions-array.html#ARRAY-OPERATORS-TABLE"}], "operator": {"kind": "b", "symbol": "||", "negator": "", "function": "array_cat(anycompatiblearray,anycompatiblearray)", "hash_join": "f", "left_type": "anycompatiblearray", "commutator": "", "merge_join": "f", "right_type": "anycompatiblearray", "result_type": "anycompatiblearray"}, "sections": [{"title": "\u82f1\u6587\u624b\u518c\u5b9a\u4e49", "paragraphs": ["\u8fde\u63a5\u4e24\u4e2a\u6570\u7ec4\u3002\u8fde\u63a5 null \u6216\u7a7a\u6570\u7ec4\u4e0d\u4f1a\u4ea7\u751f\u4efb\u4f55\u6548\u679c\uff1b\u5426\u5219\uff0c\u6570\u7ec4\u5fc5\u987b\u5177\u6709\u76f8\u540c\u7684\u7ef4\u6570\uff08\u5982\u7b2c\u4e00\u4e2a\u793a\u4f8b\u6240\u793a\uff09\uff0c\u6216\u7ef4\u6570\u76f8\u5dee\u4e00\u7ef4\uff08\u5982\u7b2c\u4e8c\u4e2a\u793a\u4f8b\u6240\u793a\uff09\u3002\u5982\u679c\u6570\u7ec4\u7684\u5143\u7d20\u7c7b\u578b\u4e0d\u540c\uff0c\u5219\u4f1a\u5c06\u5b83\u4eec\u5f3a\u5236\u8f6c\u6362\u4e3a\u540c\u4e00\u4e2a\u7c7b\u578b\uff08\u53c2\u89c1 \u7b2c 10.5 \u8282 \uff09\u3002", "ARRAY[1,2,3] || ARRAY[4,5,6,7] \u2192 {1,2,3,4,5,6,7}", "ARRAY[1,2,3] || ARRAY[[4,5,6],[7,8,9.9]] \u2192 {{1,2,3},{4,5,6},{7,8,9.9}}"]}, {"title": "\u76ee\u5f55\u8bb0\u5f55\u89e3\u8bfb", "paragraphs": ["\u76ee\u5f55 pg_operator \u5b58\u50a8\u5173\u4e8e\u64cd\u4f5c\u7b26\u7684\u4fe1\u606f\u3002\u8be6\u89c1 CREATE OPERATOR \u548c \u7b2c 38.14 \u8282 \u3002"]}], "signature": "||(anycompatiblearray,anycompatiblearray) \u2192 anycompatiblearray", "source_oid": "375", "description": ["\u8fde\u63a5"], "memberships": [], "localization": {"status": "complete", "sources": [{"url": "/docs/15/catalog-pg-operator.html", "method": "same-major semantic node", "sha256": "4865734bda46f48a054c1c554b2ff262358a48b562081c1f01a178a6df15e38b", "language": "zh", "matched_nodes": ["#CATALOG-PG-OPERATOR/p[2]"]}, {"url": "/docs/15/functions-array.html", "method": "same-major semantic node", "sha256": "63a5366566d831e563c2912e58e18684791947a72d43a1947d81d840b6debc5e", "language": "zh", "matched_nodes": ["#FUNCTIONS-ARRAY/div[2]/div[1]/table[0]/tbody[2]/tr[3]/td[0]/p[1]"]}], "language": "zh", "original_text": {"/versions/15/description/0": "concatenate", "/versions/15/facts/0/label": "Left operand", "/versions/15/facts/1/label": "Right operand", "/versions/15/facts/2/label": "Result type", "/versions/15/facts/3/label": "Implementing function", "/versions/15/facts/4/label": "Operator kind", "/versions/15/facts/5/label": "Hash join candidate", "/versions/15/facts/5/value": "no", "/versions/15/facts/6/label": "Merge join candidate", "/versions/15/facts/6/value": "no", "/versions/15/related/0/label": "anycompatiblearray data type", "/versions/15/sections/0/title": "English manual definition", "/versions/15/sections/1/title": "Catalog interpretation", "/versions/15/sections/0/paragraphs/0": "Concatenates the two arrays. Concatenating a null or empty array is a no-op; otherwise the arrays must have the same number of dimensions (as illustrated by the first example) or differ in number of dimensions by one (as illustrated by the second). If the arrays are not of identical element types, they will be coerced to a common type (see Section 10.5 ).", "/versions/15/sections/1/paragraphs/0": "The catalog pg_operator stores information about operators. See CREATE OPERATOR and Section 38.14 for more information."}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "790da5a05054647b96f61152bcb73c0fa1aec0df23175f5a765b790b8436f0b8"}, "comparison_data": {"operator": {"kind": "b", "symbol": "||", "negator": "", "function": "array_cat(anycompatiblearray,anycompatiblearray)", "hash_join": "f", "left_type": "anycompatiblearray", "commutator": "", "merge_join": "f", "right_type": "anycompatiblearray", "result_type": "anycompatiblearray"}, "memberships": []}, "comparison_hash": "bcb679177559f63619ba272b4580941aca7dfd52dd5b0fece7e7d25c92d6a34a", "manual_semantics": "Exact operand/result signature matched"}, "16": {"facts": [{"label": "\u5de6\u64cd\u4f5c\u6570", "value": "anycompatiblearray"}, {"label": "\u53f3\u64cd\u4f5c\u6570", "value": "anycompatiblearray"}, {"label": "\u8fd4\u56de\u7c7b\u578b", "value": "anycompatiblearray"}, {"label": "\u5b9e\u73b0\u51fd\u6570", "value": "array_cat(anycompatiblearray,anycompatiblearray)"}, {"label": "\u64cd\u4f5c\u7b26\u79cd\u7c7b", "value": "Binary"}, {"label": "\u53ef\u7528\u4e8e\u54c8\u5e0c\u8fde\u63a5", "value": "\u5426"}, {"label": "\u53ef\u7528\u4e8e\u5f52\u5e76\u8fde\u63a5", "value": "\u5426"}], "tables": [], "aliases": ["||", "||(anycompatiblearray,anycompatiblearray)"], "related": [{"url": "/wiki/type/anycompatiblearray/?v=16", "label": "anycompatiblearray \u6570\u636e\u7c7b\u578b"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v16.15/postgresql-16.15.tar.bz2", "label": "16.15", "major": "16", "channel": "stable", "revision": "c1575341fa7bd40f5274ea465b34390f4dc64cdd0770af327005caaeb9f6b7ed", "source_sha256": "c1575341fa7bd40f5274ea465b34390f4dc64cdd0770af327005caaeb9f6b7ed", "manual_fingerprint": "846fb006e9d590387203c1c65f671240bc5c30604c4e3084cf572817aacc19d0", "catalog_fingerprint": "70797d889dd8aeed77ae81092f99ab380e1109b54b0b7ca6fbf400e0a2111a70"}, "sources": [{"url": "https://ftp.postgresql.org/pub/source/v16.15/postgresql-16.15.tar.bz2", "label": "Matching PostgreSQL source archive", "sha256": "c1575341fa7bd40f5274ea465b34390f4dc64cdd0770af327005caaeb9f6b7ed"}, {"url": "https://pg.center/docs/16/catalog-pg-operator.html", "path": "catalog-pg-operator.html", "label": "PostgreSQL 16 English manual: catalog-pg-operator.html", "sha256": "dc789ccf76b6bcbb9b1793858fe700431720a1e70f3261de2b3362ed78040476", "language": "en", "original_url": "/docs/16/catalog-pg-operator.html"}, {"url": "https://pg.center/docs/16/catalog-pg-amop.html", "path": "catalog-pg-amop.html", "label": "PostgreSQL 16 English manual: catalog-pg-amop.html", "sha256": "f580ac4a34d5f9d567834684e0c41b7df32a952e20a2fc11a9ce0964c2df7e9a", "language": "en", "original_url": "/docs/16/catalog-pg-amop.html"}, {"url": "https://pg.center/docs/16/functions-array.html#ARRAY-OPERATORS-TABLE", "path": "functions-array.html", "label": "PostgreSQL 16 English manual: functions-array.html", "sha256": "d7f628dae90278f57c4d5306b81206e85506017da233d2e41f01c1ee261c64f5", "language": "en", "original_url": "/docs/16/functions-array.html#ARRAY-OPERATORS-TABLE"}], "operator": {"kind": "b", "symbol": "||", "negator": "", "function": "array_cat(anycompatiblearray,anycompatiblearray)", "hash_join": "f", "left_type": "anycompatiblearray", "commutator": "", "merge_join": "f", "right_type": "anycompatiblearray", "result_type": "anycompatiblearray"}, "sections": [{"title": "\u82f1\u6587\u624b\u518c\u5b9a\u4e49", "paragraphs": ["\u8fde\u63a5\u4e24\u4e2a\u6570\u7ec4\u3002\u8fde\u63a5 null \u6216\u7a7a\u6570\u7ec4\u4e0d\u4f1a\u4ea7\u751f\u4efb\u4f55\u6548\u679c\uff1b\u5426\u5219\uff0c\u6570\u7ec4\u5fc5\u987b\u5177\u6709\u76f8\u540c\u7684\u7ef4\u6570\uff08\u5982\u7b2c\u4e00\u4e2a\u793a\u4f8b\u6240\u793a\uff09\uff0c\u6216\u7ef4\u6570\u76f8\u5dee\u4e00\u7ef4\uff08\u5982\u7b2c\u4e8c\u4e2a\u793a\u4f8b\u6240\u793a\uff09\u3002\u5982\u679c\u6570\u7ec4\u7684\u5143\u7d20\u7c7b\u578b\u4e0d\u540c\uff0c\u5219\u4f1a\u5c06\u5b83\u4eec\u5f3a\u5236\u8f6c\u6362\u4e3a\u540c\u4e00\u4e2a\u7c7b\u578b\uff08\u53c2\u89c1 \u7b2c 10.5 \u8282 \uff09\u3002", "ARRAY[1,2,3] || ARRAY[4,5,6,7] \u2192 {1,2,3,4,5,6,7}", "ARRAY[1,2,3] || ARRAY[[4,5,6],[7,8,9.9]] \u2192 {{1,2,3},{4,5,6},{7,8,9.9}}"]}, {"title": "\u76ee\u5f55\u8bb0\u5f55\u89e3\u8bfb", "paragraphs": ["\u76ee\u5f55 pg_operator \u5b58\u50a8\u5173\u4e8e\u64cd\u4f5c\u7b26\u7684\u4fe1\u606f\u3002\u8be6\u89c1 CREATE OPERATOR \u548c \u7b2c 38.14 \u8282 \u3002"]}], "signature": "||(anycompatiblearray,anycompatiblearray) \u2192 anycompatiblearray", "source_oid": "375", "description": ["\u8fde\u63a5"], "memberships": [], "localization": {"status": "complete", "sources": [{"url": "/docs/16/catalog-pg-operator.html", "method": "same-major semantic node", "sha256": "ff2395afae4eb19cedbcb0acbd87a844078e82ba0722c2dbe9e7fa0c4c6503d4", "language": "zh", "matched_nodes": ["#CATALOG-PG-OPERATOR/p[2]"]}, {"url": "/docs/16/functions-array.html", "method": "same-major semantic node", "sha256": "edd3b6606a2929629f746b3a82d883a41d4e15c1644d2b0c17b7d29ca050e341", "language": "zh", "matched_nodes": ["#FUNCTIONS-ARRAY/div[2]/div[1]/table[0]/tbody[2]/tr[3]/td[0]/p[1]"]}], "language": "zh", "original_text": {"/versions/16/description/0": "concatenate", "/versions/16/facts/0/label": "Left operand", "/versions/16/facts/1/label": "Right operand", "/versions/16/facts/2/label": "Result type", "/versions/16/facts/3/label": "Implementing function", "/versions/16/facts/4/label": "Operator kind", "/versions/16/facts/5/label": "Hash join candidate", "/versions/16/facts/5/value": "no", "/versions/16/facts/6/label": "Merge join candidate", "/versions/16/facts/6/value": "no", "/versions/16/related/0/label": "anycompatiblearray data type", "/versions/16/sections/0/title": "English manual definition", "/versions/16/sections/1/title": "Catalog interpretation", "/versions/16/sections/0/paragraphs/0": "Concatenates the two arrays. Concatenating a null or empty array is a no-op; otherwise the arrays must have the same number of dimensions (as illustrated by the first example) or differ in number of dimensions by one (as illustrated by the second). If the arrays are not of identical element types, they will be coerced to a common type (see Section 10.5 ).", "/versions/16/sections/1/paragraphs/0": "The catalog pg_operator stores information about operators. See CREATE OPERATOR and Section 38.14 for more information."}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "244caaebd293f8fa0b9412c353e98de49104c6382c324a15c1535b08eb32647b"}, "comparison_data": {"operator": {"kind": "b", "symbol": "||", "negator": "", "function": "array_cat(anycompatiblearray,anycompatiblearray)", "hash_join": "f", "left_type": "anycompatiblearray", "commutator": "", "merge_join": "f", "right_type": "anycompatiblearray", "result_type": "anycompatiblearray"}, "memberships": []}, "comparison_hash": "bcb679177559f63619ba272b4580941aca7dfd52dd5b0fece7e7d25c92d6a34a", "manual_semantics": "Exact operand/result signature matched"}, "17": {"facts": [{"label": "\u5de6\u64cd\u4f5c\u6570", "value": "anycompatiblearray"}, {"label": "\u53f3\u64cd\u4f5c\u6570", "value": "anycompatiblearray"}, {"label": "\u8fd4\u56de\u7c7b\u578b", "value": "anycompatiblearray"}, {"label": "\u5b9e\u73b0\u51fd\u6570", "value": "array_cat(anycompatiblearray,anycompatiblearray)"}, {"label": "\u64cd\u4f5c\u7b26\u79cd\u7c7b", "value": "Binary"}, {"label": "\u53ef\u7528\u4e8e\u54c8\u5e0c\u8fde\u63a5", "value": "\u5426"}, {"label": "\u53ef\u7528\u4e8e\u5f52\u5e76\u8fde\u63a5", "value": "\u5426"}], "tables": [], "aliases": ["||", "||(anycompatiblearray,anycompatiblearray)"], "related": [{"url": "/wiki/type/anycompatiblearray/?v=17", "label": "anycompatiblearray \u6570\u636e\u7c7b\u578b"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v17.11/postgresql-17.11.tar.bz2", "label": "17.11", "major": "17", "channel": "stable", "revision": "dd27f2b3c59e73ed14aa3324901242bf69a032a6347805f274e6260322d42979", "source_sha256": "dd27f2b3c59e73ed14aa3324901242bf69a032a6347805f274e6260322d42979", "manual_fingerprint": "b55870f8e80e1114a92ac7bfc97f4a6fa0dee8e75935895252bb6e5b866cf187", "catalog_fingerprint": "e888e3474202df1c60a8e7b6bf9f2d83b3866a52d119521659b7a82787d3829d"}, "sources": [{"url": "https://ftp.postgresql.org/pub/source/v17.11/postgresql-17.11.tar.bz2", "label": "Matching PostgreSQL source archive", "sha256": "dd27f2b3c59e73ed14aa3324901242bf69a032a6347805f274e6260322d42979"}, {"url": "https://pg.center/docs/17/catalog-pg-operator.html", "path": "catalog-pg-operator.html", "label": "PostgreSQL 17 English manual: catalog-pg-operator.html", "sha256": "a66984c4fde91649a9677d33a2e002381cb07e99d72ad0971fa3251741030a69", "language": "en", "original_url": "/docs/17/catalog-pg-operator.html"}, {"url": "https://pg.center/docs/17/catalog-pg-amop.html", "path": "catalog-pg-amop.html", "label": "PostgreSQL 17 English manual: catalog-pg-amop.html", "sha256": "19b2fb110b348860f7fbcb6e0e0544e341f5645113c23f50920a54434d432359", "language": "en", "original_url": "/docs/17/catalog-pg-amop.html"}, {"url": "https://pg.center/docs/17/functions-array.html#ARRAY-OPERATORS-TABLE", "path": "functions-array.html", "label": "PostgreSQL 17 English manual: functions-array.html", "sha256": "24ff62c83b1d0bea3a4d84fa2d85e3acf7ce23e786aae52571d9be14e8075291", "language": "en", "original_url": "/docs/17/functions-array.html#ARRAY-OPERATORS-TABLE"}], "operator": {"kind": "b", "symbol": "||", "negator": "", "function": "array_cat(anycompatiblearray,anycompatiblearray)", "hash_join": "f", "left_type": "anycompatiblearray", "commutator": "", "merge_join": "f", "right_type": "anycompatiblearray", "result_type": "anycompatiblearray"}, "sections": [{"title": "\u82f1\u6587\u624b\u518c\u5b9a\u4e49", "paragraphs": ["\u8fde\u63a5\u4e24\u4e2a\u6570\u7ec4\u3002\u8fde\u63a5 null \u6216\u7a7a\u6570\u7ec4\u4e0d\u4f1a\u4ea7\u751f\u4efb\u4f55\u6548\u679c\uff1b\u5426\u5219\uff0c\u6570\u7ec4\u5fc5\u987b\u5177\u6709\u76f8\u540c\u7684\u7ef4\u6570\uff08\u5982\u7b2c\u4e00\u4e2a\u793a\u4f8b\u6240\u793a\uff09\uff0c\u6216\u7ef4\u6570\u76f8\u5dee\u4e00\u7ef4\uff08\u5982\u7b2c\u4e8c\u4e2a\u793a\u4f8b\u6240\u793a\uff09\u3002\u5982\u679c\u6570\u7ec4\u7684\u5143\u7d20\u7c7b\u578b\u4e0d\u540c\uff0c\u5219\u4f1a\u5c06\u5b83\u4eec\u5f3a\u5236\u8f6c\u6362\u4e3a\u540c\u4e00\u4e2a\u7c7b\u578b\uff08\u53c2\u89c1 \u7b2c 10.5 \u8282 \uff09\u3002", "ARRAY[1,2,3] || ARRAY[4,5,6,7] \u2192 {1,2,3,4,5,6,7}", "ARRAY[1,2,3] || ARRAY[[4,5,6],[7,8,9.9]] \u2192 {{1,2,3},{4,5,6},{7,8,9.9}}"]}, {"title": "\u76ee\u5f55\u8bb0\u5f55\u89e3\u8bfb", "paragraphs": ["\u76ee\u5f55 pg_operator \u5b58\u50a8\u5173\u4e8e\u64cd\u4f5c\u7b26\u7684\u4fe1\u606f\u3002\u8be6\u89c1 CREATE OPERATOR \u548c \u7b2c 36.14 \u8282 \u3002"]}], "signature": "||(anycompatiblearray,anycompatiblearray) \u2192 anycompatiblearray", "source_oid": "375", "description": ["\u8fde\u63a5"], "memberships": [], "localization": {"status": "complete", "sources": [{"url": "/docs/17/catalog-pg-operator.html", "method": "same-major semantic node", "sha256": "f83afaba592d4bb686da0579943b49e4c821b3df0a02b82c5fab86e1d168a26e", "language": "zh", "matched_nodes": ["#CATALOG-PG-OPERATOR/p[2]"]}, {"url": "/docs/17/functions-array.html", "method": "same-major semantic node", "sha256": "1f2bbb3053bfea41ee69493c671dadbcfa0038c01d2526997802c5f5696bb154", "language": "zh", "matched_nodes": ["#FUNCTIONS-ARRAY/div[2]/div[1]/table[0]/tbody[2]/tr[3]/td[0]/p[1]"]}], "language": "zh", "original_text": {"/versions/17/description/0": "concatenate", "/versions/17/facts/0/label": "Left operand", "/versions/17/facts/1/label": "Right operand", "/versions/17/facts/2/label": "Result type", "/versions/17/facts/3/label": "Implementing function", "/versions/17/facts/4/label": "Operator kind", "/versions/17/facts/5/label": "Hash join candidate", "/versions/17/facts/5/value": "no", "/versions/17/facts/6/label": "Merge join candidate", "/versions/17/facts/6/value": "no", "/versions/17/related/0/label": "anycompatiblearray data type", "/versions/17/sections/0/title": "English manual definition", "/versions/17/sections/1/title": "Catalog interpretation", "/versions/17/sections/0/paragraphs/0": "Concatenates the two arrays. Concatenating a null or empty array is a no-op; otherwise the arrays must have the same number of dimensions (as illustrated by the first example) or differ in number of dimensions by one (as illustrated by the second). If the arrays are not of identical element types, they will be coerced to a common type (see Section 10.5 ).", "/versions/17/sections/1/paragraphs/0": "The catalog pg_operator stores information about operators. See CREATE OPERATOR and Section 36.14 for more information."}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "e0fce37ba525773705368b9ce02ab8e331f77ea3c2b2d71ebd809a8727615768"}, "comparison_data": {"operator": {"kind": "b", "symbol": "||", "negator": "", "function": "array_cat(anycompatiblearray,anycompatiblearray)", "hash_join": "f", "left_type": "anycompatiblearray", "commutator": "", "merge_join": "f", "right_type": "anycompatiblearray", "result_type": "anycompatiblearray"}, "memberships": []}, "comparison_hash": "bcb679177559f63619ba272b4580941aca7dfd52dd5b0fece7e7d25c92d6a34a", "manual_semantics": "Exact operand/result signature matched"}, "18": {"facts": [{"label": "\u5de6\u64cd\u4f5c\u6570", "value": "anycompatiblearray"}, {"label": "\u53f3\u64cd\u4f5c\u6570", "value": "anycompatiblearray"}, {"label": "\u8fd4\u56de\u7c7b\u578b", "value": "anycompatiblearray"}, {"label": "\u5b9e\u73b0\u51fd\u6570", "value": "array_cat(anycompatiblearray,anycompatiblearray)"}, {"label": "\u64cd\u4f5c\u7b26\u79cd\u7c7b", "value": "Binary"}, {"label": "\u53ef\u7528\u4e8e\u54c8\u5e0c\u8fde\u63a5", "value": "\u5426"}, {"label": "\u53ef\u7528\u4e8e\u5f52\u5e76\u8fde\u63a5", "value": "\u5426"}], "tables": [], "aliases": ["||", "||(anycompatiblearray,anycompatiblearray)"], "related": [{"url": "/wiki/type/anycompatiblearray/?v=18", "label": "anycompatiblearray \u6570\u636e\u7c7b\u578b"}], "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_sha256": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f", "manual_fingerprint": "fefce9e478eb2afe5e17e869492bbedc67dce23d317f0a5257240113d6496ebc", "catalog_fingerprint": "deec62e0f0c649d9d0d058ddd0b16bf41afffd569c3fd73949ff0971ce5cabd6"}, "sources": [{"url": "https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2", "label": "Matching PostgreSQL source archive", "sha256": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"}, {"url": "https://pg.center/docs/18/catalog-pg-operator.html", "path": "catalog-pg-operator.html", "label": "PostgreSQL 18 English manual: catalog-pg-operator.html", "sha256": "e0b1817914e5e8f9037955cd41e9a43584e9227fcc115784898ecdd9a6c0ecd6", "language": "en", "original_url": "/docs/18/catalog-pg-operator.html"}, {"url": "https://pg.center/docs/18/catalog-pg-amop.html", "path": "catalog-pg-amop.html", "label": "PostgreSQL 18 English manual: catalog-pg-amop.html", "sha256": "e65b90ee78eaf4b4da97ce5b08b972cee2e2660b882ec107be22eca47201f7d1", "language": "en", "original_url": "/docs/18/catalog-pg-amop.html"}, {"url": "https://pg.center/docs/18/functions-array.html#ARRAY-OPERATORS-TABLE", "path": "functions-array.html", "label": "PostgreSQL 18 English manual: functions-array.html", "sha256": "d84446981971a18b9bab327f3c737737f8cc290dd9963d1472c7e6cab60bea7c", "language": "en", "original_url": "/docs/18/functions-array.html#ARRAY-OPERATORS-TABLE"}], "operator": {"kind": "b", "symbol": "||", "negator": "", "function": "array_cat(anycompatiblearray,anycompatiblearray)", "hash_join": "f", "left_type": "anycompatiblearray", "commutator": "", "merge_join": "f", "right_type": "anycompatiblearray", "result_type": "anycompatiblearray"}, "sections": [{"title": "\u82f1\u6587\u624b\u518c\u5b9a\u4e49", "paragraphs": ["\u8fde\u63a5\u4e24\u4e2a\u6570\u7ec4\u3002\u8fde\u63a5 null \u6216\u7a7a\u6570\u7ec4\u4e0d\u4f1a\u4ea7\u751f\u4efb\u4f55\u6548\u679c\uff1b\u5426\u5219\uff0c\u6570\u7ec4\u5fc5\u987b\u5177\u6709\u76f8\u540c\u7684\u7ef4\u6570\uff08\u5982\u7b2c\u4e00\u4e2a\u793a\u4f8b\u6240\u793a\uff09\uff0c\u6216\u7ef4\u6570\u76f8\u5dee\u4e00\u7ef4\uff08\u5982\u7b2c\u4e8c\u4e2a\u793a\u4f8b\u6240\u793a\uff09\u3002\u5982\u679c\u6570\u7ec4\u7684\u5143\u7d20\u7c7b\u578b\u4e0d\u540c\uff0c\u5219\u4f1a\u5c06\u5b83\u4eec\u5f3a\u5236\u8f6c\u6362\u4e3a\u540c\u4e00\u4e2a\u7c7b\u578b\uff08\u53c2\u89c1 \u7b2c 10.5 \u8282 \uff09\u3002", "ARRAY[1,2,3] || ARRAY[4,5,6,7] \u2192 {1,2,3,4,5,6,7}", "ARRAY[1,2,3] || ARRAY[[4,5,6],[7,8,9.9]] \u2192 {{1,2,3},{4,5,6},{7,8,9.9}}"]}, {"title": "\u76ee\u5f55\u8bb0\u5f55\u89e3\u8bfb", "paragraphs": ["\u76ee\u5f55 pg_operator \u5b58\u50a8\u5173\u4e8e\u64cd\u4f5c\u7b26\u7684\u4fe1\u606f\u3002\u8be6\u89c1 CREATE OPERATOR \u548c \u7b2c 36.14 \u8282 \u3002"]}], "signature": "||(anycompatiblearray,anycompatiblearray) \u2192 anycompatiblearray", "source_oid": "375", "description": ["\u8fde\u63a5"], "memberships": [], "localization": {"status": "complete", "sources": [{"url": "/docs/18/catalog-pg-operator.html", "method": "same-major semantic node", "sha256": "7cfcd945bbbd55377dea8d4bd57380014caceb4e83c5db3be16c23eb5991d68f", "language": "zh", "matched_nodes": ["#CATALOG-PG-OPERATOR/p[2]"]}, {"url": "/docs/18/functions-array.html", "method": "same-major semantic node", "sha256": "0e8d3a063c256532ec483932c334b157e003cd25afc91aa6fb0a9f0a5fb0e039", "language": "zh", "matched_nodes": ["#FUNCTIONS-ARRAY/div[2]/div[1]/table[0]/tbody[2]/tr[3]/td[0]/p[1]"]}], "language": "zh", "original_text": {"/versions/18/description/0": "concatenate", "/versions/18/facts/0/label": "Left operand", "/versions/18/facts/1/label": "Right operand", "/versions/18/facts/2/label": "Result type", "/versions/18/facts/3/label": "Implementing function", "/versions/18/facts/4/label": "Operator kind", "/versions/18/facts/5/label": "Hash join candidate", "/versions/18/facts/5/value": "no", "/versions/18/facts/6/label": "Merge join candidate", "/versions/18/facts/6/value": "no", "/versions/18/related/0/label": "anycompatiblearray data type", "/versions/18/sections/0/title": "English manual definition", "/versions/18/sections/1/title": "Catalog interpretation", "/versions/18/sections/0/paragraphs/0": "Concatenates the two arrays. Concatenating a null or empty array is a no-op; otherwise the arrays must have the same number of dimensions (as illustrated by the first example) or differ in number of dimensions by one (as illustrated by the second). If the arrays are not of identical element types, they will be coerced to a common type (see Section 10.5 ).", "/versions/18/sections/1/paragraphs/0": "The catalog pg_operator stores information about operators. See CREATE OPERATOR and Section 36.14 for more information."}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "33f37ac47719d2a1596fbf8c4515af11d018bdb02c6a7f049523f96ef3487248"}, "comparison_data": {"operator": {"kind": "b", "symbol": "||", "negator": "", "function": "array_cat(anycompatiblearray,anycompatiblearray)", "hash_join": "f", "left_type": "anycompatiblearray", "commutator": "", "merge_join": "f", "right_type": "anycompatiblearray", "result_type": "anycompatiblearray"}, "memberships": []}, "comparison_hash": "bcb679177559f63619ba272b4580941aca7dfd52dd5b0fece7e7d25c92d6a34a", "manual_semantics": "Exact operand/result signature matched"}, "19": {"facts": [{"label": "\u5de6\u64cd\u4f5c\u6570", "value": "anycompatiblearray"}, {"label": "\u53f3\u64cd\u4f5c\u6570", "value": "anycompatiblearray"}, {"label": "\u8fd4\u56de\u7c7b\u578b", "value": "anycompatiblearray"}, {"label": "\u5b9e\u73b0\u51fd\u6570", "value": "array_cat(anycompatiblearray,anycompatiblearray)"}, {"label": "\u64cd\u4f5c\u7b26\u79cd\u7c7b", "value": "Binary"}, {"label": "\u53ef\u7528\u4e8e\u54c8\u5e0c\u8fde\u63a5", "value": "\u5426"}, {"label": "\u53ef\u7528\u4e8e\u5f52\u5e76\u8fde\u63a5", "value": "\u5426"}], "tables": [], "aliases": ["||", "||(anycompatiblearray,anycompatiblearray)"], "related": [{"url": "/wiki/type/anycompatiblearray/?v=19", "label": "anycompatiblearray \u6570\u636e\u7c7b\u578b"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v19beta4/postgresql-19beta4.tar.bz2", "label": "19beta4", "major": "19", "channel": "preview", "revision": "83157ee9c599d03b2f7a3d73ef3a56ec24e0e79cc2b3501a64d1364f56398c86", "source_sha256": "83157ee9c599d03b2f7a3d73ef3a56ec24e0e79cc2b3501a64d1364f56398c86", "manual_fingerprint": "d1c30d7808d3ae2edc8773a0dd66f7beb5861e8939001e171c1908f7a09bb497", "catalog_fingerprint": "9af4323d0c8ed03d0e795331930bd14ce9bf6193c6b766c463b9f6ec0829409a"}, "sources": [{"url": "https://ftp.postgresql.org/pub/source/v19beta4/postgresql-19beta4.tar.bz2", "label": "Matching PostgreSQL source archive", "sha256": "83157ee9c599d03b2f7a3d73ef3a56ec24e0e79cc2b3501a64d1364f56398c86"}, {"url": "https://pg.center/docs/19/catalog-pg-operator.html", "path": "catalog-pg-operator.html", "label": "PostgreSQL 19 English manual: catalog-pg-operator.html", "sha256": "fa89c3d5f2ba2adfe53192fd39c819efc78a22998994feed5fd4239bedaa938a", "language": "en", "original_url": "/docs/19/catalog-pg-operator.html"}, {"url": "https://pg.center/docs/19/catalog-pg-amop.html", "path": "catalog-pg-amop.html", "label": "PostgreSQL 19 English manual: catalog-pg-amop.html", "sha256": "711850fdde973fbaf16da94143a2de3b972bed7a3b8663bf80e4aeabaf2f43fe", "language": "en", "original_url": "/docs/19/catalog-pg-amop.html"}, {"url": "https://pg.center/docs/19/functions-array.html#ARRAY-OPERATORS-TABLE", "path": "functions-array.html", "label": "PostgreSQL 19 English manual: functions-array.html", "sha256": "d7cfbba448f2dbbf83e1e6c8f26811fae4bf09dc1d4861c21660b8831c3ad69e", "language": "en", "original_url": "/docs/19/functions-array.html#ARRAY-OPERATORS-TABLE"}], "operator": {"kind": "b", "symbol": "||", "negator": "", "function": "array_cat(anycompatiblearray,anycompatiblearray)", "hash_join": "f", "left_type": "anycompatiblearray", "commutator": "", "merge_join": "f", "right_type": "anycompatiblearray", "result_type": "anycompatiblearray"}, "sections": [{"title": "\u82f1\u6587\u624b\u518c\u5b9a\u4e49", "paragraphs": ["\u8fde\u63a5\u4e24\u4e2a\u6570\u7ec4\u3002\u8fde\u63a5 null \u6216\u7a7a\u6570\u7ec4\u4e0d\u4f1a\u4ea7\u751f\u4efb\u4f55\u6548\u679c\uff1b\u5426\u5219\uff0c\u6570\u7ec4\u5fc5\u987b\u5177\u6709\u76f8\u540c\u7684\u7ef4\u6570\uff08\u5982\u7b2c\u4e00\u4e2a\u793a\u4f8b\u6240\u793a\uff09\uff0c\u6216\u7ef4\u6570\u76f8\u5dee\u4e00\u7ef4\uff08\u5982\u7b2c\u4e8c\u4e2a\u793a\u4f8b\u6240\u793a\uff09\u3002\u5982\u679c\u6570\u7ec4\u7684\u5143\u7d20\u7c7b\u578b\u4e0d\u540c\uff0c\u5219\u4f1a\u5c06\u5b83\u4eec\u5f3a\u5236\u8f6c\u6362\u4e3a\u540c\u4e00\u4e2a\u7c7b\u578b\uff08\u53c2\u89c1 \u7b2c 10.5 \u8282 \uff09\u3002", "ARRAY[1,2,3] || ARRAY[4,5,6,7] \u2192 {1,2,3,4,5,6,7}", "ARRAY[1,2,3] || ARRAY[[4,5,6],[7,8,9.9]] \u2192 {{1,2,3},{4,5,6},{7,8,9.9}}"]}, {"title": "\u76ee\u5f55\u8bb0\u5f55\u89e3\u8bfb", "paragraphs": ["\u76ee\u5f55 pg_operator \u5b58\u50a8\u5173\u4e8e\u64cd\u4f5c\u7b26\u7684\u4fe1\u606f\u3002\u8be6\u89c1 CREATE OPERATOR \u548c \u7b2c 36.14 \u8282 \u3002"]}], "signature": "||(anycompatiblearray,anycompatiblearray) \u2192 anycompatiblearray", "source_oid": "375", "description": ["\u8fde\u63a5"], "memberships": [], "localization": {"status": "complete", "sources": [{"url": "/docs/19/catalog-pg-operator.html", "method": "same-major semantic node", "sha256": "9debafecc544409918e14c4ab4498c5b52d41808968dccb8a5874794ef8e4ac1", "language": "zh", "matched_nodes": ["#CATALOG-PG-OPERATOR/p[2]"]}, {"url": "/docs/19/functions-array.html", "method": "same-major semantic node", "sha256": "21410c8a0e986c22adc0760e9d2f41c79c021aefe84016b3d15a55ea9dc0c452", "language": "zh", "matched_nodes": ["#FUNCTIONS-ARRAY/div[2]/div[1]/table[0]/tbody[2]/tr[3]/td[0]/p[1]"]}], "language": "zh", "original_text": {"/versions/19/description/0": "concatenate", "/versions/19/facts/0/label": "Left operand", "/versions/19/facts/1/label": "Right operand", "/versions/19/facts/2/label": "Result type", "/versions/19/facts/3/label": "Implementing function", "/versions/19/facts/4/label": "Operator kind", "/versions/19/facts/5/label": "Hash join candidate", "/versions/19/facts/5/value": "no", "/versions/19/facts/6/label": "Merge join candidate", "/versions/19/facts/6/value": "no", "/versions/19/related/0/label": "anycompatiblearray data type", "/versions/19/sections/0/title": "English manual definition", "/versions/19/sections/1/title": "Catalog interpretation", "/versions/19/sections/0/paragraphs/0": "Concatenates the two arrays. Concatenating a null or empty array is a no-op; otherwise the arrays must have the same number of dimensions (as illustrated by the first example) or differ in number of dimensions by one (as illustrated by the second). If the arrays are not of identical element types, they will be coerced to a common type (see Section 10.5 ).", "/versions/19/sections/1/paragraphs/0": "The catalog pg_operator stores information about operators. See CREATE OPERATOR and Section 36.14 for more information."}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "b2a55ba5cab0ce36318be37a8a8dfc1d83d5c60457bfd5850d5c06479a7b1abe"}, "comparison_data": {"operator": {"kind": "b", "symbol": "||", "negator": "", "function": "array_cat(anycompatiblearray,anycompatiblearray)", "hash_join": "f", "left_type": "anycompatiblearray", "commutator": "", "merge_join": "f", "right_type": "anycompatiblearray", "result_type": "anycompatiblearray"}, "memberships": []}, "comparison_hash": "bcb679177559f63619ba272b4580941aca7dfd52dd5b0fece7e7d25c92d6a34a", "manual_semantics": "Exact operand/result signature matched"}, "20": {"facts": [{"label": "\u5de6\u64cd\u4f5c\u6570", "value": "anycompatiblearray"}, {"label": "\u53f3\u64cd\u4f5c\u6570", "value": "anycompatiblearray"}, {"label": "\u8fd4\u56de\u7c7b\u578b", "value": "anycompatiblearray"}, {"label": "\u5b9e\u73b0\u51fd\u6570", "value": "array_cat(anycompatiblearray,anycompatiblearray)"}, {"label": "\u64cd\u4f5c\u7b26\u79cd\u7c7b", "value": "Binary"}, {"label": "\u53ef\u7528\u4e8e\u54c8\u5e0c\u8fde\u63a5", "value": "\u5426"}, {"label": "\u53ef\u7528\u4e8e\u5f52\u5e76\u8fde\u63a5", "value": "\u5426"}], "tables": [], "aliases": ["||", "||(anycompatiblearray,anycompatiblearray)"], "related": [{"url": "/wiki/type/anycompatiblearray/?v=20", "label": "anycompatiblearray \u6570\u636e\u7c7b\u578b"}], "release": {"ref": "https://ftp.postgresql.org/pub/snapshot/dev/postgresql-snapshot.tar.bz2", "label": "20devel", "major": "20", "channel": "devel", "revision": "4d3346909b201ac1648232cf290462a7070c119326f56196f1f0253ed80fae41", "source_sha256": "4d3346909b201ac1648232cf290462a7070c119326f56196f1f0253ed80fae41", "manual_fingerprint": "48fb9e20e9e1454fe93d367e75b949833c82c1c52c2b69314dfffe1c464f3f39", "catalog_fingerprint": "cc1a474e972c8c342cf17f37e2884c56cc4b114cb59407b0180e99cdcfffa5c5", "source_snapshot_utc": "26-Sep-2026 20:22"}, "sources": [{"url": "https://ftp.postgresql.org/pub/snapshot/dev/postgresql-snapshot.tar.bz2", "label": "Matching PostgreSQL source archive", "sha256": "4d3346909b201ac1648232cf290462a7070c119326f56196f1f0253ed80fae41"}, {"url": "https://pg.center/docs/devel/catalog-pg-operator.html", "path": "catalog-pg-operator.html", "label": "PostgreSQL 20 English manual: catalog-pg-operator.html", "sha256": "b8882bb8329f1659f719eb9397246146135c228892834fbd29325ed3030f17cb", "language": "en", "original_url": "/docs/devel/catalog-pg-operator.html"}, {"url": "https://pg.center/docs/devel/catalog-pg-amop.html", "path": "catalog-pg-amop.html", "label": "PostgreSQL 20 English manual: catalog-pg-amop.html", "sha256": "00fee8a631088b687e2d880e4091791ca30f9c69fca888c51ece463d1b9e1e61", "language": "en", "original_url": "/docs/devel/catalog-pg-amop.html"}, {"url": "https://pg.center/docs/devel/functions-array.html#ARRAY-OPERATORS-TABLE", "path": "functions-array.html", "label": "PostgreSQL 20 English manual: functions-array.html", "sha256": "cf0d049a52c36212dd10c521bbee3ae2462540c76344b7ee57d429d0f68ec9be", "language": "en", "original_url": "/docs/devel/functions-array.html#ARRAY-OPERATORS-TABLE"}], "operator": {"kind": "b", "symbol": "||", "negator": "", "function": "array_cat(anycompatiblearray,anycompatiblearray)", "hash_join": "f", "left_type": "anycompatiblearray", "commutator": "", "merge_join": "f", "right_type": "anycompatiblearray", "result_type": "anycompatiblearray"}, "sections": [{"title": "\u82f1\u6587\u624b\u518c\u5b9a\u4e49", "paragraphs": ["\u8fde\u63a5\u4e24\u4e2a\u6570\u7ec4\u3002\u8fde\u63a5 null \u6216\u7a7a\u6570\u7ec4\u4e0d\u4f1a\u4ea7\u751f\u4efb\u4f55\u6548\u679c\uff1b\u5426\u5219\uff0c\u6570\u7ec4\u5fc5\u987b\u5177\u6709\u76f8\u540c\u7684\u7ef4\u6570\uff08\u5982\u7b2c\u4e00\u4e2a\u793a\u4f8b\u6240\u793a\uff09\uff0c\u6216\u7ef4\u6570\u76f8\u5dee\u4e00\u7ef4\uff08\u5982\u7b2c\u4e8c\u4e2a\u793a\u4f8b\u6240\u793a\uff09\u3002\u5982\u679c\u6570\u7ec4\u7684\u5143\u7d20\u7c7b\u578b\u4e0d\u540c\uff0c\u5219\u4f1a\u5c06\u5b83\u4eec\u5f3a\u5236\u8f6c\u6362\u4e3a\u540c\u4e00\u4e2a\u7c7b\u578b\uff08\u53c2\u89c1 \u7b2c 10.5 \u8282 \uff09\u3002", "ARRAY[1,2,3] || ARRAY[4,5,6,7] \u2192 {1,2,3,4,5,6,7}", "ARRAY[1,2,3] || ARRAY[[4,5,6],[7,8,9.9]] \u2192 {{1,2,3},{4,5,6},{7,8,9.9}}"]}, {"title": "\u76ee\u5f55\u8bb0\u5f55\u89e3\u8bfb", "paragraphs": ["\u76ee\u5f55 pg_operator \u5b58\u50a8\u5173\u4e8e\u64cd\u4f5c\u7b26\u7684\u4fe1\u606f\u3002\u8be6\u89c1 CREATE OPERATOR \u548c \u7b2c 36.14 \u8282 \u3002"]}], "signature": "||(anycompatiblearray,anycompatiblearray) \u2192 anycompatiblearray", "source_oid": "375", "description": ["\u8fde\u63a5"], "memberships": [], "localization": {"status": "complete", "sources": [{"url": "/docs/devel/catalog-pg-operator.html", "method": "same-major semantic node", "sha256": "573e7b9d66caef244b2c03df37b3c4b39b92c1b0e7f32fa8bd3e09d17d5591be", "language": "zh", "matched_nodes": ["#CATALOG-PG-OPERATOR/p[2]"]}, {"url": "/docs/devel/functions-array.html", "method": "same-major semantic node", "sha256": "c656bb07e15d20cc07a0ebc9419d4e848e4b7a236a4b3103e6ac59dcc46773e4", "language": "zh", "matched_nodes": ["#FUNCTIONS-ARRAY/div[2]/div[1]/table[0]/tbody[2]/tr[3]/td[0]/p[1]"]}], "language": "zh", "original_text": {"/summary": "concatenate", "/category": "Pseudo-types", "/versions/20/description/0": "concatenate", "/versions/20/facts/0/label": "Left operand", "/versions/20/facts/1/label": "Right operand", "/versions/20/facts/2/label": "Result type", "/versions/20/facts/3/label": "Implementing function", "/versions/20/facts/4/label": "Operator kind", "/versions/20/facts/5/label": "Hash join candidate", "/versions/20/facts/5/value": "no", "/versions/20/facts/6/label": "Merge join candidate", "/versions/20/facts/6/value": "no", "/versions/20/related/0/label": "anycompatiblearray data type", "/versions/20/sections/0/title": "English manual definition", "/versions/20/sections/1/title": "Catalog interpretation", "/versions/20/sections/0/paragraphs/0": "Concatenates the two arrays. Concatenating a null or empty array is a no-op; otherwise the arrays must have the same number of dimensions (as illustrated by the first example) or differ in number of dimensions by one (as illustrated by the second). If the arrays are not of identical element types, they will be coerced to a common type (see Section 10.5 ).", "/versions/20/sections/1/paragraphs/0": "The catalog pg_operator stores information about operators. See CREATE OPERATOR and Section 36.14 for more information."}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "7530bd726b36650fdafee745e27eeca418f527f85dc7bfb1cbf90b056ccef012"}, "comparison_data": {"operator": {"kind": "b", "symbol": "||", "negator": "", "function": "array_cat(anycompatiblearray,anycompatiblearray)", "hash_join": "f", "left_type": "anycompatiblearray", "commutator": "", "merge_join": "f", "right_type": "anycompatiblearray", "result_type": "anycompatiblearray"}, "memberships": []}, "comparison_hash": "bcb679177559f63619ba272b4580941aca7dfd52dd5b0fece7e7d25c92d6a34a", "manual_semantics": "Exact operand/result signature matched"}}}, "snapshot": {"facts": [{"label": "\u5de6\u64cd\u4f5c\u6570", "value": "anycompatiblearray"}, {"label": "\u53f3\u64cd\u4f5c\u6570", "value": "anycompatiblearray"}, {"label": "\u8fd4\u56de\u7c7b\u578b", "value": "anycompatiblearray"}, {"label": "\u5b9e\u73b0\u51fd\u6570", "value": "array_cat(anycompatiblearray,anycompatiblearray)"}, {"label": "\u64cd\u4f5c\u7b26\u79cd\u7c7b", "value": "Binary"}, {"label": "\u53ef\u7528\u4e8e\u54c8\u5e0c\u8fde\u63a5", "value": "\u5426"}, {"label": "\u53ef\u7528\u4e8e\u5f52\u5e76\u8fde\u63a5", "value": "\u5426"}], "tables": [], "aliases": ["||", "||(anycompatiblearray,anycompatiblearray)"], "related": [{"url": "/wiki/type/anycompatiblearray/?v=18", "label": "anycompatiblearray \u6570\u636e\u7c7b\u578b"}], "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_sha256": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f", "manual_fingerprint": "fefce9e478eb2afe5e17e869492bbedc67dce23d317f0a5257240113d6496ebc", "catalog_fingerprint": "deec62e0f0c649d9d0d058ddd0b16bf41afffd569c3fd73949ff0971ce5cabd6"}, "sources": [{"url": "https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2", "label": "Matching PostgreSQL source archive", "sha256": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"}, {"url": "https://pg.center/docs/18/catalog-pg-operator.html", "path": "catalog-pg-operator.html", "label": "PostgreSQL 18 English manual: catalog-pg-operator.html", "sha256": "e0b1817914e5e8f9037955cd41e9a43584e9227fcc115784898ecdd9a6c0ecd6", "language": "en", "original_url": "/docs/18/catalog-pg-operator.html"}, {"url": "https://pg.center/docs/18/catalog-pg-amop.html", "path": "catalog-pg-amop.html", "label": "PostgreSQL 18 English manual: catalog-pg-amop.html", "sha256": "e65b90ee78eaf4b4da97ce5b08b972cee2e2660b882ec107be22eca47201f7d1", "language": "en", "original_url": "/docs/18/catalog-pg-amop.html"}, {"url": "https://pg.center/docs/18/functions-array.html#ARRAY-OPERATORS-TABLE", "path": "functions-array.html", "label": "PostgreSQL 18 English manual: functions-array.html", "sha256": "d84446981971a18b9bab327f3c737737f8cc290dd9963d1472c7e6cab60bea7c", "language": "en", "original_url": "/docs/18/functions-array.html#ARRAY-OPERATORS-TABLE"}], "operator": {"kind": "b", "symbol": "||", "negator": "", "function": "array_cat(anycompatiblearray,anycompatiblearray)", "hash_join": "f", "left_type": "anycompatiblearray", "commutator": "", "merge_join": "f", "right_type": "anycompatiblearray", "result_type": "anycompatiblearray"}, "sections": [{"title": "\u82f1\u6587\u624b\u518c\u5b9a\u4e49", "paragraphs": ["\u8fde\u63a5\u4e24\u4e2a\u6570\u7ec4\u3002\u8fde\u63a5 null \u6216\u7a7a\u6570\u7ec4\u4e0d\u4f1a\u4ea7\u751f\u4efb\u4f55\u6548\u679c\uff1b\u5426\u5219\uff0c\u6570\u7ec4\u5fc5\u987b\u5177\u6709\u76f8\u540c\u7684\u7ef4\u6570\uff08\u5982\u7b2c\u4e00\u4e2a\u793a\u4f8b\u6240\u793a\uff09\uff0c\u6216\u7ef4\u6570\u76f8\u5dee\u4e00\u7ef4\uff08\u5982\u7b2c\u4e8c\u4e2a\u793a\u4f8b\u6240\u793a\uff09\u3002\u5982\u679c\u6570\u7ec4\u7684\u5143\u7d20\u7c7b\u578b\u4e0d\u540c\uff0c\u5219\u4f1a\u5c06\u5b83\u4eec\u5f3a\u5236\u8f6c\u6362\u4e3a\u540c\u4e00\u4e2a\u7c7b\u578b\uff08\u53c2\u89c1 \u7b2c 10.5 \u8282 \uff09\u3002", "ARRAY[1,2,3] || ARRAY[4,5,6,7] \u2192 {1,2,3,4,5,6,7}", "ARRAY[1,2,3] || ARRAY[[4,5,6],[7,8,9.9]] \u2192 {{1,2,3},{4,5,6},{7,8,9.9}}"]}, {"title": "\u76ee\u5f55\u8bb0\u5f55\u89e3\u8bfb", "paragraphs": ["\u76ee\u5f55 pg_operator \u5b58\u50a8\u5173\u4e8e\u64cd\u4f5c\u7b26\u7684\u4fe1\u606f\u3002\u8be6\u89c1 CREATE OPERATOR \u548c \u7b2c 36.14 \u8282 \u3002"]}], "signature": "||(anycompatiblearray,anycompatiblearray) \u2192 anycompatiblearray", "source_oid": "375", "description": ["\u8fde\u63a5"], "memberships": [], "localization": {"status": "complete", "sources": [{"url": "/docs/18/catalog-pg-operator.html", "method": "same-major semantic node", "sha256": "7cfcd945bbbd55377dea8d4bd57380014caceb4e83c5db3be16c23eb5991d68f", "language": "zh", "matched_nodes": ["#CATALOG-PG-OPERATOR/p[2]"]}, {"url": "/docs/18/functions-array.html", "method": "same-major semantic node", "sha256": "0e8d3a063c256532ec483932c334b157e003cd25afc91aa6fb0a9f0a5fb0e039", "language": "zh", "matched_nodes": ["#FUNCTIONS-ARRAY/div[2]/div[1]/table[0]/tbody[2]/tr[3]/td[0]/p[1]"]}], "language": "zh", "original_text": {"/versions/18/description/0": "concatenate", "/versions/18/facts/0/label": "Left operand", "/versions/18/facts/1/label": "Right operand", "/versions/18/facts/2/label": "Result type", "/versions/18/facts/3/label": "Implementing function", "/versions/18/facts/4/label": "Operator kind", "/versions/18/facts/5/label": "Hash join candidate", "/versions/18/facts/5/value": "no", "/versions/18/facts/6/label": "Merge join candidate", "/versions/18/facts/6/value": "no", "/versions/18/related/0/label": "anycompatiblearray data type", "/versions/18/sections/0/title": "English manual definition", "/versions/18/sections/1/title": "Catalog interpretation", "/versions/18/sections/0/paragraphs/0": "Concatenates the two arrays. Concatenating a null or empty array is a no-op; otherwise the arrays must have the same number of dimensions (as illustrated by the first example) or differ in number of dimensions by one (as illustrated by the second). If the arrays are not of identical element types, they will be coerced to a common type (see Section 10.5 ).", "/versions/18/sections/1/paragraphs/0": "The catalog pg_operator stores information about operators. See CREATE OPERATOR and Section 36.14 for more information."}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "33f37ac47719d2a1596fbf8c4515af11d018bdb02c6a7f049523f96ef3487248"}, "comparison_data": {"operator": {"kind": "b", "symbol": "||", "negator": "", "function": "array_cat(anycompatiblearray,anycompatiblearray)", "hash_join": "f", "left_type": "anycompatiblearray", "commutator": "", "merge_join": "f", "right_type": "anycompatiblearray", "result_type": "anycompatiblearray"}, "memberships": []}, "comparison_hash": "bcb679177559f63619ba272b4580941aca7dfd52dd5b0fece7e7d25c92d6a34a", "manual_semantics": "Exact operand/result signature matched"}, "comparison": {"left": "17", "right": "18", "status": "unchanged", "diff": ""}}