PostgreSQL/Array/array dims

Using array_dims()

   <source lang="sql">

postgres=# CREATE TABLE book (id integer,titles text[]); CREATE TABLE postgres=# postgres=# INSERT INTO book VALUES (102, "{"AAA\"s VVVV"}"); INSERT 0 1 postgres=# INSERT INTO book VALUES (103, "{"AAA", "VVVV"}"); INSERT 0 1 postgres=# postgres=# -- Using array_dims(?) postgres=# SELECT array_dims(titles) FROM book;

array_dims

---

[1:1]
[1:2]

(2 rows) postgres=# drop table book; DROP TABLE postgres=#

      </source>