Functions / Array Functions And Operators

cardinality

Returns the total number of elements in the array, or 0 if the array is empty.

Reading PG 18current·documented in 14 of 27 versions, 9.4 to 20

Signatures & examples

cardinality ( anyarray ) → integer

Returns the total number of elements in the array, or 0 if the array is empty.

cardinality(ARRAY[[1,2],[3,4]]) → 4

Version history 2

Definition snapshot: 2026-09-14T13:14:25.684213+00:00@99e6866c · English manual source