Extensions
- unnest_ordinality 1.0.0
- 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