select open change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Extensions / Functions and aggregates

unnest_ordinality

Legacy array unnest function that returns each element with its ordinal position.

pgext.cloud · Source code · Documentation · License text · Control file · PGXN

Overview

Packageunnest_ordinality
Version1.0.1
PostgreSQL versions10 · 11 · 12 · 13 · 14 · 15 · 16 · 17 · 18
RepositoryUnspecified
Extension typeStandard
Project statusDeprecated
Requires CREATE EXTENSIONYes
Requires preloadNo
TrustedNo
RelocatableYes
Stars4
Latest commit2013-05-15
Latest release2013-04-19
Catalogue updated2026-08-30

Related extensions

See also

parray_ginGIN index operator class and partial-match operators for text arrays
arraymathArray math and operators that work element by element on the contents of arrays
jsonb_delete_arrayDelete jsonb keys or string elements listed in a text array
numpgsqlArray and numerical computing library for PostgreSQL
eigenNew array types and linear-algebra functions based on the Eigen numerical template library.
json_buildC functions and aggregate helpers for building complex PostgreSQL JSON objects and arrays.
array_textsortC functions for sorting and de-duplicating one-dimensional text arrays.
pg_array_multi_indexsimultaneous multiple-indexing of PostgreSQL arrays