On Wed, Oct 29, 2008 at 2:59 PM, WaGathoni <is.mundu@xxxxxxxxx> wrote: > ....failing with an error to the effect that that that > coa.doaIhaveChildren and coa.coa_id must be included in the GROUP BY > clause.... and what is is the recommended course of action. Generally the solution in postgresql is its proprietary extension of distinct on () select distinct on (field1, field2) field1, field2, field3 from .... -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
