Hi,
Could anyone give me a few pointers as to how I might resolve the following : select json_agg(my_table) from (my_table) where foo='test' and bar='f' order by last_name asc, first_name asc; ERROR: column "my_table.last_name" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: ...foo='f' order by last_name ... I suspect It doesn't really matter what my table looks like for the purposes of the above, but if you need something to go by: create table my_table( last_name text, first name text, foo text, bar boolean ); Thanks ! Bob -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
