||(anycompatiblearray,anycompatiblearray)

concatenate

Reading PostgreSQL 18.6.

Description

concatenate

Left operand: anycompatiblearray
Right operand: anycompatiblearray
Result type: anycompatiblearray
Implementing function: array_cat(anycompatiblearray,anycompatiblearray)
Operator kind: Binary
Hash join candidate: no
Merge join candidate: no

Usage

||(anycompatiblearray,anycompatiblearray) → anycompatiblearray

English manual definition

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 ).

ARRAY[1,2,3] || ARRAY[4,5,6,7] → {1,2,3,4,5,6,7}

ARRAY[1,2,3] || ARRAY[[4,5,6],[7,8,9.9]] → {{1,2,3},{4,5,6},{7,8,9.9}}

Catalog interpretation

The catalog pg_operator stores information about operators. See CREATE OPERATOR and Section 36.14 for more information.

Related entries

anycompatiblearray data type

Documentation and source

Source build

Version: 18.6
Build: https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2
Source fingerprint: 555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f

Compare versions

PostgreSQL 13 → 14: added.

--- PostgreSQL 13
+++ PostgreSQL 14
@@ -1 +1,15 @@
-Not recorded in this version
+{
+  "memberships": [],
+  "operator": {
+    "commutator": "",
+    "function": "array_cat(anycompatiblearray,anycompatiblearray)",
+    "hash_join": "f",
+    "kind": "b",
+    "left_type": "anycompatiblearray",
+    "merge_join": "f",
+    "negator": "",
+    "result_type": "anycompatiblearray",
+    "right_type": "anycompatiblearray",
+    "symbol": "||"
+  }
+}

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

Related entries

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