QUERY: SELECT * FROM arrtest; a |b |c |d |e -----------+---------------+-------------+-----------------+------------- {1,2,3,4,5}|{{{0,0},{1,2}}}|{} |{} | {11,12,23} |{{3,4},{4,5}} |{"foobar"} |{{"elt1","elt2"}}|{"3.4","6.7"} {} |{3,4} |{"foo","bar"}|{"bar","foo"} | (3 rows) QUERY: SELECT arrtest.a[1], arrtest.b[1][1][1], arrtest.c[1], arrtest.d[1][1], arrtest.e[0] FROM arrtest; a|b|c |d |e --+-+------+----+- 1|0| | | 11| |foobar|elt1| | |foo | | (3 rows) QUERY: SELECT arrtest.a[1:3], arrtest.b[1:1][1:2][1:2], arrtest.c[1:2], arrtest.d[1:1][1:2] FROM arrtest; a |b |c |d ----------+---------------+-------------+----------------- {1,2,3} |{{{0,0},{1,2}}}| | {11,12,23}| | |{{"elt1","elt2"}} | |{"foo","bar"}| (3 rows) QUERY: SELECT array_dims(arrtest.b) AS x; x --------------- [1:1][1:2][1:2] [1:2][1:2] [1:2] (3 rows) QUERY: SELECT * FROM arrtest WHERE arrtest.a[1] < 5 and arrtest.c = '{"foobar"}'::_char16; a|b|c|d|e -+-+-+-+- (0 rows) QUERY: SELECT arrtest.a[1:3], arrtest.b[1:1][1:2][1:2], arrtest.c[1:2], arrtest.d[1:1][1:2] FROM arrtest; a |b |c |d ----------+---------------+-------------+----------------- {1,2,3} |{{{0,0},{1,2}}}| | {11,12,23}| | |{{"elt1","elt2"}} | |{"foo","bar"}| (3 rows)