by Rod Taylor <rbt@rbt.ca>

array -

Array iterator functions

Array iterator functions (now obsolete due to backend improvements)

by Massimo Dal Zotto <dz@cs.unitn.it>

btree_gist -

-- select tuples with all txt elements matching '^[A-Z]'

select * from t where '^[A-Z]' ~ all (t.txt[1:3]);

See the related section in the online documentation for more detail:

Table of Contents => Functions and Operators => Row and Array Comparisons

See this section in the PostgreSQL documentation for more detail:

The SQL Language => Functions and Operators => Row and Array Comparisons