>> >> >> >> Hi, >> >> >> >> I am looking for a feature that would select from a table with >> >> >> >> If such an operator exists, would there be a "remove duplicates" option? >> >> >> >> Regards >> >> Wolfgang Hamann >> >> >> > >> > select k, array_agg(distinct val ) from t; >> > >> > See the docs: http://www.postgresql.org/docs/9.1/static/sql-expressions.h= >> tml#SYNTAX-AGGREGATES >> >> obviously I forgot the group by: >> >> >> select k, array_agg(distinct val ) from t group by k;
Hi Abel, thanks a lot. Regards Wolfgang Hamann -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
