>> >>
>> >> 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