unnest_ordinality

This Release
unnest_ordinality 1.0.1
Date
Status
Stable
Other Releases
Abstract
turn an array into a set of (element_number, element) pairs
Description
Fast unnest of a PostgreSQL array, with row number added
Released By
andrew
License
The PostgreSQL License
Resources
Special Files
Tags

Extensions

unnest_ordinality 1.0.1
turn an array into a set of (element_number, element) pairs

README

unnest_ordinality PostgreSQL Extension

Efficiently turn a Postgres array into a set of (element_number, array_element) pairs.

Should work with just about any modern version of PostgreSQL. Mainly tested with Release 9.2.

Building

make
make install

Using

andrew# create extension unnest_ordinality;

andrew=# select * from unnest_ordinality('{a,b,c,d,e,f,g}'::text[]);
 element_number | element 
----------------+---------
              1 | a
              2 | b
              3 | c
              4 | d
              5 | e
              6 | f
              7 | g