Re: Sorting CSV string and removing Duplicates

Hi Danish, yes thats the one I was looking for. Thanks a lot!!!

On Tue, Jul 28, 2015 at 1:32 AM, dinesh kumar <dineshkumar02(at)gmail(dot)com>
wrote:

>
>
> On Mon, Jul 27, 2015 at 12:57 PM, dinesh kumar <dineshkumar02(at)gmail(dot)com>
> wrote:
>
>> On Mon, Jul 27, 2015 at 12:53 PM, Alex Magnum <magnum11200(at)gmail(dot)com>
>> wrote:
>>
>>> Hello,
>>>
>>> I have a csv string in a text field that is unsorted and contains
>>> duplicates.
>>> Is there a simple way to remove these and sort the string.
>>>
>>> E.g
>>> 2,18,20,23,1,27,1,2,8,16,17,18,20,22,23,27
>>>
>>> i tried string to array and unique but that did not work...
>>> Any suggestions on how to do this without writing a function?
>>>
>>> Any help is appreciated.
>>>
>>>
>> Are you looking for this.
>>
>> postgres=# SELECT unnest(string_to_array(t, ',')) from test group by 1;
>> unnest
>> --------
>> 2
>> 18
>> 8
>> 20
>> 22
>> 16
>> 27
>> 17
>> 23
>> 1
>> (10 rows)
>>
>>
> OR
>
> Might be something like this
>
> postgres=# WITH sortedstring as
> postgres-# (
> postgres(# SELECT unnest(string_to_array(t, ','))::int from test group by
> 1 ORDER BY 1
> postgres(# ) SELECT array_agg(unnest) FROM sortedstring;
> array_agg
> ------------------------------
> {1,2,8,16,17,18,20,22,23,27}
> (1 row)
>
>
> Regards,
> Dinesh
> manojadinesh.blogspot.com
>
>
>>
>> Regards,
>> Dinesh
>> manojadinesh.blogspot.com
>>
>> Thanks
>>> A
>>>
>>
>>
>