On Mon, Jul 27, 2015 at 12:53 PM, Alex Magnum <magnum11...@gmail.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) Regards, Dinesh manojadinesh.blogspot.com Thanks > A >