Document special array constructor for PostgreSQL

[seancorfield]

See https://www.postgresql.org/docs/current/sql-expressions.html#SQL-SYNTAX-ARRAY-CONSTRUCTORS

Add something to PG Tips & Tricks!

"It is also possible to construct an array from the results of a subquery. In this form, the array constructor is written with the key word ARRAY followed by a parenthesized (not bracketed) subquery. For example:"

SELECT ARRAY(SELECT oid FROM pg_proc WHERE proname LIKE 'bytea%');

You can create this syntax with [:'ARRAY {:select ..}]

[seancorfield]

dev=> (sql/format {:select [[[:'ARRAY {:select :oid :from :pg_proc :where [:like :proname [:inline "bytea%"]]}]]]})
["SELECT ARRAY (SELECT oid FROM pg_proc WHERE proname LIKE 'bytea%')"]