I've scanned the postgres array docs but can't see a simple example of how to run a query, and StackOverflow questions all seem to be based around more complicated examples.
Aug 02, 2013 · Postgres Plus Advanced Server 9.3 Beta 1 Release Notes 9 1. json_agg(any record) – converts any record into json formatted data 2. to_json(any value) – converts any value into json formatted data 3. hstore_to_json(hstore) – casts the hstore value into json formatted data (requires the hstore contrib module)