>> >>
>> >> 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 do
On Sat, Apr 14, 2012 at 1:28 AM, Abel Abraham Camarillo Ojeda
wrote:
> On Sat, Apr 14, 2012 at 1:22 AM, wrote:
>>
>>
>> Hi,
>>
>> I am looking for a feature that would select from a table with
>> k1 a
>> k1 b
>> k1 c
>> k2 a
>> k3 b
>> k3 c
>> something like
>> k1 a b c
>> k2 a
>> k3 b
On Sat, Apr 14, 2012 at 1:22 AM, wrote:
>
>
> Hi,
>
> I am looking for a feature that would select from a table with
> k1 a
> k1 b
> k1 c
> k2 a
> k3 b
> k3 c
> something like
> k1 a b c
> k2 a
> k3 b c
> (Just all elements next to each other, with a space in between)
> or perhaps an arr
Hi,
I am looking for a feature that would select from a table with
k1 a
k1 b
k1 c
k2 a
k3 b
k3 c
something like
k1 a b c
k2 a
k3 b c
(Just all elements next to each other, with a space in between)
or perhaps an array output
k1 {a,b,c]
k2 {a}
k3 {b,c}
If such an operator exists, woul